Wednesday, March 26, 2008

How to Hide Sql*Plus release/Copyright info

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