Useful CRSCTL Commands

STOP & START CRS: ( run from root user) $GRID_HOME/bin/crsctl stop crs $GRID_HOME/bin/crsctl start crs Enable/Disable auto restart of CRS. $GRID_HOME/bin/crsctl disable crs ...

Job DDL

Creates the DDL for the specified job:- SET LONG 20000 LONGCHUNKSIZE 20000 PAGESIZE 0 LINESIZE 1000 FEEDBACK OFF VERIFY OFF TRIMSPOOL ON BEGIN DBMS_METADATA.set_transform_param ...

DDL of Foreign key

Script to create foreign key DDL on all tables. SET LONG 20000 LONGCHUNKSIZE 20000 PAGESIZE 0 LINESIZE 1000 FEEDBACK OFF VERIFY OFF TRIMSPOOL ON BEGIN DBMS_METADATA.set_transform_param ...

The SQLAccess Advisor

DBMS_ADVISOR :- 1. Gather a number of SQL statements that will form the tuning workload. 2. Check that the user running DBMS_ADVISOR has the ADVISOR privilege, and has SELECT access to the tables ...

Useful TFACTL Commands

1. Check tfactl status with version: tfactl status 2. Check tfactl tool status: tfactl toolstatus 3. Get config details: tfactl print config 4. List of user having access to tfactl: tfactl access ...

PDB Lockdown Profiles In Oracle 12.2

ALTER LOCKDOWN PROFILE statement to alter a PDB lockdown profile. You can use PDB lockdown profiles in a multitenant environment to restrict user operations in pluggable databases (PDBs). Create ...

SGA TARGET ADVISORY IN ORACLE

The V$SGA_TARGET_ADVICE view provides information that helps us in deciding optimal value for  SGA_TARGET. MMON background process gather statistics about sga_target usage and update the ...

Start typing and press Enter to search