sqltracefile - Oracle Database

Hi all,

How to find out sqltrace log file in oracle ..

For example ,
I deleted one row. that informartion are log into one log files. i want find that locations of this log files.

Sep 17 '07 #1

Subscribe Post Reply

1284

amitpatel66

2,367

Expert 2GB

Hi all,

How to find out sqltrace log file in oracle ..

For example ,
I deleted one row. that informartion are log into one log files. i want find that locations of this log files.

Run the below Query which will give you the path for log file:

Expand|Select|Wrap|Line Numbers

select value from v$parameter where name = 'background_dump_dest'

Sep 17 '07 #2

holdingbe

Run the below Query which will give you the path for log file:

Expand|Select|Wrap|Line Numbers

select value from v$parameter where name = 'background_dump_dest'

hi

thanks for information.. now i find that

Sep 17 '07 #3