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 …
-
DataguardOracle
Schedule monitor archive gap script for Dataguard physical standby sync
by tuanlpby tuanlpMonitor 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 …
-
DataguardOracle
Check the last applied and shipped archive log in Oracle Dataguard
by tuanlpby tuanlpCheck 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 …