Database Tuning‎ > ‎

Toad Configuration setting

posted Dec 20, 2011, 9:56 AM by Sachchida Ojha

************************************************************************
Oracle Client Version : 11.2.0.1.0
Oracle Client DLL : C:\oracli\11.2.0\BIN\oci.dll
TNSNAMES.ora Location : C:\oracli\11.2.0\Network\Admin\tnsnames.ora
NLS_LANG : AMERICAN_AMERICA.WE8MSWIN1252
SQLPATH : C:\oracli\11.2.0\dbs
LOCAL :

************************************************************************
ORACLE SERVER INFORMATION
************************************************************************
Connection 1 : snojha@testdb.WORLD   ** Active Session **
Oracle Server Version : Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
Oracle Server NLS_CHARACTERSET : US7ASCII
Oracle Server NLS_NCHAR_CHARACTERSET : AL16UTF16
Oracle Session User : R2USCO (Normal)

************************************************************************
SYSTEM INFORMATION
************************************************************************
Operating System : Windows XP (Build 2600) Service Pack 3
Is Terminal Server: No
Using XP Theme: No

Physical Memory Load : 71.70 %
Physical Memory (Total) : 2035 MB
Physical Memory (Free) : 576 MB
Virtual Memory (Total) : 2047 MB
Virtual Memory (Free) : 1817 MB
Swap Space (Total) : 3915 MB
Swap Space (Free) : 2623 MB

Environment Variable (PATH) :
     C:\Program Files\RSA SecurID Token Common
     C:\Program Files\Business Objects\Common\3.5\bin\NOTES\
     C:\Program Files\Business Objects\Common\3.5\bin\NOTES\DATA\
     C:\oracli\11.2.0\bin
     %SystemRoot%\system32
     %SystemRoot%
     %SystemRoot%\System32\Wbem
     c:\Program Files\Common Files\Roxio Shared\DLLShared\
     y:
     w:
     x:\prod\sybcli\12\dll
     x:\prod\sybcli\12\bin
     X:\UTIL
     X:\Prod\Runtime
     C:\Program Files\IBM\RationalSDLC\ClearCase\bin
     C:\Program Files\IBM\RationalSDLC\common
     C:\Program Files\Windows Imaging\

Environment Variable (TNS_ADMIN) : TNS_ADMIN is not a declared environment variable.

************************************************************************
ORACLE HOMES DATA
************************************************************************
(Oracle Root)
     inst_loc = C:\Program Files\Oracle\Inventory
KEY_Oracle11gr2 ***** This is the home currently used by Toad *****
     ORACLE_HOME = C:\oracli\11.2.0
     ORACLE_HOME_NAME = Oracle11gr2
     ORACLE_GROUP_NAME = Oracle - Oracle11gr2
     ORACLE_BUNDLE_NAME = Enterprise
     NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
     OLEDB = C:\oracli\11.2.0\oledb\mesg
     OO4O = C:\oracli\11.2.0\oo4o\mesg
     MSHELP_TOOLS = C:\oracli\11.2.0\MSHELP
     SQLPATH = C:\oracli\11.2.0\dbs

Comments