Managing Database
Startup and Shutdown Procedure
Setting NLS_LANG_Environment variable for Windows and Unix for Oracle Database
SQL*Plus Customize User Profile
Capture Failed SQL using servererror trigger
Bypass the execution of the AFTER LOGIN trigger
How to lock/unlock statistics on a table
Progress status of index rebuild/creation or long operation
How to check last Password Change time for a user in Oracle
Check Materialize View Refresh Schedule
How to check MAXDATAFILES,MAXLOGHISTORY,MAXINSTANCES,MAXLOGFILES,MAXLOGMEMEBERS
How to Flush Single SQL Plan out of Shared Pool
Change SYS password in Data Guard environment
Read Alert log from x$dbgalertext
Dead Connection Detection, Resource Limits, V$SESSION, V$PROCESS and OS processes
Writing data into OS text file from Database Using UTL_FILE
Clone Grid Home and Oracle Home
Oracle RDS:
How to Transfer file from AWS RDS for Oracle to Other Oracle Server