trcsess

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

TKPROF in 11gR2 – New Rows Columns

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)

AMDU Utility For ASM

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 ********************************