from from unix prompt, when run sqlplus apps/apps, you may see something like
SQL*Plus: Release 9.2.0.8.0 - Production on Wed Mar 5 18:31:25 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
Now try sqlplus -s apps/apps
You will not see any of the above information displayed in yellow color.
Q. How can I get location of trace files?
A: Run this query and you will get the location trace files.
select value from v$parameter where name = 'user_dump_dest'
No comments:
Post a Comment