Alter datafile online or offline in Oracle
Check the status of online or offline for datafile in Oracle Check the status of datafile Select file#, status from v$datafile; OR SELECT FILE_NAME,ONLINE_STATUS FROM DBA_DATA_FILES; Take the data file…
Check the status of online or offline for datafile in Oracle Check the status of datafile Select file#, status from v$datafile; OR SELECT FILE_NAME,ONLINE_STATUS FROM DBA_DATA_FILES; Take the data file…
Check datafiles and tablespace information in Oracle Check information about datafiles SQL> select * from dba_data_files; SQL> select * from v$datafile; Check information about tablespace SQL> select * from dba_tablespaces SQL>…
Check the Undo tablespace total, free and used space usage in Oracle Check the undo tablespace total, free and used space(Size in MB) in Oracle SELECT a.tablespace_name, SIZEMB, USAGEMB, (SIZEMB…
Find the date and patch number applied in Oracle Database. List the patches applied in Oracle Database Go to directory CD %ORACLE_HOME%\OPatch opatch lspatches List the patches with lsinventory –…
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…