Re: show parameter in sqlplus

Query the V$ tables for the parameters you are looking for (i.e. v$parameter, v$sga, etc). You will find descriptions of these tables in the appendix of the Server Administration Guide.

<<<< cwashing_at_cais.com >>>>>

In article <DDpxqL.Gnr_at_mecati.mecasoft.ch> unter_at_mecati.mecasoft.ch (Stefano UNTERNAEHRER) writes:>From: unter_at_mecati.mecasoft.ch (Stefano UNTERNAEHRER)
>Subject: show parameter in sqlplus
>Date: Tue, 22 Aug 1995 15:30:20 GMT
 

>Hi!
 

>I would like to ask some parameter during an sqlplus session
>accessing the same values visible with 'show parameter' using sqldba.
>In which table are they stored? I would like, for example, ask for the
>db_* parameter like db_name, db_domain, etc. as well as transactions
>and transactions_per_rollback_segment .....
>Any idea?
>Thanks,
>Stefano
 

> ____________________________
>______________________| Stefano Unternaehrer |__________________________
>\ Mecasoft SA | Oracle DBA | fax: +41 93 335 507 /
> \ 6600 Muralto | and PL/SQL, Pro*C | voice: +41 93 337 444 /
> \ | C, XWindow & Motif | /
> / | Software Developer | email: \
> / Switzerland Europe |____________________________| dba,unter_at_mecasoft.ch \
>/________________________) (____________________________\
Received on Wed Aug 23 1995 - 00:00:00 CEST