OraFAQ Forum: Client Tools » Need to know all environment set in the current setup.

Home » Other » Client Tools » Need to know all environment set in the current setup.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Need to know all environment set in the current setup. [message #420564]

Mon, 31 August 2009 07:17

gauravsunil
Messages: 68
Registered: August 2007
Location: bhubaneswar

Member

Hi Experts,

I ams using following version of oracle:

SQL> SELECT * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE    10.2.0.4.0      Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Productio
NLSRTL Version 10.2.0.4.0 - Production

5 rows selected.

Elapsed: 00:00:00.04

I want to know the current environment setup values in the current session.
For example whether timer is ON or OFF. Whats the pagesize etc.

Please help me.

Thanks and Regards,
Sunil

Report message to a moderator