This artical gives some useful hints on tuning a database. It goes into some detail about how to track down problems in the database and then go about fixing them.
...
Tracing Someone Else's Code. Activating extended SQL trace becomes a little trickier when you're trying to trace code to which you don't have read/write access. But it's not much more difficult. The first thing you need to do is acquire the V$SESSION.SID and V$SESSION.SERIAL# values of the session you want to trace. Then you can set the TIMED_STATISTICS and MAX_DUMP_FILE_SIZE parameters for the chosen session by using the following procedure calls:
dbms_system.set_bool_param_in_session(
sid => 42,
serial# => 1215,
parnam => 'timed_statistics',
bval => true)
dbms_system.set_int_param_in_session(
sid => 42,
serial# => 1215,
parnam => 'max_dump_file_size',
intval => 2147483647)
...
--> read the full article
Leave a comment