Oracle Dba
Oracle AWR: Change Retention Period to 14 Days
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 …
Read MoreOracle: Uninstall Statspack Using the spdrop Script
Sep 6, 2025 / · 5 min read · oracle database statspack database administration performance tuning sql plus oracle dba database cleanup oracle scripts ·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 …
Read MoreOracle SQL Execution Statistics Query with v$sqlarea
Aug 9, 2025 / · 3 min read · oracle sql performance database tuning v$sqlarea performance monitoring query optimization oracle dba sql statistics v$sql v$sql_plan ·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 …
Read MoreOracle Table Privileges Granted to a Role via role_tab_privs
Jan 4, 2024 / · 10 min read · role privileges show_table_role_privileges oracle role_tab_privs Oracle DBA Security Audit Data Dictionary Oracle Administration ·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, …
Read More