1、 求当前会话的SID，SERIAL# SELECT Sid, Serial# FROM V$session WHERE Audsid = Sys_Context( USERENV , SESSIONID ) -1, for the current session of the SID, SERIAL# SELECT Sid, Serial# FROM V $ session WHERE Audsid = Sys_Context ( ' USERENV' ,

Oracle数据库性能调优，包括了对SHARED POOL、SGA的调优，也包括了SQL语句调优，是一本好书。-Oracle database performance tuning, including the SHARED POOL, SGA tuning in, but also tuning the SQL statement is a good book.

oracle tuning (table space,log buffer ...)