Re: show parameter sort_area ?

I stand corrected. In 8i it works in both modules, not just SQL*Plus. Thanks.

Alex

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:ufafik8prr3adf_at_corp.supernews.com...
> Sorry, this is not true.
> Initially (pre 8i) this was possible in *svrmgrl* only and *not* in
> sql*plus.
> In 8i it should work in sql*plus, provided you have the dba role or the
> select_catalog_role.
>
> Hth
>
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
> to reply remove '-verwijderdit' from my e-mail address
>
> "Alex Ivascu" <alex_at_ivascu.com> wrote in message
> news:1BaJ8.11615$jt6.3433786_at_typhoon3.we.ipsvc.net...
> > It sounds like you're trying to execute/select this from within svrmgrl.
> > You can/have to use this command from sql*plus - only. In svrmgrl you
can
> > run a query such as this: select value from v$parameter where
> > name='sort_area';
> >
> > Hope this helps.
> >
> > Alex Ivascu
> >
> >
> > "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?
> >
> >
>
>
Received on Wed May 29 2002 - 15:56:55 CDT