Hidden parameters in Oracle always start with an underscore. It is not possible for the DBA to see the hidden parameters with the SQL*Plus command “show parameter” or by querying v$parameter. Unless the hidden parameter is explicitly set in spfile/init.ora file. How Can I list all Hidden Parameters set in The database? As they are […]
Category: Reports
Ultimate Database Health Check (DBMS_HM)
The Oracle DBA wants to run Health Checks command with Health Monitor upon his database. With Oracle 12c/18c, these checks can be done on a regular basis daily/monthly: – DB Structure Integrity Check – CF Block Integrity Check – Data Block Integrity Check – Redo Integrity Check – Transaction Integrity Check – Undo Segment Integrity […]
Generate user DDL with dbms_metadata.get_ddl user
Download Brave : Secure, Fast & Private Browser with Adblocker The oracle DBA can use these 2 scripts to generate DDL statements for a user with their roles, system and object privileges. For Oracle 18c / 12c / 11g / 10g: clear screen accept uname prompt ‘Enter User Name : ‘ accept outfile prompt ‘ […]
Flash Recovery Area (FRA)
Download Brave : Secure, Fast & Private Browser with Adblocker Sometimes the Flash Recovery Area (FRA) is full and the Oracle DBA wants to know what is it’s usage, size and the list of occupants (archives, RMAN backups pieces or image copies, flashback logs). To Enable or Disable the FRA, it’s in another post here. […]
How to extract DDL for scheduler jobs owned by SYS?
We can’t export scheduler jobs which are owned by SYS user, even in Oracle 18c and 12c. If you try to get DDL for scheduler jobs owned by SYS you’ll hit ORA-31603 error. The solution of this problem is to copy the scheduler job to another user (e.g. vfenoll) and then extract the DDL with dbms_metadata. […]