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 »
You can use below script to check how many existing indexes you have in your Mongo database for all collections. this is really helpful when you have one environment working… 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 »
Oracle database management scripts- Check how large size of the database col “Database Size” format a20 col “Free space” format a20 col “Used space” format a20 select round(sum(used.bytes) / 1024… Read more »
RAC SRVCTL and CRSCTL useful commands- Below are some of the commands which we have used regularly in our RAC system. There are many more RAC commands for 11gR2/12c Clusterware… Read more »
Convert Physical Standby Database to Snapshot standby Database The difference between a read-only standby and a snapshot standby is that the snapshot standby is fully update-able. It was possible in… Read more »