Re: show parameter sort

From: Alex Ivascu <alex_at_ivascu.com>
Date: Wed, 29 May 2002 20:10:37 GMT
Message-ID: <1BaJ8.11615$jt6.3433786@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:10:37 CDT

Re: show parameter sort_area ?