Re: how to list out all system variables?

As you say you are using 8i the old server manager command show parameter <string> works now in sqlplus as well.

eg

SQL*Plus: Release 8.1.6.0.0 - Production on Thu Jan 18 09:18:47 2001

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Connected to:
Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production JServer Release 8.1.6.0.0 - Production

SQL> show parameter dump

NAME                                 TYPE    VALUE
------------------------------------ ------- -----------------------------
background_dump_dest                 string  g:\oracle\admin\agr\bdump
max_dump_file_size                   string  10000
user_dump_dest                       string  g:\oracle\admin\agr\udump

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Billy Collins" <billy_collins_at_my-deja.com> wrote in message
news:944haq$3a0$1_at_nnrp1.deja.com...


> Thanks Ant, that helps!!

>

> Billy

>

>

> In article <AZc96.72859$VS4.2170631_at_telenews.teleline.es>,

>   "Ant" <anorfri_at_teleline.es> wrote:

> > Try with tables:

> >

> > v$parameter

> > v$system_parameter

> > v$mls_parameters

> > v$nls_parameters

> >

> > Regards

> >

> > Ant

>

>

> Sent via Deja.com

> http://www.deja.com/