OraFAQ Forum: Server Administration » User Tracing Information in new file

Home » RDBMS Server » Server Administration » User Tracing Information in new file

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

User Tracing Information in new file [message #63536]

Wed, 13 October 2004 21:08

sujatha
Messages: 15
Registered: May 1999

Junior Member

In Oracle 8i when a user session is traced information is stored in a file�in user_dump_dest directory.

How to ensure that for subsequent tracing enabled the information gets stored in a new file rather than in the existing file without touching the parameter user_dump_dest as it involves bouncing the database.

Report message to a moderator

Re: User Tracing Information in new file [message #63540 is a reply to message #63536]

Thu, 14 October 2004 03:13

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

ORACLE recomends to follow the OFA.

mag@mutation_mutation > alter system set user_dump_dest='/u01/app/oracle/admin/mutation/udump';

System altered.
mag@mutation_mutation > show parameter user_dump

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
user_dump_dest                       string      /u01/app/oracle/admin/mutation
                                                 /udump

Report message to a moderator

Previous Topic:	default timestamp-Format
Next Topic:	Rebuild table in same tablespace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 24 23:09:47 CST 2025