Recent posts

How to Safely Remove an Oracle ACFS File System and ASM Volume

How to Safely Remove an Oracle ACFS File System and ASM Volume If you no longer need an O…

Read more

UTL file Test code

UTL file Test code -- Test code for Oracle 12c+ (Create file in DBA directory) mkdir -p /…

Read more

RMAN-05520: Database Name Mismatch (Auxiliary Has PROD, Command Specified CLONE)

RMAN-05520: Database Name Mismatch (Auxiliary Has PROD, Command Specified CLONE) Error W…

Read more

RMAN-06034: At Least 1 Channel Must Be Allocated to Execute This Command

RMAN-06034: At Least 1 Channel Must Be Allocated to Execute This Command Error Message R…

Read more

Oracle Database Session Control: RESOURCE_LIMIT, CONNECT_TIME, and IDLE_TIME

Oracle Database Session Control: RESOURCE_LIMIT, CONNECT_TIME, and IDLE_TIME Overview Or…

Read more

Query to Show Parameter Change History with Time

Query to Show Parameter Change History with Time SELECT      p1.snap_id,     TO_CHAR(s.be…

Read more