Or at least with as DBA?

-----Original Message-----
From: henry Wollman
[mailto:oracledba-ezmlmshield-x57962558.[Email address protected]
Sent: Thursday, June 01, 2006 4:02 PM
To: LazyDBA Discussion
Subject: RE: Can not show parameters


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



--------
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