CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle DBMS_SERVER_TRACE
Version 11.1
 
General
Note: This package is not supported for external use and should be limited to use by only DDR and internal development.
Source $ORACLE_HOME/rdbms/admin/dbmstcv.sql
Dependencies
DBMS_SERVER_TRACE_LIB
Security Model Execute is granted to PUBLIC
 
CONVERT_BINARY_TRACE_FILE

The built-in package used by TKPROF for trace file conversion

And again, thank you to Richard Foote, for the "Bowie stuff."
dbms_server_trace.convert_binary_trace_file(
infile  IN VARCHAR2,
outfile IN VARCHAR2,
fmode   IN BOOLEAN);  -- TRUE if default format, FALSE if user defined
conn uwclass/uwclass

SQL> CREATE TABLE bowie_stuff (
2 album VARCHAR2(30),
3 year NUMBER,
4 rating VARCHAR2(30));

Table created.

SQL> INSERT INTO bowie_stuff VALUES ('Man Who Sold The World', 1970, 'Bloody Good!!');

1 row created.

SQL> INSERT INTO bowie_stuff VALUES ('Diamond Dogs', 1974 , 'Brilliant');

1 row created.

SQL> INSERT INTO bowie_stuff VALUES ('Outside', 1995, 'Underrated Masterpiece');

1 row created.

SQL> COMMIT;

Commit complete.

SQL> SELECT album,
2 dbms_rowid.rowid_to_absolute_fno(rowid, 'UWCLASS', 'BOWIE_STUFF') ABSOLUTE_FNO, dbms_rowid.rowi
d_block_number(rowid) BLOCKNO, dbms_rowid.rowid_row_number(rowid) ROWNUMBER
3 FROM bowie_stuff
4 WHERE album LIKE '%Dogs%';

ALBUM ABSOLUTE_FNO BLOCKNO ROWNUMBER
------------------------------ ------------ ---------- ----------
Diamond Dogs 6 8586 1

SQL> conn / as sysdba
Connected.
SQL> ALTER SYSTEM DUMP DATAFILE 6 BLOCK 8586;

System altered.

SQL> exec dbms_server_trace.convert_binary_trace_file( 'c: emp\ukoug_ora_1428.trc', 'c: emp race_
output.txt', TRUE);
BEGIN dbms_server_trace.convert_binary_trace_file( 'c: emp\ukoug_ora_1428.trc', 'c: emp race_outp

*
ERROR at line 1:
ORA-02488: Error encountered when accessing file [c: emp\ukoug_ora_1428.trc]
for trace conversion
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch (OS 35739)
ORA-06512: at "SYS.DBMS_SERVER_TRACE", line 10
ORA-06512: at line 1

SQL> 

/* So while one might expect it to work this way ... it does not. If anyone can suggest a solution please do so. It appears it wants a trace file that is exactly 8K. */
 
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [251 users online]    © 2010 psoug.org