Vinod Siram – Page 6

Oracle : TableSpace Menu Bar in SecureCRT

Dear Readers, In this article, we will see TableSpace Menu Bar in SecureCRT . TBS_FREE :

set linesize 130
set pagesize 1000
col tablespace format a30

set linesize 130

set pagesize 1000

col tablespace format a30

select tablespace_name tablespace,
round(sum(a.total1)/1048576, 0) Total,
round(sum(a.total1)/1048576, 0)-round(sum(a.sum1)/1048576, 0) used,
round(sum(a.sum1)/1048576, 0) free,
round(((sum(a.sum1)/1048576)/(sum(a.total1)/1048576))*100, 0) pct_free,
round(sum(a.maxb)/1048576, 0) largest,
max(a.cnt) fragment
from
(select tablespace_name, 0 total1, sum(bytes) sum1,
max(bytes) MAXB,
count(bytes) cnt
from dba_free_space
group by tablespace_name
union
select tablespace_name, sum(bytes) total1, 0, 0, 0 from dba_data_files
group by tablespace_name) a
group by a.tablespace_name
order by 5 desc;

select tablespace_name tablespace,

round(sum(a.total1)/1048576, 0) Total,

round(sum(a.total1)/1048576, 0)-round(sum(a.sum1)/1048576, 0) used,

round(sum(a.sum1)/1048576, 0) free,

round(((sum(a.sum1)/1048576)/(sum(a.total1)/1048576))*100, 0) pct_free,

round(sum(a.maxb)/1048576, 0) largest,

max(a.cnt) fragment

from

(select tablespace_name, 0 total1, sum(bytes) sum1,

max(bytes) MAXB,

count(bytes) cnt

from dba_free_space

group by tablespace_name

union

select tablespace_name, sum(bytes) total1, 0, 0, 0 from dba_data_files

group by tablespace_name) a

group by a.tablespace_name

order by 5 desc;

Out Put :

TABLESPACE                          TOTAL       USED       FREE   PCT_FREE    LARGEST   FRAGMENT
------------------------------ ---------- ---------- ---------- ---------- ---------- ----------
USERS                                   5          2          3         65          3          1
UNDOTBS1                               60         24         36         59         25         13
SYSAUX                                730        690         40          5         38         14
SYSTEM                                800        792          8          1          8          2

TABLESPACE TOTAL USED FREE PCT_FREE LARGEST FRAGMENT

------------------------------ ---------- ---------- ---------- ---------- ---------- ----------

USERS 5 2 3 65 3 1

UNDOTBS1 60 24 36 59 25 13

SYSAUX 730 690 40 5 38 14

SYSTEM 800 792 8 1 8 2

TBS_FILE :

set linesize 130
set pagesize 1000
set echo on
col file_name format a80

set linesize 130

set pagesize 1000

set echo on

col file_name format a80

select file_id,file_name, bytes/1048576 mb,AUTOEXTENSIBLE,MAXBYTES/1024/1024/1024 MAX_BYTES_GB
from dba_data_files
where tablespace_name='&tbs'
order by substr(file_name,length(file_name)-5,6);

select file_id,file_name, bytes/1048576 mb,AUTOEXTENSIBLE,MAXBYTES/1024/1024/1024 MAX_BYTES_GB

from dba_data_files

where tablespace_name='&tbs'

order by substr(file_name,length(file_name)-5,6);

SEGMENTBYNAME :

set ver off
set trimspool on
set lines 199
col owner for a15
col segment_name for a30
col segment_type for a25
col tablespace_name for a22
set pagesize 150
col part_name for a30
compu sum of size_mb on report
break on report skip 2

set ver off

set trimspool on

set lines 199

col owner for a15

col segment_name for a30

col segment_type for a25

col tablespace_name for a22

set pagesize 150

col part_name for a30

compu sum of size_mb on report

break on report skip 2

