Script to check Running database operations in oracle database. This script will provide you the details that what all operations working in background and what all those session related to,… Read more »
This script will provide you to check the current running RMAN backup status and backup history whether its completed/running or failed with any issue. set line 190 col STATUS format… Read more »
How to check the free space and Usage of ASM Disk Group In this post we have provided 2 scripts , 1st to check the Usage of each ASM disk… Read more »
Find out who are the owners of the SQL Server agent jobs with the help of below script. SELECT J.name AS [Job Name] ,L.name AS [Job Owner] FROM msdb.dbo.sysjobs_view J… Read more »
ERROR OGG-15163 There was a problem sending a message to EXTRACT (Timeout waiting for message) The EXTRACT looks hung, but its status is still showing is “RUNNING”. Restarting the process… Read more »
select b.tablespace_name, tbs_size SizeGb, a.free_space FreeGb from (select tablespace_name, round(sum(bytes)/1024/1024/1024 ,2) as free_space from dba_free_space group by tablespace_name) a, (select tablespace_name, sum(bytes)/1024/1024/1024 as tbs_size from dba_data_files group by tablespace_name UNION… Read more »
set feedback off set pagesize 70; set linesize 2000 set head on COLUMN Tablespace format a25 heading ‘Tablespace Name’ COLUMN autoextensible format a11 heading ‘AutoExtend’ COLUMN files_in_tablespace format 999 heading… Read more »
How to check if tablespaces datafiles are autoextend col FILE_NAME for a60 select TABLESPACE_NAME, FILE_NAME,AUTOEXTENSIBLE,MAXBYTES from dba_Data_files where TABLESPACE_NAME like ‘Tablespace_Name’; _________________________________________________________________________________________________________________________ col FILE_NAME for a60 select TABLESPACE_NAME, FILE_NAME,AUTOEXTENSIBLE,MAXBYTES from… Read more »
Database and server details Report from OEM: Database version and Server Details 1- How do I get the number of databases for each category version? SELECT property_value, COUNT(*) FROM mgmt$target_properties… Read more »
Convert Single Instance database to 2 Node RAC Convert Single Instance Database to 2 Node RAC oracle 10g / 11g. Install Clusterware on the nodes on which you want to… Read more »