AWR, Automatic Workload Respository The Oracle AWR, Automatic Workload Respository, is tored in the SYSAUX tablespace. This post conatians information useful for purging/cleaning the AWR when it becomes large due to failure of cleanup jobs…
Find the process id – Example : Oracle Listener Display the Environment Variables
lspatches – list patches -all_nodes – RAC system
Rename and compress listener.log file [grid@server]$ lsnrctl LSNRCTL> set current_listener listener LSNRCTL> set log_status off [grid@server]$ mv listener.log listener.log.temp [grid@server]$ lsnrctl LSNRCTL> set current_listener listener LSNRCTL> set log_status on — compress (or delete) [grid@server]$ gzip…
Display locks in Oracle database [Look for UBABLK in gv$transaction – if value remains static for a while, the transaction is potentially blocked
Installing and Configuring Oracle Clusterware The installation procedure for Oracle clusterware (Grid Infrastructure) is well documented in Oracle documentation. This post contains the titles of MOS documents that will be useful before, during, or after…
To search for an object in all databases in a MS SQL Server Instance: Link Search for Object in all databases
Red Hat Linux – display system reboot who -b uptime