Archive
Archive for the ‘Utilities’ Category
trcsess
July 18, 2012
Leave a comment
This is a short note about trcsess. Basically used to combine multiple trace files into one using different criteria.
trcsess [output=<output file name >] [session=<session ID>] [clientid=<clientid>] [service=<service name>] [action=<action name>] [module=<module name>] <trace file names> output=<output file name> output destination default being standard output. session=<session Id> session to be traced. Session id is a combination of session Index & session serial number e.g. 8.13. clientid=<clientid> clientid to be traced. service=<service name> service to be traced. action=<action name> action to be traced. module=<module name> module to be traced. <trace_file_names> Space separated list of trace files with wild card '*' supported.
So, it clearly says that it can support separated list of trace file, but what if you want to combine using multiple service or action etc. I got one situation yesterday that some calls from application are coming from one service and that call end using some other service. Without combining this two trace file it was not possible to get whole picture. For example
*** 2012-07-17 17:07:30.379 *** SESSION ID:(XXX.XXXXX) 2012-07-17 17:07:30.379 *** CLIENT ID:() 2012-07-17 17:07:30.379 *** SERVICE NAME:(DATA_SERVICE) 2012-07-17 17:07:30.379 *** MODULE NAME:(YYYYY.exe) 2012-07-17 17:07:30.379 *** ACTION NAME:() 2012-07-17 17:07:30.379 *** 2012-07-17 16:33:07.734 *** SESSION ID:(XXX.XXXXX) 2012-07-17 16:33:07.734 *** CLIENT ID:() 2012-07-17 16:33:07.734 *** SERVICE NAME:(WEB_SERVICE) 2012-07-17 16:33:07.734 *** MODULE NAME:(ZZZZZ.exe) 2012-07-17 16:33:07.734 *** ACTION NAME:() 2012-07-17 16:33:07.734
I don’t know if there is some other way but what i did was
sed -i ‘s/ACTION NAME:()/ACTION NAME:(TARAL)/g’ *.trc
Then combine using action
*** 2012-07-17 17:07:30.379 *** SESSION ID:(XXX.XXXXX) 2012-07-17 17:07:30.379 *** CLIENT ID:() 2012-07-17 17:07:30.379 *** SERVICE NAME:(DATA_SERVICE) 2012-07-17 17:07:30.379 *** MODULE NAME:(YYYYY.exe) 2012-07-17 17:07:30.379 *** ACTION NAME:(TARAL) 2012-07-17 17:07:30.379 *** 2012-07-17 16:33:07.734 *** SESSION ID:(XXX.XXXXX) 2012-07-17 16:33:07.734 *** CLIENT ID:() 2012-07-17 16:33:07.734 *** SERVICE NAME:(WEB_SERVICE) 2012-07-17 16:33:07.734 *** MODULE NAME:(ZZZZZ.exe) 2012-07-17 16:33:07.734 *** ACTION NAME:(TARAL) 2012-07-17 16:33:07.734
Categories: Utilities
TKPROF in 11gR2 – New Rows Columns
October 15, 2010
Leave a comment
In one of OTN thread I asked information about new columns in rowsource operation and Charles Hooper and Tom Kyte give some insight on this. I didn’t got chance to run test case provided by charles.
In my previous post I had mention same thing and here are some more things which i tried today.
I am using 11.2.0.1.0 Version and will update this page if i find something different in 11.2.0.2. Also, using windows 32 bit environment and Charles test case. Let’s get started.
Here is the test setup
drop table t1 purge; drop table t2 purge; CREATE TABLE T1(C1 NUMBER NOT NULL,C2 NUMBER NOT NULL,C3 VARCHAR2(100)); CREATE TABLE T2(C1 NUMBER NOT NULL,C2 NUMBER NOT NULL,C3 VARCHAR2(100)); INSERT INTO T1 SELECT ROWNUM C1,V2.RN C2,RPAD(TO_CHAR(ROWNUM),10,'A') C3 FROM (SELECT ROWNUM RN FROM DUAL CONNECT BY LEVEL<=1000) V1, (SELECT ROWNUM RN FROM DUAL CONNECT BY LEVEL<=1000) V2 WHERE MOD(V1.RN,1000)>=V2.RN; INSERT INTO T2 SELECT * FROM T1; COMMIT; CREATE INDEX IND_T1_C1_C2 ON T1(C1,C2); CREATE INDEX IND_T2_C1_C2 ON T2(C1,C2); EXEC DBMS_STATS.GATHER_TABLE_STATS(OWNNAME=>USER,TABNAME=>'T1',CASCADE=>TRUE); EXEC DBMS_STATS.GATHER_TABLE_STATS(OWNNAME=>USER,TABNAME=>'T2',CASCADE=>TRUE);
This is test script
VARIABLE N1 NUMBER EXEC :N1:=1 ALTER SESSION SET TRACEFILE_IDENTIFIER = 'SQL_10046_ROW_TEST'; ALTER SESSION SET EVENTS '10046 TRACE NAME CONTEXT FOREVER, LEVEL 16'; SELECT /*+ GATHER_PLAN_STATISTICS */ COUNT(*) FROM T1,T2 WHERE T1.C2=T2.C2 AND T1.C2= :N1; SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY_CURSOR(NULL,NULL,'ALLSTATS LAST')); EXEC :N1:=5 SELECT /*+ GATHER_PLAN_STATISTICS */ COUNT(*) FROM T1,T2 WHERE T1.C2=T2.C2 AND T1.C2= :N1; SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY_CURSOR(NULL,NULL,'ALLSTATS LAST')); EXEC :N1:=95 SELECT /*+ GATHER_PLAN_STATISTICS */ COUNT(*) FROM T1,T2 WHERE T1.C2=T2.C2 AND T1.C2= :N1; SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY_CURSOR(NULL,NULL,'ALLSTATS LAST')); EXEC :N1:=995 SELECT /*+ GATHER_PLAN_STATISTICS */ COUNT(*) FROM T1,T2 WHERE T1.C2=T2.C2 AND T1.C2= :N1; SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY_CURSOR(NULL,NULL,'ALLSTATS LAST')); ALTER SESSION SET EVENTS '10046 TRACE NAME CONTEXT OFF';
This is the output
TARAL@taral > SELECT /*+ GATHER_PLAN_STATISTICS */ COUNT(*) FROM T1,T2 WHERE T1.C2=T2.C2 AND T1.C2= :N1;
COUNT(*)
----------
998001
TARAL@taral > SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY_CURSOR(NULL,NULL,'ALLSTATS LAST'));
PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------
SQL_ID 8ygbsrkt6sqd9, child number 0
-------------------------------------
SELECT /*+ GATHER_PLAN_STATISTICS */ COUNT(*) FROM T1,T2 WHERE
T1.C2=T2.C2 AND T1.C2= :N1
Plan hash value: 765688747
------------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Starts | E-Rows | A-Rows | A-Time | Buffers | Reads | OMem | 1Mem | Use
------------------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | | 1 |00:00:00.34 | 2780 | 4 | | |
| 1 | SORT AGGREGATE | | 1 | 1 | 1 |00:00:00.34 | 2780 | 4 | | |
|* 2 | HASH JOIN | | 1 | 250K| 998K|00:00:00.66 | 2780 | 4 | 1066K| 1066K| 42
|* 3 | INDEX FAST FULL SCAN| IND_T1_C1_C2 | 1 | 500 | 999 |00:00:00.04 | 1390 | 2 | | |
|* 4 | INDEX FAST FULL SCAN| IND_T2_C1_C2 | 1 | 500 | 999 |00:00:00.04 | 1390 | 2 | | |
------------------------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
2 - access("T1"."C2"="T2"."C2")
3 - filter("T1"."C2"=:N1)
4 - filter("T2"."C2"=:N1)
24 rows selected.
TARAL@taral >
TARAL@taral > EXEC :N1:=5
PL/SQL procedure successfully completed.
TARAL@taral >
TARAL@taral > SELECT /*+ GATHER_PLAN_STATISTICS */ COUNT(*) FROM T1,T2 WHERE T1.C2=T2.C2 AND T1.C2= :N1;
COUNT(*)
----------
990025
TARAL@taral >
TARAL@taral > SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY_CURSOR(NULL,NULL,'ALLSTATS LAST'));
PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------
SQL_ID 8ygbsrkt6sqd9, child number 0
-------------------------------------
SELECT /*+ GATHER_PLAN_STATISTICS */ COUNT(*) FROM T1,T2 WHERE
T1.C2=T2.C2 AND T1.C2= :N1
Plan hash value: 765688747
----------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Starts | E-Rows | A-Rows | A-Time | Buffers | OMem | 1Mem | Used-Mem |
----------------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | | 1 |00:00:00.30 | 2780 | | | |
| 1 | SORT AGGREGATE | | 1 | 1 | 1 |00:00:00.30 | 2780 | | | |
|* 2 | HASH JOIN | | 1 | 250K| 990K|00:00:00.65 | 2780 | 1066K| 1066K| 395K (0)|
|* 3 | INDEX FAST FULL SCAN| IND_T1_C1_C2 | 1 | 500 | 995 |00:00:00.04 | 1390 | | | |
|* 4 | INDEX FAST FULL SCAN| IND_T2_C1_C2 | 1 | 500 | 995 |00:00:00.04 | 1390 | | | |
----------------------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
2 - access("T1"."C2"="T2"."C2")
3 - filter("T1"."C2"=:N1)
4 - filter("T2"."C2"=:N1)
24 rows selected.
TARAL@taral >
TARAL@taral > EXEC :N1:=95
PL/SQL procedure successfully completed.
TARAL@taral >
TARAL@taral > SELECT /*+ GATHER_PLAN_STATISTICS */ COUNT(*) FROM T1,T2 WHERE T1.C2=T2.C2 AND T1.C2= :N1;
COUNT(*)
----------
819025
TARAL@taral > SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY_CURSOR(NULL,NULL,'ALLSTATS LAST'));
PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------
SQL_ID 8ygbsrkt6sqd9, child number 0
-------------------------------------
SELECT /*+ GATHER_PLAN_STATISTICS */ COUNT(*) FROM T1,T2 WHERE
T1.C2=T2.C2 AND T1.C2= :N1
Plan hash value: 765688747
----------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Starts | E-Rows | A-Rows | A-Time | Buffers | OMem | 1Mem | Used-Mem |
----------------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | | 1 |00:00:00.28 | 2780 | | | |
| 1 | SORT AGGREGATE | | 1 | 1 | 1 |00:00:00.28 | 2780 | | | |
|* 2 | HASH JOIN | | 1 | 250K| 819K|00:00:00.57 | 2780 | 1066K| 1066K| 379K (0)|
|* 3 | INDEX FAST FULL SCAN| IND_T1_C1_C2 | 1 | 500 | 905 |00:00:00.05 | 1390 | | | |
|* 4 | INDEX FAST FULL SCAN| IND_T2_C1_C2 | 1 | 500 | 905 |00:00:00.05 | 1390 | | | |
----------------------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
2 - access("T1"."C2"="T2"."C2")
3 - filter("T1"."C2"=:N1)
4 - filter("T2"."C2"=:N1)
24 rows selected.
TARAL@taral >
TARAL@taral > EXEC :N1:=995
PL/SQL procedure successfully completed.
TARAL@taral >
TARAL@taral > SELECT /*+ GATHER_PLAN_STATISTICS */ COUNT(*) FROM T1,T2 WHERE T1.C2=T2.C2 AND T1.C2= :N1;
COUNT(*)
----------
25
TARAL@taral > SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY_CURSOR(NULL,NULL,'ALLSTATS LAST'));
PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------
SQL_ID 8ygbsrkt6sqd9, child number 0
-------------------------------------
SELECT /*+ GATHER_PLAN_STATISTICS */ COUNT(*) FROM T1,T2 WHERE
T1.C2=T2.C2 AND T1.C2= :N1
Plan hash value: 765688747
----------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Starts | E-Rows | A-Rows | A-Time | Buffers | OMem | 1Mem | Used-Mem |
----------------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | | 1 |00:00:00.10 | 2780 | | | |
| 1 | SORT AGGREGATE | | 1 | 1 | 1 |00:00:00.10 | 2780 | | | |
|* 2 | HASH JOIN | | 1 | 250K| 25 |00:00:00.10 | 2780 | 1036K| 1036K| 351K (0)|
|* 3 | INDEX FAST FULL SCAN| IND_T1_C1_C2 | 1 | 500 | 5 |00:00:00.05 | 1390 | | | |
|* 4 | INDEX FAST FULL SCAN| IND_T2_C1_C2 | 1 | 500 | 5 |00:00:00.06 | 1390 | | | |
----------------------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
2 - access("T1"."C2"="T2"."C2")
3 - filter("T1"."C2"=:N1)
4 - filter("T2"."C2"=:N1)
24 rows selected.
So, from tkprof output here are the results which perfectely shows average rows as it had captured 4 occurences of the statement.
SQL ID: 8ygbsrkt6sqd9
Plan Hash: 765688747
SELECT /*+ GATHER_PLAN_STATISTICS */ COUNT(*)
FROM
T1,T2 WHERE T1.C2=T2.C2 AND T1.C2= :N1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 4 0.00 0.00 0 0 0 0
Execute 4 0.00 0.01 0 0 0 0
Fetch 8 0.98 1.02 4 11120 0 4
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 16 0.98 1.03 4 11120 0 4
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 89
Number of plan statistics captured: 4
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 SORT AGGREGATE (cr=2780 pr=1 pw=0 time=0 us)
998001 701769 998001 HASH JOIN (cr=2780 pr=1 pw=0 time=429843 us cost=761 size=2000000 card=250000)
999 726 999 INDEX FAST FULL SCAN IND_T1_C1_C2 (cr=1390 pr=1 pw=0 time=33406 us cost=380 size=2000 card=500)(object id 74359)
999 726 999 INDEX FAST FULL SCAN IND_T2_C1_C2 (cr=1390 pr=1 pw=0 time=33505 us cost=380 size=2000 card=500)(object id 74360)
As, default aggregation is turned on if we make it off and then see tkprof output it display all 4 execution
SQL ID: 8ygbsrkt6sqd9
Plan Hash: 765688747
SELECT /*+ GATHER_PLAN_STATISTICS */ COUNT(*)
FROM
T1,T2 WHERE T1.C2=T2.C2 AND T1.C2= :N1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.01 0 0 0 0
Fetch 2 0.31 0.33 4 2780 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 0.31 0.35 4 2780 0 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 89
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 SORT AGGREGATE (cr=2780 pr=4 pw=0 time=0 us)
998001 998001 998001 HASH JOIN (cr=2780 pr=4 pw=0 time=596598 us cost=761 size=2000000 card=250000)
999 999 999 INDEX FAST FULL SCAN IND_T1_C1_C2 (cr=1390 pr=2 pw=0 time=42664 us cost=380 size=2000 card=500)(object id 74359)
999 999 999 INDEX FAST FULL SCAN IND_T2_C1_C2 (cr=1390 pr=2 pw=0 time=42415 us cost=380 size=2000 card=500)(object id 74360)
SQL ID: 8ygbsrkt6sqd9
Plan Hash: 765688747
SELECT /*+ GATHER_PLAN_STATISTICS */ COUNT(*)
FROM
T1,T2 WHERE T1.C2=T2.C2 AND T1.C2= :N1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 2 0.29 0.30 0 2780 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 0.29 0.30 0 2780 0 1
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 89
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 SORT AGGREGATE (cr=2780 pr=0 pw=0 time=0 us)
990025 990025 990025 HASH JOIN (cr=2780 pr=0 pw=0 time=596958 us cost=761 size=2000000 card=250000)
995 995 995 INDEX FAST FULL SCAN IND_T1_C1_C2 (cr=1390 pr=0 pw=0 time=42866 us cost=380 size=2000 card=500)(object id 74359)
995 995 995 INDEX FAST FULL SCAN IND_T2_C1_C2 (cr=1390 pr=0 pw=0 time=42866 us cost=380 size=2000 card=500)(object id 74360)
SQL ID: 8ygbsrkt6sqd9
Plan Hash: 765688747
SELECT /*+ GATHER_PLAN_STATISTICS */ COUNT(*)
FROM
T1,T2 WHERE T1.C2=T2.C2 AND T1.C2= :N1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 2 0.26 0.27 0 2780 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 0.26 0.27 0 2780 0 1
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 89
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 SORT AGGREGATE (cr=2780 pr=0 pw=0 time=0 us)
819025 819025 819025 HASH JOIN (cr=2780 pr=0 pw=0 time=525793 us cost=761 size=2000000 card=250000)
905 905 905 INDEX FAST FULL SCAN IND_T1_C1_C2 (cr=1390 pr=0 pw=0 time=47686 us cost=380 size=2000 card=500)(object id 74359)
905 905 905 INDEX FAST FULL SCAN IND_T2_C1_C2 (cr=1390 pr=0 pw=0 time=48364 us cost=380 size=2000 card=500)(object id 74360)
SQL ID: 8ygbsrkt6sqd9
Plan Hash: 765688747
SELECT /*+ GATHER_PLAN_STATISTICS */ COUNT(*)
FROM
T1,T2 WHERE T1.C2=T2.C2 AND T1.C2= :N1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 2 0.10 0.10 0 2780 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 0.10 0.10 0 2780 0 1
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 89
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 SORT AGGREGATE (cr=2780 pr=0 pw=0 time=0 us)
25 25 25 HASH JOIN (cr=2780 pr=0 pw=0 time=24 us cost=761 size=2000000 card=250000)
5 5 5 INDEX FAST FULL SCAN IND_T1_C1_C2 (cr=1390 pr=0 pw=0 time=408 us cost=380 size=2000 card=500)(object id 74359)
5 5 5 INDEX FAST FULL SCAN IND_T2_C1_C2 (cr=1390 pr=0 pw=0 time=376 us cost=380 size=2000 card=500)(object id 74360)
Categories: Utilities
AMDU Utility For ASM
October 9, 2010
1 comment
This utility from 11g can help to get ASM information and also can dump other information while asm instance is not running. For example you can get files from asm disk even though asm is not running. To get help amdu -help. There is no official documentation available for this so careful while doing other than just querying.
When you give amdu without any parameter it will create one folder and inside that report.txt. Here is the sample output
******************************* AMDU Settings ******************************** ORACLE_HOME = /u01/app/oracle/product/11.2.0/grid System name: Linux Node name: taral.localdomain Release: 2.6.32-100.20.1.el5 Version: #1 SMP Fri Oct 1 16:37:36 EDT 2010 Machine: x86_64 amdu run: 08-OCT-10 19:07:11 Endianess: 1 --------------------------------- Operations --------------------------------- ------------------------------- Disk Selection ------------------------------- -diskstring '' ------------------------------ Reading Control ------------------------------- ------------------------------- Output Control ------------------------------- ********************************* DISCOVERY ********************************** ----------------------------- DISK REPORT N0001 ------------------------------ Disk Path: ORCL:ASMDISK1 Unique Disk ID: Disk Label: ASMDISK1 Physical Sector Size: 512 bytes Disk Size: 9773 megabytes Group Name: ASMDATA Disk Name: ASMDISK1 Failure Group Name: ASMDISK1 Disk Number: 0 Header Status: 3 Disk Creation Time: 2010/09/15 12:08:52.229000 Last Mount Time: 2010/10/08 17:26:26.671000 Compatibility Version: 0x0b200000(11020000) Disk Sector Size: 512 bytes Disk size in AUs: 9773 AUs Group Redundancy: 2 Metadata Block Size: 4096 bytes AU Size: 1048576 bytes Stride: 113792 AUs Group Creation Time: 2010/09/15 12:08:52.109000 File 1 Block 1 location: AU 2 OCR Present: NO ----------------------------- DISK REPORT N0002 ------------------------------ Disk Path: ORCL:ASMDISK2 Unique Disk ID: Disk Label: ASMDISK2 Physical Sector Size: 512 bytes Disk Size: 9773 megabytes Group Name: ASMDATA Disk Name: ASMDISK2 Failure Group Name: ASMDISK2 Disk Number: 1 Header Status: 3 Disk Creation Time: 2010/09/15 12:08:52.229000 Last Mount Time: 2010/10/08 17:26:26.671000 Compatibility Version: 0x0b200000(11020000) Disk Sector Size: 512 bytes Disk size in AUs: 9773 AUs Group Redundancy: 2 Metadata Block Size: 4096 bytes AU Size: 1048576 bytes Stride: 113792 AUs Group Creation Time: 2010/09/15 12:08:52.109000 File 1 Block 1 location: AU 2 OCR Present: NO ----------------------------- DISK REPORT N0003 ------------------------------ Disk Path: ORCL:ASMDISK3 Unique Disk ID: Disk Label: ASMDISK3 Physical Sector Size: 512 bytes Disk Size: 9773 megabytes Group Name: ASMDATA Disk Name: ASMDISK3 Failure Group Name: ASMDISK3 Disk Number: 2 Header Status: 3 Disk Creation Time: 2010/09/15 12:08:52.229000 Last Mount Time: 2010/10/08 17:26:26.671000 Compatibility Version: 0x0b200000(11020000) Disk Sector Size: 512 bytes Disk size in AUs: 9773 AUs Group Redundancy: 2 Metadata Block Size: 4096 bytes AU Size: 1048576 bytes Stride: 113792 AUs Group Creation Time: 2010/09/15 12:08:52.109000 File 1 Block 1 location: AU 2 OCR Present: NO ----------------------------- DISK REPORT N0004 ------------------------------ Disk Path: ORCL:ASMDISK4 Unique Disk ID: Disk Label: ASMDISK4 Physical Sector Size: 512 bytes Disk Size: 19539 megabytes Group Name: DATA Disk Name: ASMDISK4 Failure Group Name: ASMDISK4 Disk Number: 0 Header Status: 3 Disk Creation Time: 2010/09/15 12:34:10.144000 Last Mount Time: 2010/10/08 17:26:26.793000 Compatibility Version: 0x0b200000(11020000) Disk Sector Size: 512 bytes Disk size in AUs: 4884 AUs Group Redundancy: 1 Metadata Block Size: 4096 bytes AU Size: 4194304 bytes Stride: 454272 AUs Group Creation Time: 2010/09/15 12:34:09.836000 File 1 Block 1 location: AU 2 OCR Present: NO ******************************* END OF REPORT ********************************
Categories: Utilities
