Search This Blog

Total Pageviews

Saturday, 10 March 2012

ASM reading files with direct OS access

 

 


 


 ASM reading files with direct OS access




SQL> select GROUP_KFFXP,DISK_KFFXP,AU_KFFXP from x$kffxp where number_kffxp in (select file_number from v$asm_alias where name like 'spfile%' );


GROUP_KFFXP DISK_KFFXP AU_KFFXP
----------- ---------- ----------
1 0 994



SQL> select GROUP_KFFXP,DISK_KFFXP,AU_KFFXP from x$kffxp where number_kffxp in (select file_number from v$asm_alias where name like 'spfile%' );


GROUP_KFFXP DISK_KFFXP AU_KFFXP
----------- ---------- ----------
1 0 994




col path format a30
select disk_number,path from v$asm_disk where GROUP_NUMBER=1 and disk_number in (0,994);

DISK_NUMBER PATH
----------- ------------------------------
0 /dev/raw/raw1


dd if=/dev/raw/raw1 bs=1024k count=1 skip=101|strings|more





SQL> !dd if=/dev/raw/raw1 bs=1024k count=1 skip=101|strings|more
U !
Is the column updatable?,
Column name,
Table name,
Table owner,
$Description of all updatable columns,
Is the column deletable?,
Is the column insertable?,
Is the column updatable?,
Column name,
Table name,
Table owner,
Description of updatable columns,
status of release,
version number,
product name,
5version and status information for component products,
global database name,
global database name,
8transaction branch ID at this database of the connection,
1session number at this database of the connection,
2the database id at the other end of the connection,
G"C" for request commit, else "N" for prepare or request readonly commit,
-in: name of local user; out: owner of db link,
/in: client database name; out: outgoing db link,
1"in" for incoming connections, "out" for outgoing,
Linformation about incoming and outgoing connections for pending transactions,
/global commit number for committed transactions,
8Oracle user name of the end-user at the topmost database,
)name of the host machine for the end-user,
8operating system specific name for the end-user terminal,
/operating system specific name for the end-user,
Dtime automatic recovery (RECO) last tried to recover the transaction,
:time of manual force decision (null if not forced locally),
Bvalue of SYSDATE when the row was inserted (tx or system recovery),
%text for "commit work comment <text>",
'C for commit, R for rollback, else null,
qyes => part of the transaction committed and part rolled back (commit or rollback with the FORCE option was used),
Bcollecting, prepared, committed, forced commit, or forced rollback,
globally unique transaction id,
!string of form: n.n.n, n a number,
5info about distributed transactions awaiting recovery,
Timestamp for the grant,
,Permission to make REFERENCES to the column?,
Permission to UPDATE the column?,

No comments:

Oracle DBA

anuj blog Archive