-
编辑 删除
oracle sleep function
sys.dbms_lock.sleep(0.5); 0.5---s
-
编辑 删除
trace lsnrctl
strace lsnrtcl start this command will help to trace failure reason.
-
编辑 删除
oracle character set
-- 3.5 字符集的更改 ( P94 )-- 数据库创建以后，如果需要修改字符集，通常需要重建数据库，通过导入导出的方式来转换。也可以通过以下方式更改：ALTER DATABASE CHARACTER SET -- 注意修改数据库字符集时必须...
-
编辑 删除
workarea_size_policy
alter session set workarea_size_policy=manual;alter session set sort_area_size = 尽量大一点的值
-
编辑 删除
track somebody do in oracle
create table sys.audit_tracefile (logontime date, sid number, ins_id num...
-
编辑 删除
semi join and anti join
http://www.dbafree.net/?p=224
-
编辑 删除
consistent gets and db block gets
http://mwidlake.wordpress.com/2009/06/02/what-are-consistent-gets/ http://jonathanlewis.wordpress.com/2009/06/12/consistent-gets-2/
-
编辑 删除
v$session
V$SESSION中的连接列Column &nb...
-
编辑 删除
v$mystat, v$statname
v$mystat by which we can select current session id and performance consume. v$sessstat is for sessions sid of instance v$sysstat is for all session of database. v$sta...
-
编辑 删除
dump file (index, block, control file, log ,date file)
dump index: alter session set events 'immediate trace name treedump level <object_id>'; dump control file: alter session set events 'immediate trace name controlf level 10'; ...
-
编辑 删除
oracle rowid detail
the following is my practise based on warehose's rowidselect u.rowid from knta_users u where u.username='admin';A-Z (0-25),a-z(26-51),0-9(52-61),+(62),/(63)AAATDT---object_id 19*power(64,2)+3*64+19...
