Home » SQL & PL/SQL » Client Tools » Need to know all environment set in the current setup.
Need to know all environment set in the current setup. [message #420564] Mon, 31 August 2009 07:17 Go to next message
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
Re: Need to know all environment set in the current setup. [message #420565 is a reply to message #420564] Mon, 31 August 2009 07:22 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10621
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
show all
Re: Need to know all environment set in the current setup. [message #420566 is a reply to message #420565] Mon, 31 August 2009 07:34 Go to previous message
gauravsunil
Messages: 68
Registered: August 2007
Location: bhubaneswar
Member
Thank you very much Mahesh.
Previous Topic: code the web site
Next Topic: deinstall 8i client
Goto Forum:
  


Current Time: Fri Aug 29 15:12:19 CDT 2014

Total time taken to generate the page: 0.23809 seconds