select
owner, segment_name,partition_name part_name, buffer_pool, segment_type, tablespace_name, extents,
round(bytes/1024/1024) size_mb
from dba_segments where
segment_name like upper('&segname');

select

owner, segment_name,partition_name part_name, buffer_pool, segment_type, tablespace_name, extents,

round(bytes/1024/1024) size_mb

from dba_segments where

segment_name like upper('&segname');

DBSIZE :

select sum(bytes)/1024/1024/1024 GB from dba_segments;
GB
----------
1.46954346

select sum(bytes)/1024/1024/1024 GB from dba_segments;

----------

1.46954346

select sum(bytes)/1024/1024/1024 GB from dba_data_files;
GB
----------
1.55761719

select sum(bytes)/1024/1024/1024 GB from dba_data_files;

----------

1.55761719

select sum(bytes)/1024/1024/1024 GB from dba_temp_files;
GB
----------
.05859375

select sum(bytes)/1024/1024/1024 GB from dba_temp_files;

----------

.05859375

Seg_With_Highest_IO_Reads :

set pagesize 200
set linesize 300
col segment_name format a40
col owner format a10

set pagesize 200

set linesize 300

col segment_name format a40

col owner format a10

select segment_name,object_type,total_physical_reads
from ( select owner||'.'||object_name as segment_name,object_type,
value as total_physical_reads
from v$segment_statistics
where statistic_name in ('physical reads')
order by total_physical_reads desc)
where rownum <=10;

select segment_name,object_type,total_physical_reads

from ( select owner||'.'||object_name as segment_name,object_type,

value as total_physical_reads

from v$segment_statistics

where statistic_name in ('physical reads')

order by total_physical_reads desc)

where rownum <=10;

Out Put :

SEGMENT_NAME                             OBJECT_TYPE        TOTAL_PHYSICAL_READS
---------------------------------------- ------------------ --------------------
SYS.REFCON$                              TABLE                              6665
SYS.OBJ$                                 TABLE                              3057
SYS.TYPE$                                TABLE                              2728
SYS.SEG$                                 TABLE                              2694
SYS.IDL_UB1$                             TABLE                              1803
SYS.I_OBJ5                               INDEX                               962
SYS.HISTGRM$                             TABLE                               958
SYS.I_OBJ1                               INDEX                               615
SYS.IDL_UB2$                             TABLE                               542
SYS.WRI$_OPTSTAT_HISTGRM_HISTORY         TABLE PARTITION                     462

SEGMENT_NAME OBJECT_TYPE TOTAL_PHYSICAL_READS

---------------------------------------- ------------------ --------------------

SYS.REFCON$ TABLE 6665

SYS.OBJ$ TABLE 3057

SYS.TYPE$ TABLE 2728

SYS.SEG$ TABLE 2694

SYS.IDL_UB1$ TABLE 1803

SYS.I_OBJ5 INDEX 962

SYS.HISTGRM$ TABLE 958

SYS.I_OBJ1 INDEX 615

SYS.IDL_UB2$ TABLE 542

SYS.WRI$_OPTSTAT_HISTGRM_HISTORY TABLE PARTITION 462

Seg_With_Highest_IO_Writes :… Read More

Oracle : How to Kill Blocking Sessions in RAC

5 years ago by Vinod SiramOracle DB Admin

Dear Readers, In this article, we will see Kill blocking sessions in RAC . Kill blocking sessions in RAC:

set serveroutput on
set feedback off
set linesize 300

declare
blockcount number;
sqlreport varchar(3000);
sqloutput varchar(5000);
v_rec varchar(3000);

