Are you logged in as sysdba? Or system?

| Henry A.L. Wollman Rejoice and be glad!
|_____________________________________________________
| Moody Bible Institute, Database Administrator, [Email address protected]
| 820 N. LaSalle Blvd, Chicago, IL 60610 312-329-2291
|_____________________________________________________

-----Original Message-----
From: LeRoy Martin
[mailto:oracledba-ezmlmshield-x88819.[Email address protected]
Sent: Thursday, June 01, 2006 2:40 PM
To: LazyDBA Discussion
Subject: Can not show parameters

Hello,

Oracle 9.2.0.7 Enterprise
Windows 2003 Server

When I try to show parameters, I get the following error:

SQL> show sga
unknown SHOW option "sga"
SQL> show parameter pool
unknown SHOW option "parameter"
unknown SHOW option "pool"

How would I resolve this?
Thank you,

Martin


----------------------------------------------------------------------------
--
This message is intended only for the personal and confidential use of the
designated recipient(s) named. If you are not the intended recipient of this
message, you are hereby notified that any review, dissemination,
distribution or copying of this message is strictly prohibited. This
communication is for information purposes only and should not be regarded as
an offer to sell or as a solicitation of an offer to buy any financial
product, an official confirmation of any transaction, or as an official
statement of Aurora Loan Services. Email transmission cannot be guaranteed
to be secure or error-free. Therefore, we do not represent that this
information is complete or accurate and it should not be relied upon as
such. All information is subject to change without notice.



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page