Check the Usage of SGA in Oracle
Check SGA total size and free space usage in Oracle Check the Usage of SGA select round(used.bytes /1024/1024 ,2) used_mb , round(free.bytes /1024/1024 ,2) free_mb , round(tot.bytes /1024/1024 ,2) total_mb…
Check SGA total size and free space usage in Oracle Check the Usage of SGA select round(used.bytes /1024/1024 ,2) used_mb , round(free.bytes /1024/1024 ,2) free_mb , round(tot.bytes /1024/1024 ,2) total_mb…
Check and Change Default Tablespace for User in Oracle Check the User default tablespace select username,default_tablespace from dba_users where username = ‘MDSYS’; USERNAME DEFAULT_TABLESPACE ——– —————— MDSYS SYSAUX In this…
Monitor the gap between data guard physical Standby with email alert Create a database link between the primary and standby link: — Create a database line on primary server linking…
Assign Sudo privileges to the user in Oracle Linux Login with the root user and open the sudoers file $ vi /etc/sudoers OR $ visudo Then go to the session…
ORA-1653: unable to extend table HR.TEST by 8192 in tablespace DATA_1 An error occurs during the insertion operation: ORA-1653: unable to extend table HR.TEST by 8192 in tablespace DATA_1 Error:…
Useful SQL script for Data guard environment Check the data guard information on primary and Standby SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS FROM V$DATABASE Check the error or…
Check the archive log status in Oracle Data guard Check the received and applied archive log on the Oracle Dataguard environment select ‘Last Log applied : ‘ Logs, to_char(next_time,’DD-MON-YY:HH24:MI:SS’) Time…
How to find the maximum user doing commit operation or transaction in Oracle DB Script helpful in tracking the number of transactions in the database. Note: It used the AWR…