ADVERTISEMENT

ADVERTISEMENT

Sitemap

Browse through our website's structured categories and posts to find what interests you.

DBA Scripts

  1. Start and Stop MRP in Oracle Data Guard
  2. How to Manage Restricted Mode in Oracle Database
  3. Exploring Access Control Lists (ACL) Privileges in Oracle
  4. How to Backup User Passwords in Oracle
  5. Oracle Job Scheduler Commands for Task Automation
  6. Database Flashback Commands
  7. Oracle SQL Scripts for User Password, Account Info, and History
  8. Oracle Tablespace Management
  9. Oracle Session Management
  10. How to Find Oracle Database Size
  11. Monitoring Oracle Database Growth and Space Utilization
  12. Generate AWR, ASH, ADDM Reports from SQL Prompt
  13. Oracle RMAN: Scripts to Monitor Backup Progress
  14. How to Check Hidden Parameters in Oracle
  15. Oracle Tablespace Quota Management Script
  16. Monitor Long Operations in Oracle
  17. SQL Query to Check User-wise INACTIVE Session Count in Oracle
  18. RMAN Commands Reference
  19. Oracle GoldenGate Commands Reference
  20. OPatch Command Usage for Oracle Patch Management
  21. ADRCI Commands for Managing Oracle Diagnostics
  22. Data Guard Broker Commands for Managing Oracle Database
  23. CRSCTL Commands for Managing Oracle Clusterware Services
  24. SRVCTL Commands for Managing Oracle RAC Services
  25. ASMCMD Command Guide
  26. Retrieve All Key Oracle Database Information with a Single Query
  27. Kill or Disconnect Oracle Session in Single Instance & RAC
  28. Essential Linux Commands for Oracle DBA
  29. How to Find When a User’s Password Was Last Changed in Oracle
  30. Backing Up Oracle Directories and Grants
  31. Fixing Index Ownership Issues in Oracle
  32. How to Create an SQL Baseline for a Specific SQL_ID
  33. How to Get DDL for Oracle Objects
  34. A Comprehensive Guide to Fast Recovery Area (FRA) in Oracle
  35. How to Recompile Invalid Schema Objects in Oracle
  36. Oracle User Management: A Complete Guide
  37. SQL Query to Check Object Count in Oracle Schema

