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 - Production on Wed Mar 5 18:31:25 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release - 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