cursor blk_curs is select B.USERNAME BUSER,B.SID BSID,B.SERIAL# BSERIAL,B.INST_ID BID,B.STATUS BSTAT,B.LAST_CALL_ET BLAST,W.USERNAME WUSER,W.SID WSID,W.SERIAL# WSERIAL,W.INST_ID WID
from (select INST_ID,SID,SERIAL#,USERNAME,STATUS,BLOCKING_INSTANCE,BLOCKING_SESSION, LAST_CALL_ET from gv$session where BLOCKING_SESSION >0) W,
(select INST_ID,SID,SERIAL#,USERNAME,STATUS,LAST_CALL_ET from gv$session ) B
where W.BLOCKING_INSTANCE=B.INST_ID and W.BLOCKING_SESSION=B.SID and B.username not in ('SYS','SYSTEM','DBSNMP','RMAN');
cursor distval is select distinct B.SID CSID, B.USERNAME CUSER from (select INST_ID,SID,SERIAL#,USERNAME,STATUS,BLOCKING_INSTANCE,BLOCKING_SESSION, LAST_CALL_ET
from gv$session where BLOCKING_SESSION >0) W, (select INST_ID,SID,SERIAL#,USERNAME,STATUS,LAST_CALL_ET from gv$session ) B
where W.BLOCKING_INSTANCE=B.INST_ID and W.BLOCKING_SESSION=B.SID and B.username not in ('SYS','SYSTEM','DBSNMP','RMAN');
cursor killcurs(v in varchar, b in number) is select SID ,serial# SERIAL,inst_id ,username ,to_char(logon_time,'''DD-MON-YYYY HH24-MI-SS''') OTIME,event,status ,machine ,round(LAST_CALL_ET/60,2) OMIN
FROM gv$session where username is not null and username=v and sid=b order by inst_id;
begin
DBMS_OUTPUT.put_line('Checking for blocking sessions on this database');
DBMS_OUTPUT.put_line('-----------------------------------------------');
select count(*) into blockcount from (select * from gv$session where BLOCKING_SESSION >0) W,
(select * from gv$session ) B where W.BLOCKING_INSTANCE=B.INST_ID and W.BLOCKING_SESSION=B.SID and B.username not in ('SYS','SYSTEM','DBSNMP','RMAN');
IF blockcount > 0 THEN
DBMS_OUTPUT.put_line('Found blocking sessions -> Fetching report for the same');
DBMS_OUTPUT.put_line('-------------------------------------------------------');
for v_rec in blk_curs LOOP
dbms_output.put_line(v_rec.BUSER ||' ('||v_rec.BSID||','||v_rec.BSERIAL||',@'||v_rec.BID||') is Currently '||v_rec.BSTAT||' for last '||v_rec.BLAST||' Sec and it''s BLOCKING user '|| v_rec.WUSER||' ('||v_rec.WSID||','||v_rec.WSERIAL||',@'||v_rec.WID||')');
end loop;
DBMS_OUTPUT.put_line('-');
DBMS_OUTPUT.put_line('-');
DBMS_OUTPUT.put_line('Further details on blocking sessions -> includes kill script of blocking session');
DBMS_OUTPUT.put_line('--------------------------------------------------------------------------------');
for v_rec2 in distval LOOP
for v_rec3 in killcurs(v_rec2.CUSER, v_rec2.CSID) loop
dbms_output.put_line('alter system kill session '''||v_rec3.SID|| ',' || v_rec3.SERIAL||',@'||v_rec3.inst_id|| ''' immediate; '||v_rec3.username||' '||v_rec3.OTIME||' '|| v_rec3.event||' '||v_rec3.status||' '||v_rec3.machine||' '||v_rec3.OMIN);
end loop;
end loop;
DBMS_OUTPUT.put_line('-');
DBMS_OUTPUT.put_line('-');
ELSE
DBMS_OUTPUT.put_line('-');
DBMS_OUTPUT.put_line('-');
DBMS_OUTPUT.put_line('Hurrey !!! No blocking sessions found');
DBMS_OUTPUT.put_line('-');
DBMS_OUTPUT.put_line('-');
END IF;
END;
/

set serveroutput on

set feedback off

set linesize 300

declare

blockcount number;

sqlreport varchar(3000);

sqloutput varchar(5000);

v_rec varchar(3000);

cursor blk_curs is select B.USERNAME BUSER,B.SID BSID,B.SERIAL# BSERIAL,B.INST_ID BID,B.STATUS BSTAT,B.LAST_CALL_ET BLAST,W.USERNAME WUSER,W.SID WSID,W.SERIAL# WSERIAL,W.INST_ID WID

from (select INST_ID,SID,SERIAL#,USERNAME,STATUS,BLOCKING_INSTANCE,BLOCKING_SESSION, LAST_CALL_ET from gv$session where BLOCKING_SESSION >0) W,

(select INST_ID,SID,SERIAL#,USERNAME,STATUS,LAST_CALL_ET from gv$session ) B

where W.BLOCKING_INSTANCE=B.INST_ID and W.BLOCKING_SESSION=B.SID and B.username not in ('SYS','SYSTEM','DBSNMP','RMAN');

cursor distval is select distinct B.SID CSID, B.USERNAME CUSER from (select INST_ID,SID,SERIAL#,USERNAME,STATUS,BLOCKING_INSTANCE,BLOCKING_SESSION, LAST_CALL_ET

from gv$session where BLOCKING_SESSION >0) W, (select INST_ID,SID,SERIAL#,USERNAME,STATUS,LAST_CALL_ET from gv$session ) B

where W.BLOCKING_INSTANCE=B.INST_ID and W.BLOCKING_SESSION=B.SID and B.username not in ('SYS','SYSTEM','DBSNMP','RMAN');

cursor killcurs(v in varchar, b in number) is select SID ,serial# SERIAL,inst_id ,username ,to_char(logon_time,'''DD-MON-YYYY HH24-MI-SS''') OTIME,event,status ,machine ,round(LAST_CALL_ET/60,2) OMIN

FROM gv$session where username is not null and username=v and sid=b order by inst_id;

begin

DBMS_OUTPUT.put_line('Checking for blocking sessions on this database');

DBMS_OUTPUT.put_line('-----------------------------------------------');

select count(*) into blockcount from (select * from gv$session where BLOCKING_SESSION >0) W,

(select * from gv$session ) B where W.BLOCKING_INSTANCE=B.INST_ID and W.BLOCKING_SESSION=B.SID and B.username not in ('SYS','SYSTEM','DBSNMP','RMAN');

IF blockcount > 0 THEN

DBMS_OUTPUT.put_line('Found blocking sessions -> Fetching report for the same');

DBMS_OUTPUT.put_line('-------------------------------------------------------');

for v_rec in blk_curs LOOP

dbms_output.put_line(v_rec.BUSER ||' ('||v_rec.BSID||','||v_rec.BSERIAL||',@'||v_rec.BID||') is Currently '||v_rec.BSTAT||' for last '||v_rec.BLAST||' Sec and it''s BLOCKING user '|| v_rec.WUSER||' ('||v_rec.WSID||','||v_rec.WSERIAL||',@'||v_rec.WID||')');

end loop;

DBMS_OUTPUT.put_line('-');

DBMS_OUTPUT.put_line('Further details on blocking sessions -> includes kill script of blocking session');

DBMS_OUTPUT.put_line('--------------------------------------------------------------------------------');

for v_rec2 in distval LOOP

for v_rec3 in killcurs(v_rec2.CUSER, v_rec2.CSID) loop

dbms_output.put_line('alter system kill session '''||v_rec3.SID|| ',' || v_rec3.SERIAL||',@'||v_rec3.inst_id|| ''' immediate; '||v_rec3.username||' '||v_rec3.OTIME||' '|| v_rec3.event||' '||v_rec3.status||' '||v_rec3.machine||' '||v_rec3.OMIN);

end loop;

DBMS_OUTPUT.put_line('-');

ELSE

DBMS_OUTPUT.put_line('-');

DBMS_OUTPUT.put_line('Hurrey !!! No blocking sessions found');

DBMS_OUTPUT.put_line('-');

END IF;

END;

Output:

Checking for blocking sessions on this database
------------------------------------------------
Found blocking sessions -> Fetching report for the same
--------------------------------------------------------
VINOD (3033,27215,@1) is Currently INACTIVE for last 23 Sec and it's BLOCKING user VINOD (2126,11412,@2)
-
-
Further details on blocking sessions -> includes kill script of blocking session
--------------------------------------------------------------------------------
alter system kill session '3033,27215,@1' immediate, VINOD '02-NOV-2020 19-12-04' SQL*Net message from client INACTIVE server1 .38

Checking for blocking sessions on this database

------------------------------------------------

Found blocking sessions -> Fetching report for the same

--------------------------------------------------------

VINOD (3033,27215,@1) is Currently INACTIVE for last 23 Sec and it's BLOCKING user VINOD (2126,11412,@2)

Further details on blocking sessions -> includes kill script of blocking session

--------------------------------------------------------------------------------

alter system kill session '3033,27215,@1' immediate, VINOD '02-NOV-2020 19-12-04' SQL*Net message from client INACTIVE server1 .38

Thank you for giving your valuable time to read the above information. Follow us on Website … Read More

Top Oracle CPU & ELAPSED Queries

5 years ago by Vinod SiramOracle DB Admin

Dear Readers, In this article, we will see the following Top CPU & ELAPSED Queries. Top CPU Queries :

select * from (SELECT dhst.sql_id,SQL_TEXT,X.CPU_TIME/1000000 CPU_Time_inSec,X.Num_Execs,round(((X.CPU_TIME/1000000)/X.Num_Execs),3) CPUPEREXEC, X.num_rows
FROM DBA_HIST_SQLTEXT DHST,
(SELECT DHSS.SQL_ID SQL_ID,SUM(DHSS.CPU_TIME_DELTA) CPU_TIME ,sum(executions_delta) as Num_Execs,sum(ROWS_PROCESSED_delta) as num_rows
FROM DBA_HIST_SQLSTAT DHSS
WHERE DHSS.SNAP_ID IN(SELECT SNAP_ID FROM DBA_HIST_SNAPSHOT
WHERE begin_interval_time > =TO_DATE('25/APR/2019 20:50','DD-MON-YYYY HH24:MI')
AND END_INTERVAL_TIME<=TO_DATE('26/APR/2019 06:30','DD-MON-YYYY HH24:MI')
) GROUP BY DHSS.SQL_ID) X WHERE X.SQL_ID=DHST.SQL_ID ORDER BY X.CPU_TIME DESC
FETCH FIRST 50 ROWS ONLY)y
order by y.cpuperexec desc

select * from (SELECT dhst.sql_id,SQL_TEXT,X.CPU_TIME/1000000 CPU_Time_inSec,X.Num_Execs,round(((X.CPU_TIME/1000000)/X.Num_Execs),3) CPUPEREXEC, X.num_rows

FROM DBA_HIST_SQLTEXT DHST,

(SELECT DHSS.SQL_ID SQL_ID,SUM(DHSS.CPU_TIME_DELTA) CPU_TIME ,sum(executions_delta) as Num_Execs,sum(ROWS_PROCESSED_delta) as num_rows

FROM DBA_HIST_SQLSTAT DHSS

WHERE DHSS.SNAP_ID IN(SELECT SNAP_ID FROM DBA_HIST_SNAPSHOT

WHERE begin_interval_time > =TO_DATE('25/APR/2019 20:50','DD-MON-YYYY HH24:MI')

AND END_INTERVAL_TIME<=TO_DATE('26/APR/2019 06:30','DD-MON-YYYY HH24:MI')

) GROUP BY DHSS.SQL_ID) X WHERE X.SQL_ID=DHST.SQL_ID ORDER BY X.CPU_TIME DESC

FETCH FIRST 50 ROWS ONLY)y

order by y.cpuperexec desc

Top ELAPSED Queries :

select sub.sql_id,
txt.sql_text,
parsing_schema_name,
sub.seconds_since_date as TOTALELAPSEDTIME,
sub.execs_since_date as NUmberofExecs,
sub.gets_rows_date as RowsProcessed,
round(sub.seconds_since_date / (sub.execs_since_date + 0.01), 3) avg_query_time
from ( -- sub to sort before top N filter
select sql_id,
g.parsing_schema_name,
round(sum(ELAPSED_TIME_delta) / 1000000) as seconds_since_date,
sum(executions_delta) as execs_since_date,
sum(buffer_gets_delta) as gets_since_date,
sum(ROWS_PROCESSED_delta) as gets_rows_date,
row_number() over (order by round(sum(elapsed_time_delta) / 1000000) desc) r
from dba_hist_snapshot natural
join dba_hist_sqlstat g
where begin_interval_time > =TO_DATE('02/APR/2019 07:50','DD-MON-YYYY HH24:MI')
AND END_INTERVAL_TIME<=TO_DATE('02/APR/2019 08:20','DD-MON-YYYY HH24:MI')
and parsing_schema_name = 'SCOTT'
group by sql_id, g.parsing_schema_name) sub
join dba_hist_sqltext txt on sub.sql_id = txt.sql_id
where r < 10
order by avg_query_time desc

select sub.sql_id,

txt.sql_text,

parsing_schema_name,

sub.seconds_since_date as TOTALELAPSEDTIME,

sub.execs_since_date as NUmberofExecs,

sub.gets_rows_date as RowsProcessed,

round(sub.seconds_since_date / (sub.execs_since_date + 0.01), 3) avg_query_time

from ( -- sub to sort before top N filter

select sql_id,

g.parsing_schema_name,

round(sum(ELAPSED_TIME_delta) / 1000000) as seconds_since_date,

sum(executions_delta) as execs_since_date,

sum(buffer_gets_delta) as gets_since_date,

sum(ROWS_PROCESSED_delta) as gets_rows_date,

row_number() over (order by round(sum(elapsed_time_delta) / 1000000) desc) r

from dba_hist_snapshot natural

join dba_hist_sqlstat g

where begin_interval_time > =TO_DATE('02/APR/2019 07:50','DD-MON-YYYY HH24:MI')

AND END_INTERVAL_TIME<=TO_DATE('02/APR/2019 08:20','DD-MON-YYYY HH24:MI')

and parsing_schema_name = 'SCOTT'

group by sql_id, g.parsing_schema_name) sub

join dba_hist_sqltext txt on sub.sql_id = txt.sql_id

where r < 10

order by avg_query_time desc

TOP Elapsed Queries with Text :

select sub.sql_id,
txt.sql_text,
parsing_schema_name,
sub.seconds_since_date as TOTALELAPSEDTIME,
sub.execs_since_date as NUmberofExecs,
sub.gets_rows_date as RowsProcessed,
round(sub.seconds_since_date / (sub.execs_since_date + 0.01), 3) avg_query_time
from ( -- sub to sort before top N filter
select sql_id,
g.parsing_schema_name,
round(sum(ELAPSED_TIME_delta) / 1000000) as seconds_since_date,
sum(executions_delta) as execs_since_date,
sum(buffer_gets_delta) as gets_since_date,
sum(ROWS_PROCESSED_delta) as gets_rows_date,
row_number() over (order by round(sum(elapsed_time_delta) / 1000000) desc) r
from dba_hist_snapshot natural
join dba_hist_sqlstat g
where begin_interval_time > =TO_DATE('22/OCT/2019 10:40','DD-MON-YYYY HH24:MI')
AND END_INTERVAL_TIME<=TO_DATE('22/OCT/2019 14:00','DD-MON-YYYY HH24:MI')
and parsing_schema_name = 'SCOTT'
group by sql_id, g.parsing_schema_name) sub
join dba_hist_sqltext txt on sub.sql_id = txt.sql_id and SQL_TEXT like 'update%'
--where r < 50
order by avg_query_time desc

select sub.sql_id,

txt.sql_text,

parsing_schema_name,

sub.seconds_since_date as TOTALELAPSEDTIME,

sub.execs_since_date as NUmberofExecs,

sub.gets_rows_date as RowsProcessed,

round(sub.seconds_since_date / (sub.execs_since_date + 0.01), 3) avg_query_time

from ( -- sub to sort before top N filter

select sql_id,

g.parsing_schema_name,

round(sum(ELAPSED_TIME_delta) / 1000000) as seconds_since_date,

sum(executions_delta) as execs_since_date,

sum(buffer_gets_delta) as gets_since_date,

sum(ROWS_PROCESSED_delta) as gets_rows_date,

row_number() over (order by round(sum(elapsed_time_delta) / 1000000) desc) r

from dba_hist_snapshot natural

join dba_hist_sqlstat g

where begin_interval_time > =TO_DATE('22/OCT/2019 10:40','DD-MON-YYYY HH24:MI')

AND END_INTERVAL_TIME<=TO_DATE('22/OCT/2019 14:00','DD-MON-YYYY HH24:MI')

and parsing_schema_name = 'SCOTT'

group by sql_id, g.parsing_schema_name) sub

join dba_hist_sqltext txt on sub.sql_id = txt.sql_id and SQL_TEXT like 'update%'

--where r < 50

order by avg_query_time desc

Thank you for giving your valuable time to read the above information.… Read More

ORACLE: PL/SQL script to rebuild Table(s) and it’s corresponding indexes

5 years ago by Vinod SiramOracle DB Admin

ORACLE:PL/SQL script to rebuild Table(s) and it’s corresponding indexes. Note : Please implement in lower environments before proceeding to Production. Pre requisites : Please download and check below file for pre-requisites. Table creation scripts The below script will be used for 1.Rebuild table(s) 2.Rebuild… Read More

Protected: ORACLE : Shell script to rebuild indexes for index fragmentation

5 years ago by Vinod SiramOracle DB Admin

There is no excerpt because this is a protected post.

Tools for Administering the Oracle Database

5 years ago by Vinod SiramOracle DB Admin

Dear Readers, In this article, we will discuss Tools for Administering the Oracle Database Please Fill below Google Form (If we missed any Products, Tools, and Utilities that you use in achieving your goals as a Cassandra Administrator.) 👇🏻👇🏻👇🏻👇🏻👇🏻 https://forms.gle/oracledba Monitoring Tools: OEM Nagios EM… Read More

Protected: Shell Script to get EMAIL alerts for Lagging between GoldenGate Processes

6 years ago by Vinod SiramAutomation scripts in Goldengate

There is no excerpt because this is a protected post.

SecureCRT Buttons for Default

6 years ago by Vinod SiramSecure CRT

Hello Reader In this article , we will cover SecureCRT Buttons for Default. ############Setting up Format (format): To convert invalid timestamp value and to check current date.

alter session set nls_date_format='MM/DD/YYYY HH24:MI:SS';
Session altered.

1 2	alter session set nls_date_format='MM/DD/YYYY HH24:MI:SS'; Session altered.

######### Instance Information (inst_info): This SQL outputs the information of instance that is up and running like… Read More

Protected: Shell Script to get EMAIL alerts for STOPPED Processes in Oracle GoldenGate.

6 years ago by Vinod SiramAutomation scripts in Goldengate

There is no excerpt because this is a protected post.

Protected: Shell Script to get EMAIL alerts for ABENDED PROCESSES in Oracle GoldenGate

6 years ago by Vinod SiramOracle DB Admin

There is no excerpt because this is a protected post.