Oracle Dba

How to Stop Oracle Data Guard Broker Using ALTER SYSTEM Command Purpose The command ALTER SYSTEM SET dg_broker_start=false stops the Oracle Data Guard broker by shutting down the Data Guard monitor (DMON) background process. This command is essential when you need to disable broker management temporarily for …

How to Change Oracle AWR Retention Period to 14 Days using dbms_workload_repository.modify_snapshot_settings Purpose The Oracle code changes the Automatic Workload Repository (AWR) retention period from the default 8 days to 14 days (two weeks). This allows database administrators to store performance snapshots for a …

How to Uninstall Oracle Statspack Using the spdrop Script - Complete Guide Oracle Statspack uninstallation is accomplished using the @?/rdbms/admin/spdrop command, which completely removes the Statspack performance monitoring framework from your Oracle database. This command removes all associated objects including the …

Oracle SQL Performance Analysis Query - Monitor SQL Execution Statistics Purpose This Oracle SQL query is designed to analyze the performance characteristics of a specific SQL statement by examining key execution metrics stored in the v$sqlarea dynamic performance view. Database administrators and performance analysts …

Query to Display All Tablespaces Used by A Specified User and The Total Space Occupied (rounded to MB) A schema audit before a migration, a quota review before approving more space, or a tablespace consolidation project all start with the same question: which tablespaces does a specific Oracle user actually touch, and …

Oracle Table Privileges Granted to a Role via role_tab_privs Purpose ROLE_TAB_PRIVS holds the complete inventory of object privileges Oracle has packaged into each named role — every table, view, and sequence grant, the precise privilege type, whether the right covers the entire object or is scoped to a single column, …