Re: show parameter sort_area ?

> > > "Ryan Gaffuri" <rgaffuri_at_cox.net> wrote in message
> > > news:1efdad5b.0205291132.a62c5fc_at_posting.google.com...
> > > > I am reading Tom Kyte's book and I see in one of his examples he does
> > > > the following
> > > >
> > > > show parameter sort_area and gets some information back.
> > > >
> > > > I get an error saying that this is an unknown command for both
> > > > parameter and sort area. Im on 8.1.7 Im assuming I have to set
> > > > something up to do use this?
>

> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> > In 8i it should work in sql*plus, provided you have the dba role or the
> > select_catalog_role.

"Ryan" <rgaffuri_at_cox.net> writes:
> I have the dba role. Could it be anything else?

Ryan,

Here are a few more things to try.

Log into SQL*Plus as SYSTEM and do

   SELECT FROM V$PARAMETER WHERE NAME LIKE 'sort_area%'; and also do

   SHOW PARAMETER sort_area

Both of these should work. If they don't then give us the exact errors, and the versions of the database and of SQL*Plus itself.

Chris

-- 
Christopher Jones, Oracle Corporation, Australia.