Re: SQL Trace

"Sha" <ssha53_at_singnet.com.sg> wrote in message news:bi5j2i$4nn$1_at_mawar.singnet.com.sg...
> Hi again
>
> Is this resource intensive ?

In terms of response time no. In terms of disk space and dba troubleshooting time absolutely yes. sql_trace=true implies you wish to capture every statement issued by every session against the db while the instance is up and save them to disk. I can think of very few instances in which this would be either true or worthwhile. Most times you wish to capture problem sessions for the duration of a problem. To effectively tune you need to isolate and reproduce the problem. see my other answer for a suggested approach. reading that elaborates further would be the Oracle Performance Tuning 101 book
(http://www.amazon.com/exec/obidos/ASIN/0072131454/qid%3D1061583353/sr%3D11- 1/ref%3Dsr%5F11%5F1/103-3520369-3405433)

or Christopher Lawsons excellent Art and Science of Oracle Performance Tuning.

(http://www.amazon.com/exec/obidos/tg/detail/-/1590591992/qid=1061583215/sr= 1-3/ref=sr_1_3/103-3520369-3405433?v=glance&s=books)

those links will likely wrap

NB you would also wish to set MAX_DUMPFILE_SIZE (or very similar name) to unlimited to get all information.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************