Oracle

  1. How to Connect to Oracle Database Using SQL*Plus
  2. Oracle ACID Properties Explained with Examples
  3. Revoke All Privileges from a User in Oracle
  4. How to Grant All Privileges to a User in Oracle
  5. How to Disable Oracle Scheduler Jobs: Job Queue Processes, Memory, SPFILE, RAC, and Non-SYS Jobs
  6. How to Resolve RMAN Duplicate Failure Due to Wallet Not Open
  7. Setting Up UTL_MAIL in Oracle Database: A Step-by-Step Guide
  8. Fixing ORA-39173: Exporting Encrypted Data Without Encryption
  9. Flashback Recovery Info in Oracle: A Complete Guide
  10. How to Check Resource Limits and Utilization History in Oracle
  11. What is UNDO_RETENTION: How It Works and Why It Matter
  12. Oracle Data Guard: Features, Configuration & Best Practices
  13. Is AI Dangerous for the Oracle DBA Role?
  14. Start and Stop MRP in Oracle Data Guard
  15. Managing Database Links in Oracle: A Step-by-Step Guide
  16. Resolving RMAN-06617 Error in RMAN Duplicate Command
  17. How to Fix ORA-01017: invalid username/password; logon denied
  18. How to Resolve In-Doubt 2PC Transactions in Oracle Database
  19. How to Manage Restricted Mode in Oracle Database
  20. Exploring Access Control Lists (ACL) Privileges in Oracle
  21. How to Kill Oracle Export/Import Jobs
  22. How to Backup User Passwords in Oracle
  23. What Is ORA-01720: ‘Grant Option Does Not Exist’ and How Do You Fix It?
  24. Oracle Job Scheduler Commands for Task Automation
  25. Database Flashback Commands
  26. Oracle SQL Scripts for User Password, Account Info, and History
  27. Oracle Tablespace Management
  28. Crontab in Linux: Examples and Useful Commands
  29. Oracle Database Patching: Common Steps
  30. Oracle Session Management
  31. How to Find Oracle Database Size
  32. Monitoring Oracle Database Growth and Space Utilization
  33. How to Resolve a Hung AWR Process in Oracle
  34. What is an SSH Key and How to Add One in Oracle
  35. Generate AWR, ASH, ADDM Reports from SQL Prompt
  36. Understanding the Find Command
  37. Oracle RMAN: Scripts to Monitor Backup Progress
  38. How to Fix ORA-39095: Dump File Space Has Been Exhausted
  39. How to Export & Import Statistics in Oracle Database
  40. How to Check Hidden Parameters in Oracle
  41. Step-by-Step Guide to Creating and Executing a SQL Tuning Task
  42. Oracle Tablespace Quota Management Script
  43. Monitor Long Operations in Oracle
  44. Understanding SQL>@?/rdbms/admin/sqltrpt.sql: A Detailed Guide
  45. SQL Query to Check User-wise INACTIVE Session Count in Oracle
  46. RMAN Commands Reference
  47. Oracle DATAPUMP EXPDP/IMPDP Monitoring Scripts
  48. Oracle GoldenGate Commands Reference
  49. Everything You Need to Know About Oracle NLS_DATE_FORMAT
  50. OPatch Command Usage for Oracle Patch Management
  51. ADRCI Commands for Managing Oracle Diagnostics
  52. Data Guard Broker Commands for Managing Oracle Database
  53. CRSCTL Commands for Managing Oracle Clusterware Services
  54. SRVCTL Commands for Managing Oracle RAC Services
  55. ASMCMD Command Guide
  56. Retrieve All Key Oracle Database Information with a Single Query
  57. Understanding Oracle DB Character Set (CHARSET)
  58. What is Sudo Access for Oracle DBAs and Why It’s Important
  59. Understanding the oratab File in Oracle: Role and Usage
  60. Script to Track Top 10 CPU-Consuming Oracle Sessions
  61. Kill or Disconnect Oracle Session in Single Instance & RAC
  62. Identify and Terminate Active Statistics Collection Job in Database
  63. What is a .PAR File and How It Works
  64. How to Resolve ORA-01653: Unable to Extend Table in Tablespace
  65. Essential Linux Commands for Oracle DBA
  66. How to Find When a User’s Password Was Last Changed in Oracle
  67. Backing Up Oracle Directories and Grants
  68. How to Fix ORA-01536: Space Quota Exceeded Error in Oracle
  69. Fixing Index Ownership Issues in Oracle
  70. How to Create an SQL Baseline for a Specific SQL_ID
  71. How to Get DDL for Oracle Objects
  72. A Comprehensive Guide to Fast Recovery Area (FRA) in Oracle
  73. How to Recompile Invalid Schema Objects in Oracle
  74. Oracle User Management: A Complete Guide
  75. Oracle PFILE vs SPFILE: Key Differences and Usage Guide
  76. SQL Query to Check Object Count in Oracle Schema
  77. Oracle GoldenGate: Correct Start/Stop Sequence for Data Integrity
  78. How to Keep Processes Running in the Background with nohup
  79. What is Proxy Access in Oracle and How to Use It
  80. What are Oracle Restore Points and How to Use Them
  81. How to Monitor and Identify Failed Login Attempts in Oracle
  82. How to Create an Oracle Directory for Export/Import
  83. How to Monitor Archive Log Generation in Oracle: Best Practices
  84. Oracle Data Pump Import (IMPDP): A Complete Guide
  85. Oracle Data Pump Export (EXPDP): A Complete Guide
  86. Oracle DBA Roles and Responsibilities
  87. Database vs. DBMS: Key Differences Explained

ADVERTISEMENT