The below simple shell script will check all filesystems and create output file for only filesystems which are more than…
The Below Shell Script checks the Filesystem mount points and using AWK outputs all filesystem exceeding 90% space to a…
Synonym is an alternative name for a table, view, sequence, procedure, stored function, package, materialized view, Java class schema object,…
While installing Oracle 12c on Linux you can get this error. The solution is very easy just unset the ORA_CRS_HOME…
Script to check no. of cores being utilized by a process in linux. Save the script below as a shell…
When user upload a xml file into schema, it was hang during upload operation and then it shows Ora-12801 error.…
One of the best sites for scripts related to checking library cache locks… http://allappsdba.blogspot.qa/2012/04/to-check-library-cache-lock-contention.html
The “Library Cache Pin” wait event is generally a wait event associated with library cache concurrency. Generally the wait event…
ORA-00245: control file backup failed; target is likely on a local file system RMAN-08132: WARNING: cannot update recovery area reclaimable…