Oracle 11g r2 メモ

メモ
ユーザ確認
show user;

テーブル一覧
select * from tab;

テーブル情報
desc テーブル名;(SQL*Plus)



環境変数確認
Unix環境 

Unix環境だと、env コマンドで環境変数で調べれるはず、試していないけど

Windows環境 

環境変数がレジストリに登録されているため、レジストリを調べればわかる。調べ方は直接レジストリを開いて調べるか、DOSコマンド"reg query"でも調べれる。 （参考１）

C:\Documents and Settings\USER_NAME>reg query "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE" /s

! REG.EXE VERSION 3.0

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
    inst_loc	REG_SZ	C:\Program Files\Oracle\Inventory

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb11g_home1
    ORACLE_HOME	REG_SZ	D:\Oracle\product\11.2.0\dbhome_1
    ORACLE_HOME_NAME	REG_SZ	OraDb11g_home1
    ORACLE_GROUP_NAME	REG_SZ	Oracle - OraDb11g_home1
    NLS_LANG	REG_SZ	JAPANESE_JAPAN.JA16SJISTILDE
    ORACLE_BUNDLE_NAME	REG_SZ	Standard
    OLEDB	REG_SZ	D:\Oracle\product\11.2.0\dbhome_1\oledb\mesg
    ORAMTS_CP_TRACE_LEVEL	REG_SZ	0
    ORAMTS_CP_TRACE_DIR	REG_SZ	D:\Oracle\product\11.2.0\dbhome_1\oramts\Trace
    ORAMTS_CONN_POOL_TIMEOUT	REG_SZ	120
    ORAMTS_SESS_TXNTIMETOLIVE	REG_SZ	120
    ORAMTS_NET_CACHE_MAXFREE	REG_SZ	5
    ORAMTS_NET_CACHE_TIMEOUT	REG_SZ	120000
    ORAMTS_OSCREDS_MATCH_LEVEL	REG_SZ	OS_AUTH_LOGIN
    OO4O	REG_SZ	D:\Oracle\product\11.2.0\dbhome_1\oo4o\mesg
    ORACLE_HOME_KEY	REG_SZ	SOFTWARE\ORACLE\KEY_OraDb11g_home1
    MSHELP_TOOLS	REG_SZ	D:\Oracle\product\11.2.0\dbhome_1\MSHELP
    SQLPATH	REG_SZ	D:\Oracle\product\11.2.0\dbhome_1\dbs
    ORACLE_BASE	REG_SZ	D:\Oracle
    RDBMS_CONTROL	REG_SZ	D:\Oracle\product\11.2.0\dbhome_1\DATABASE
    RDBMS_ARCHIVE	REG_SZ	D:\Oracle\product\11.2.0\dbhome_1\DATABASE\ARCHIVE
    ORA_ORCL_AUTOSTART	REG_EXPAND_SZ	TRUE
    ORA_ORCL_SHUTDOWN	REG_EXPAND_SZ	TRUE
    ORA_ORCL_SHUTDOWNTYPE	REG_EXPAND_SZ	immediate
    ORA_ORCL_SHUTDOWN_TIMEOUT	REG_EXPAND_SZ	90
    ORACLE_SID	REG_SZ	orcl

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb11g_home1\OLEDB
    CacheType	REG_SZ	Memory
    EnableCmdTimeout	REG_SZ	0
    ChunkSize	REG_SZ	100
    DistribTX	REG_SZ	1
    FetchSize	REG_SZ	100
    OSAuthent	REG_SZ	0
    PLSQLRset	REG_SZ	0
    PwdChgDlg	REG_SZ	1
    SchRstLng	REG_SZ	10000
    UserDefFn	REG_SZ	0
    DisableRetClause	REG_SZ	1
    VCharNull	REG_SZ	1
    TraceCategory	REG_SZ	0
    TraceFileName	REG_SZ	c:\OraOLEDB.trc
    TraceLevel	REG_SZ	0
    TraceOption	REG_SZ	0
    SPPrmDefVal	REG_SZ	0
    StmtCacheSize	REG_SZ	0
    MetaDataCacheSize	REG_SZ	0
    DBNotifications	REG_SZ	0
    DeferUpdChk	REG_SZ	0

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb11g_home1\OO4O
    CacheBlocks	REG_SZ	20
    FetchLimit	REG_SZ	100
    FetchSize	REG_SZ	4096
    HelpFile	REG_SZ	D:\Oracle\product\11.2.0\dbhome_1\oo4o\doc\oraclec.chm
    PerBlock	REG_SZ	16
    SliceSize	REG_SZ	256
    TempFileDirectory	REG_SZ	c:\temp
    OO4O_HOME	REG_SZ	D:\Oracle\product\11.2.0\dbhome_1\oo4o

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ODP.NET

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ODP.NET\2.112.1.0
    DllPath	REG_SZ	D:\Oracle\product\11.2.0\dbhome_1\bin
    TraceFileName	REG_SZ	C:\odpnet2.trc
    TraceLevel	REG_SZ	0
    TraceOption	REG_SZ	0
    PromotableTransaction	REG_SZ	promotable
    SelfTuning	REG_SZ	1
    StatementCacheWithUdts	REG_SZ	1
    UdtCacheSize	REG_SZ	4096
    PerformanceCounters	REG_SZ	0
    MaxStatementCacheSize	REG_SZ	100
    DemandOraclePermission	REG_SZ	0

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OracleMTSRecoveryService

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OracleMTSRecoveryService\Protid_0
    Name	REG_SZ	HTTP
    Host	REG_SZ	alphapc
    Port	REG_SZ	49152

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OracleMTSRecoveryService\Setup
    NumberOfInstalls	REG_DWORD	0x1

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OracleMTSRecoveryService\Setup\All Versions

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OracleMTSRecoveryService\Setup\All Versions\1
    Version	REG_SZ	11.2.0.1.0
    Home	REG_SZ	SOFTWARE\ORACLE\KEY_OraDb11g_home1

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OracleMTSRecoveryService\Setup\Current Version
    Version	REG_SZ	11.2.0.1.0
    Home	REG_SZ	SOFTWARE\ORACLE\KEY_OraDb11g_home1

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\SYSMAN

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\SYSMAN\OracleDBConsoleorcl
    EMDROOT	REG_SZ	D:\Oracle\product\11.2.0\dbhome_1
    ORACLE_HOME	REG_SZ	D:\Oracle\product\11.2.0\dbhome_1
    EMSTATE	REG_SZ	D:\Oracle\product\11.2.0\dbhome_1\alphapc_orcl
    CONSOLE_CFG	REG_SZ	dbconsole
    ORACLE_SID	REG_SZ	orcl
    TIMEOUT	REG_SZ	15
    TRACE_LEVEL	REG_SZ	16

ドライバなど