Disk I/O

Disk I/O

Script
Datafiles Disk I/O
Tablespace Disk I/O
Which segments have top Logical I/O & Physical I/O
Which SQL are doing a lot of disk I/O

Comments

Post a Comment

Popular posts from this blog

RMAN-06820: WARNING: failed to archive current log at primary database

RMAN archive log backup at the standby site is throws the following errors ******************************************************************************** RMAN-06820: WARNING: failed to archive current log at primary database ORACLE error from target database: ORA-17629: Cannot connect to the remote database server ******************************************************************************** RMAN> backup database plus archivelog tag 'FULL_AL_BKP'; Starting backup at 29-FEB-16 RMAN-06820: WARNING: failed to archive current log at primary database ORACLE error from target database: ORA-17629: Cannot connect to the remote database server ORA-17627: ORA-00942: table or view does not exist allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=48 device type=DISK skipping archived logs of thread 1 from sequence 192 to 201; already backed up Finished backup at 29-FEB-16 Starting backup at 29-FEB-16 using channel ORA_DISK_1 channel ORA_DISK_1: starting compressed full datafile b...
Read more

chr function and its values - CHR and ASCII values

chr function returns the ascii letter for that integer. We know that there are 255 ascii characters defined. SQL> select chr(65) as CHR from dual; CHR – A Below code print all 255 ascii characters Sample code to check the values : begin   for i in 1..255 loop       dbms_output.put_line( 'CHR('||i||')' ||'=='|| chr(i) );     end loop;     end;     / This output might differ actually based on the chacterset you have choosen while installing you Database. DBMS_OUTPUT :    CHR(1)== CHR(2)== CHR(3)== CHR(4)== CHR(5)== CHR(6)== CHR(7)== CHR(8)== CHR(9)==    CHR(10)== CHR(11)== CHR(12)== CHR(13)== CHR(14)== CHR(15)== CHR(16)== CHR(17)== CHR(18)== CHR(19)== CHR(20)== CHR(21)== CHR(22)== CHR(23)== CHR(24)== CHR(25)== CHR(26)== CHR(27)== CHR(28)== CHR(29)== CHR(30)== CHR(31)== CHR(32)== CHR(33)==! CHR(34)==" CHR(35)==# CHR(36)==$ CHR(37)==% CHR(38)==& CHR(39)==' CHR(40)==( CHR(41)==) CHR(42...
Read more

TNS-01251: Cannot set trace/log directory under ADR

[oracle@linux01 trace]$ lsnrctl LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 16-SEP-2015 11:24:18 Copyright (c) 1991, 2009, Oracle.  All rights reserved. Welcome to LSNRCTL, type "help" for information. LSNRCTL> set current_listener LISTENER Current Listener is LISTENER LSNRCTL> set log_file listener1 Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=linux01)(PORT=1521))) TNS-01251: Cannot set trace/log directory under ADR  Solution : DIAG_ADR_ENABLED_LISTENER=OFF     -- >> add this line to you listener.ora reload the listener. $ lsnrctl reload  Now lets try again to reset: LSNRCTL> set current_listener LISTENER Current Listener is LISTENER LSNRCTL> set log_file /u01/app/oracle/diag/tnslsnr/linux01/listener/trace/listener1.log Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=linux01)(PORT=1521))) LISTENER parameter "log_file" set to /u01/app/oracle/diag/tnslsnr/linux01/listener/trace/listener1.log The command completed ...
Read more