Oracle DBMS_SERVER


	CODE Oracle Code Library


	JOBS Find Or Post Oracle Jobs


	FORUM Oracle Discussion & Chat

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