Re: show parameter in sqlplus

unter_at_mecati.mecasoft.ch (Stefano UNTERNAEHRER) wrote:
>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 \
>/________________________) (____________________________\

Stefano,

Try this:

SELECT VALUE FROM V$PARAMETER WHERE NAME='-you-name-it-';

Be sure to be case-sensitive. I know in Unix the NAME values are like 'db_name' or 'control_files', etc...

Hope this helps.

Mike Morgan
Technology Integration Services - Unix DBA

email: Mike.Morgan_at_teldta.com

TDS Computing Services
301 S. Westfield Road
Madison, WI 53705 USA
(608)845-4661

"The DBA is always right ... even when [s]he's wrong."