|
|
script for RAC information required
06-09-2011
connect myuser/mypass
select group_number, file_number, compound_index, incarnation, block_size, bytes/1024/1024/1024 GB, type, striped,
creation_date, modification_date from v$asm_file where TYPE != 'ARCHIVELOG';
select group_number, file_number, bytes/1024/1024/1024 GB, type, striped, modification_date
from v$asm_file where TYPE != 'ARCHIVELOG';
select group#, type, member, is_recovery_dest_file from v$logfile order by group#;
select name from v$datafile
union select name from v$controlfile
union select name from v$tempfile
union select member from v$logfile;
set numwidth 10
column event format a25 tru
select inst_id, event, time_waited, total_waits, total_timeouts
from (select inst_id, event, time_waited, total_waits, total_timeouts
from gv$system_event where event not in ('rdbms ipc message','smon timer',
'pmon timer', 'SQL*Net message from client','lock manager wait for remote message',
'ges remote message', 'gcs remote message', 'gcs for action', 'client message',
'pipe get', 'null event', 'PX Idle Wait', 'single-task message',
'PX Deq: Execution Msg', 'KXFQ: kxfqdeq - normal deqeue',
'listen endpoint status','slave wait','wakeup time manager')
order by time_waited desc)
where rownum < 11
order by time_waited desc;#!/bin/bash sqlplus internal @test.sql /u01/app/11.2.0/grid/bin/crs_stat -t /u01/app/11.2.0/grid/bin/crsctl check crs srvctl status asm -n ukedxdtmtdbs01a srvctl status asm -n ukedxdtmtdbs01b
|
|