Archives

You are currently viewing archive for November 2009

11/16: Oracle > tips

Category: Oracle
Posted by: hajime osako
sqlplus:
set linesize 160
set pagesize 10000
set numformat 99999999999999999999999
alter session set NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
set serveroutput on

Performance check:
V$SESSION_WAIT
V$SYSTEM_EVENT
Category: Oracle
Posted by: hajime osako
%u30C7%u30FC%u30BF%u30D9%u30FC%u30B9%u3092%u7279%u5B9A%u3059%u308B%u540D%u524D - %u30AA%u30E9%u30AF%u30EB%u30FBOracle%u3092%u30DE%u30B9%u30BF%u30FC%u3059%u308B%u305F%u3081%u306E%u57FA%u672C%u3068%u4ED5%u7D44%u307F

DBID (Database Identifer)
SELECT DBID,NAME,DB_UNIQUE_NAME,CURRENT_SCN,LOG_MODE FROM V$DATABASE;

SID (System Identifer)
Used in the host server to access shared memory.
Set in environment variables

INSTANCE_NAME
Used from outside of the host.
show parameter instance_name

DB_NAME
show parameter db_name

GLOBAL_NAME
Used to create DATABASE LINK

SERVICE_NAME
Used by LISTENER / TNSNAMES
show parameter service_name