--- Info ---
PL/SQL Developer
Version 10.0.1.1694
83.86984 - Unlimited user license
Windows 7 (64-bit) 6.1 Build 7601 (Service Pack 1)
Physical memory : 4,193,848 kB (2,592,032 available)
Paging file : 4,194,304 kB (4,194,304 available)
Virtual memory : 2,097,024 kB (1,846,164 available)
Parameters
C:\Program Files (x86)\PLSQL Developer\plsqldev.exe
Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Allow Multiple Connections: True
Preference Files
C:\Program Files (x86)\PLSQL Developer\Preferences\Default\Default.ini
C:\Users\sbon8063\AppData\Roaming\PLSQL Developer\Preferences\sbon8063\default.ini
Plug-Ins
*Active Query Builder (C:\Program Files (x86)\PLSQL Developer\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files (x86)\PLSQL Developer\PlugIns\plsqldoc.dll)
*Red Gate Deployment Plug-In (C:\Program Files (x86)\PLSQL Developer\PlugIns\RedGate.dll)
*Version Control Interface 1.2 (C:\Program Files (x86)\PLSQL Developer\PlugIns\VCS.dll)
(* is Active)
Aliases
<alias>
ACE1.WORLD
BCE369
BCE622
BOX20.WORLD
...
Homes
OraClient11g_home1 (C:\app\sbon8063\product\11.2.0\client_1)
DLLs
C:\app\sbon8063\product\11.2.0\client_1\bin\oci.dll
TNS File
C:\app\sbon8063\product\11.2.0\client_1\Network\Admin\tnsnames.ora
Using
Home: OraClient11g_home1
DLL: C:\app\sbon8063\product\11.2.0\client_1\bin\oci.dll
OCI: version 11.1
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0
Character Sets
Character size: 1 byte(s)
CharSetID: 873
NCharSetID: 2000
Unicode Support: True
NLS_LANG: AMERICAN_AMERICA.UTF8
NLS_CHARACTERSET: WE8ISO8859P15
NLS_NCHAR_CHARACTERSET: AL16UTF16
--- Registry ---
SOFTWARE\ORACLE
inst_loc = C:\Program Files (x86)\Oracle\Inventory
SOFTWARE\ORACLE\KEY_OraClient11g_home1
ORACLE_HOME = C:\app\sbon8063\product\11.2.0\client_1
ORACLE_HOME_NAME = OraClient11g_home1
ORACLE_GROUP_NAME = Oracle - OraClient11g_home1
ORACLE_BUNDLE_NAME = Enterprise
NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
OLEDB = C:\app\sbon8063\product\11.2.0\client_1\oledb\mesg
OO4O = C:\app\sbon8063\product\11.2.0\client_1\oo4o\mesg
ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OraClient11g_home1
SQLPATH = C:\app\sbon8063\product\11.2.0\client_1\dbs
SOFTWARE\ORACLE\KEY_OraClient11g_home1\OLEDB
CacheType = Memory
EnableCmdTimeout = 0
ChunkSize = 100
DistribTX = 1
FetchSize = 100
OSAuthent = 0
PLSQLRset = 0
PwdChgDlg = 1
SchRstLng = 10000
UserDefFn = 0
DisableRetClause = 1
VCharNull = 1
TraceCategory = 0
TraceFileName = c:\OraOLEDB.trc
TraceLevel = 0
TraceOption = 0
SPPrmDefVal = 0
StmtCacheSize = 0
MetaDataCacheSize = 0
DBNotifications = 0
DeferUpdChk = 0
SOFTWARE\ORACLE\KEY_OraClient11g_home1\OO4O
CacheBlocks = 20
FetchLimit = 100
FetchSize = 4096
HelpFile = C:\app\sbon8063\product\11.2.0\client_1\oo4o\doc\oraclec.chm
PerBlock = 16
SliceSize = 256
TempFileDirectory = c:\temp
OO4O_HOME = C:\app\sbon8063\product\11.2.0\client_1\oo4o
SOFTWARE\ORACLE\ODP.NET
SOFTWARE\ORACLE\ODP.NET\2.112.1.0
DllPath = C:\app\sbon8063\product\11.2.0\client_1\bin
TraceFileName = C:\odpnet2.trc
TraceLevel = 0
TraceOption = 0
PromotableTransaction = promotable
SelfTuning = 1
StatementCacheWithUdts = 1
UdtCacheSize = 4096
PerformanceCounters = 0
MaxStatementCacheSize = 100
DemandOraclePermission = 0
--- Path ---
C:\app\sbon8063\product\11.2.0\client_1\bin
C:\Program Files (x86)\CollabNet
C:\Program Files (x86)\Embarcadero\RAD Studio\11.0\bin
C:\Users\Public\Documents\RAD Studio\11.0\Bpl
C:\Program Files (x86)\Embarcadero\RAD Studio\11.0\bin64
C:\Users\Public\Documents\RAD Studio\11.0\Bpl\Win64
C:\Windows\system32
C:\Windows
C:\Windows\System32\Wbem
C:\Windows\System32\WindowsPowerShell\v1.0\
C:\Program Files (x86)\WinMerge
C:\app\sbon8063\product\11.1.0\client_3\bin
C:\Program Files\Development\CoreComps
C:\Program Files\Development\Geneva
--- TNS names ---
# This file contains the syntax information for
# the entries to be put in any tnsnames.ora file
# The entries in this file are need based.
# There are no defaults for entries in this file
# that Sqlnet/Net3 use that need to be overridden
#
# Typically you could have two tnsnames.ora files
# in the system, one that is set for the entire system
# and is called the system tnsnames.ora file, and a
# second file that is used by each user locally so that
# he can override the definitions dictated by the system
# tnsnames.ora file.
# The entries in tnsnames.ora are an alternative to using
# the names server with the onames adapter.
# They are a collection of aliases for the addresses that
# the listener(s) is(are) listening for a database or
# several databases.
# The following is the general syntax for any entry in
# a tnsnames.ora file. There could be several such entries
# tailored to the user's needs.
<alias>= [ (DESCRIPTION_LIST = # Optional depending on whether u have
# one or more descriptions
# If there is just one description, unnecessary ]
(DESCRIPTION=
[ (SDU=2048) ] # Optional, defaults to 2048
# Can take values between 512 and 32K
[ (ADDRESS_LIST= # Optional depending on whether u have
# one or more addresses
# If there is just one address, unnecessary ]
(ADDRESS=
[ (COMMUNITY=<community_name>) ]
(PROTOCOL=tcp)
(HOST=<hostname>)
(PORT=<portnumber (1521 is a standard port used)>)
)
[ (ADDRESS=
(PROTOCOL=ipc)
(KEY=<ipckey (PNPKEY is a standard key used)>)
)
]
[ (ADDRESS=
[ (COMMUNITY=<community_name>) ]
(PROTOCOL=decnet)
(NODE=<nodename>)
(OBJECT=<objectname>)
)
]
... # More addresses
[ ) ] # Optional depending on whether ADDRESS_LIST is used or not
[ (CONNECT_DATA=
(SID=<oracle_sid>)
[ (GLOBAL_NAME=<global_database_name>) ]
)
]
[ (SOURCE_ROUTE=yes) ]
)
(DESCRIPTION=
[ (SDU=2048) ] # Optional, defaults to 2048
# Can take values between 512 and 32K
[ (ADDRESS_LIST= ] # Optional depending on whether u have more
# than one address or not
# If there is just one address, unnecessary
(ADDRESS
[ (COMMUNITY=<community_name>) ]
(PROTOCOL=tcp)
(HOST=<hostname>)
(PORT=<portnumber (1521 is a standard port used)>)
)
[ (ADDRESS=
(PROTOCOL=ipc)
(KEY=<ipckey (PNPKEY is a standard key used)>)
)
]
... # More addresses
[ ) ] # Optional depending on whether ADDRESS_LIST
# is being used
[ (CONNECT_DATA=
(SID=<oracle_sid>)
[ (GLOBAL_NAME=<global_database_name>) ]
)
]
[ (SOURCE_ROUTE=yes) ]
)
[ (CONNECT_DATA=
(SID=<oracle_sid>)
[ (GLOBAL_NAME=<global_database_name>) ]
)
]
... # More descriptions
[ ) ] # Optional depending on whether DESCRIPTION_LIST is used or not
DEV5.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (COMMUNITY = TCP.world)(PROTOCOL = TCP)(HOST = camdl106.emea.convergys.com)(PORT = 1521)))
(CONNECT_DATA = (SID = DEV5)
)
)
