show parameter in sqlplus
From: Stefano UNTERNAEHRER <unter_at_mecati.mecasoft.ch>
Date: 1995/08/22
Message-ID: <DDpxqL.Gnr_at_mecati.mecasoft.ch>#1/1
Date: 1995/08/22
Message-ID: <DDpxqL.Gnr_at_mecati.mecasoft.ch>#1/1
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 Tue Aug 22 1995 - 00:00:00 CEST