Fragmented_Tables_List in HTML FORMAT : col spoolname new_value spoolname select ‘Fragmented_tables’||to_char(sysdate, ‘YYYYMONDD’)||’.html’ spoolname from dual; spool ‘&spoolname’ set pagesize 200 set markup html on WITH STAT_SPACE AS( SELECT OWNER, TABLE_NAME, NUM_ROWS, AVG_ROW_LEN, NUM_ROWS*AVG_ROW_LEN/1024/1024/1024 tbl_STAT_SPACE FROM DBA_TABLES WHERE OWNER=’SCOTT’), SEG_SPACE AS ( SELECT OWNER, SEGMENT_NAME, SEGMENT_TYPE,… Read More
Below are different kind of problems where you have recovery issues in standby. Before you take any decision check with your colleagues. 1) Check on source : SQL> select dest_id,error from v$archive_dest_status; 2) To know the redo apply rate : set linesize 500col item format… Read More
Dear Readers, In this article we will see VD and OCR migration online. 1) Check existing setup by running below commands : +ASM1@cloud-server-1:/opt/oracle> crsctl query css votedisk 2) Check the OCR/VD backup : 3) Ask SA to take new backup using… Read More
Puppet Agent Installation Note: There are many ways in Installing the Puppet agent . Below is one example 1. Download puppet RPM based on the linux version. https://yum.puppetlabs.com/ puppet-agent-1.4.1-1.el6.x86_64.rpm #rpm -ivh puppet-agent-1.4.1-1.el6.x86_64.rpm 2. configure puppet.conf root@hostpp$ cat /etc/puppetlabs/puppet/puppet.conf [main] certname = hostpp.example.com [… Read More
set linesize 140 pagesize 100select resource_name,current_utilization,limit_value from gv$resource_limit order by 1; Sample Output:
STOP Puppet Services. $ more puppet_stop.sh #!/usr/bin/shpuppet resource service puppet ensure=stopped puppet resource service pe-puppetserver ensure=stopped puppet resource service pe-activemq ensure=stopped puppet resource service mcollective ensure=stopped puppet resource service pe-puppetdb ensure=stopped puppet resource service pe-postgresql ensure=stopped puppet resource service pe-console-services ensure=stopped puppet resource service pe-nginx… Read More
Transparent Data Encryption Setup Steps Below are the bullet points in setting up and usage of TDE 1. Take Full Backup of Master and User/Application Database (User database part of Encryption). 2. Create Folder to hold Certificate and Key 3. Create Master Key 4. Create… Read More
Database files details – SQL Server This script will help to identify the Database files Size in MB, Space Used, Available Space, % used. If there is space crunch on Database Drive and this query will help to release space if the %used is very… Read More
Check existing retention and current snapshot interval. set linesize 300 select extract( day from snap_interval) *24*60+extract( hour from snap_interval) *60+extract( minute from snap_interval ) snapshot_interval, extract( day from retention) *24*60+extract( hour from retention) *60+extract( minute from retention ) retention_interval, topnsql from dba_hist_wr_control; Below query is… Read More
DECLAREcount1 NUMBER := 0;total NUMBER := 0;CURSOR del_record_cur ISSELECT rowid FROM scott.emp WHERE empno<=20000;BEGINFOR rec IN del_record_cur LOOPDELETE FROM scott.emp WHERE rowid = rec.rowid;total := total + 1;count1 := count1 + 1;IF (count1 >= 1000) THEN COMMIT;count1 := 0;END IF;END LOOP;COMMIT;DBMS_OUTPUT.PUT_LINE(‘Deleted ‘ || total ||… Read More
