| 订阅 | 在线投稿
分享
 
 
当前位置: 王朝网络 >> oracle >> Oracle shu ju ku wei hu chang yong SQL yu ju ji he (3)
 

Oracle shu ju ku wei hu chang yong SQL yu ju ji he (3)

2008-07-04 06:34:30 编辑來源:互联网 评论
 
本文为【Oracle数据库维护常用SQL语句集合(3)】的拼音翻译版
  xing neng xiang guan nei rong
  1、 bu zhuo yun xing hen jiu de SQL
  column username format a12
  column opname format a16
  column progress format a8
  SELECT Username, Sid, Opname,
  Round(Sofar * 100 / Totalwork, 0) || '%' AS Progress, Time_Remaining,
  Sql_Text
  FROM V$session_Longops, V$sql
  WHERE Time_Remaining <> 0
  AND Sql_Address = Address
  AND Sql_Hash_Value = Hash_Value;
  2、 qiu DISK READ jiao duo de SQL
  SELECT St.Sql_Text
  FROM V$sql s, V$sqltext St
  WHERE s.Address = St.Address
  AND s.Hash_Value = St.Hash_Value
  AND s.Disk_Reads > 300;
  3、 qiu DISK SORT yan chong de SQL
  SELECT Sess.Username, SQL.Sql_Text, Sort1.Blocks
  FROM V$session Sess, V$sqlarea SQL, V$sort_Usage Sort1
  WHERE Sess.Serial# = Sort1.Session_Num
  AND Sort1.Sqladdr = SQL.Address
  AND Sort1.Sqlhash = SQL.Hash_Value
  AND Sort1.Blocks > 200;
  4、 jian kong suo yin shi fou shi yong
  alter index &index_name monitoring usage;
  alter index &index_name nomonitoring usage;
  select * from v$object_usage where index_name = &index_name;
  5、 qiu shu ju wen jian de I/O fen bu
  SELECT Df.NAME, Phyrds, Phywrts, Phyblkrd, Phyblkwrt, Singleblkrds, Readtim,
  Writetim
  FROM V$filestat Fs, V$dbfile Df
  WHERE Fs.File# = Df.File#
  ORDER BY Df.NAME;
  6、 cha kan huan mei ti jiao de shi wu
  select * from v$locked_object;
  select * from v$transaction;
  7、 hui gun duan cha kan
  SELECT Rownum, Sys.Dba_Rollback_Segs.Segment_Name NAME,
  V$rollstat.Extents Extents, V$rollstat.Rssize Size_In_Bytes,
  V$rollstat.Xacts Xacts, V$rollstat.Gets Gets, V$rollstat.Waits Waits,
  V$rollstat.Writes Writes, Sys.Dba_Rollback_Segs.Status Status
  FROM V$rollstat, Sys.Dba_Rollback_Segs, V$rollname
  WHERE V$rollname.NAME(+) = Sys.Dba_Rollback_Segs.Segment_Name
  AND V$rollstat.Usn(+) = V$rollname.Usn
  ORDER BY Rownum
  8、 cha kan xi tong qing qiu qing kuang
  SELECT Decode(NAME, 'summed dirty write queue length', VALUE) /
  Decode(NAME, 'write requests', VALUE) "Write Request Length"
  FROM V$sysstat
  WHERE NAME IN ('summed dirty queue length', 'write requests')
  AND VALUE > 0;
  9、 ji suan data buffer ming zhong lv
  SELECT a.VALUE + b.VALUE "logical_reads", c.VALUE "phys_reads",
  Round(100 * ((a.VALUE + b.VALUE) - c.VALUE) / (a.VALUE + b.VALUE)) "BUFFER HIT RATIO"
  FROM V$sysstat a, V$sysstat b, V$sysstat c
  WHERE a.Statistic# = 40
  AND b.Statistic# = 41
  AND c.Statistic# = 42;
  SELECT NAME,
  (1 - (Physical_Reads / (Db_Block_Gets + Consistent_Gets))) * 100 h_Ratio
  FROM V$buffer_Pool_Statistics;
  10、 cha kan nei cun shi yong qing kuang
  SELECT Least(MAX(b.VALUE) / (1024 * 1024), SUM(a.Bytes) / (1024 * 1024)) Shared_Pool_Used,
  MAX(b.VALUE) / (1024 * 1024) Shared_Pool_Size,
  Greatest(MAX(b.VALUE) / (1024 * 1024), SUM(a.Bytes) / (1024 * 1024)) -
  (SUM(a.Bytes) / (1024 * 1024)) Shared_Pool_Avail,
  ((SUM(a.Bytes) / (1024 * 1024)) / (MAX(b.VALUE) / (1024 * 1024))) * 100 Avail_Pool_Pct
  FROM V$sgastat a, V$parameter b
  WHERE (a.Pool = 'shared pool' AND a.NAME NOT IN ('free memory'))
  AND b.NAME = 'shared_pool_size';
  11、 cha kan yong hu shi yong nei cun qing kuang
  SELECT Username, SUM(Sharable_Mem), SUM(Persistent_Mem), SUM(Runtime_Mem)
  FROM Sys.v_$sqlarea a, Dba_Users b
  WHERE a.Parsing_User_Id = b.User_Id
  GROUP BY Username;
  12、 cha kan dui xiang de huan cun qing kuang
  SELECT Owner, Namespace, TYPE, NAME, Sharable_Mem, Loads, Executions, Locks,
  Pins, Kept
  FROM V$db_Object_Cache
  WHERE TYPE NOT IN
  ('NOT LOADED', 'NON-EXISTENT', 'VIEW', 'TABLE', 'SEQUENCE')
  AND Executions > 0
  AND Loads > 1
  AND Kept = 'NO'
  ORDER BY Owner, Namespace, TYPE, Executions DESC;
  SELECT TYPE, COUNT(*)
  FROM V$db_Object_Cache
  GROUP BY TYPE;
  13、 cha kan ku huan cun ming zhong lv
  SELECT Namespace, Gets, Gethitratio * 100 Gethitratio, Pins,
  Pinhitratio * 100 Pinhitratio, Reloads, Invalidations
  FROM V$librarycache
  14、 cha kan mou xie yong hu de hash
  SELECT a.Username, COUNT(b.Hash_Value) Total_Hash,
  COUNT(b.Hash_Value) - COUNT(UNIQUE(b.Hash_Value)) Same_Hash,
  (COUNT(UNIQUE(b.Hash_Value)) / COUNT(b.Hash_Value)) * 100 u_Hash_Ratio
  FROM Dba_Users a, V$sqlarea b
  WHERE a.User_Id = b.Parsing_User_Id
  GROUP BY a.Username;
  15、 cha kan zi dian ming zhong lv
  SELECT (SUM(Getmisses) / SUM(Gets)) Ratio
  FROM V$rowcache;
  16、 cha kan undo duan de shi yong qing kuang
  SELECT d.Segment_Name, Extents, Optsize, Shrinks, Aveshrink, Aveactive,
  d.Status
  FROM V$rollname n, V$rollstat s, Dba_Rollback_Segs d
  WHERE d.Segment_Id = n.Usn(+)
  AND d.Segment_Id = s.Usn(+);
  
  17、 qiu gui dang ri zhi de qie huan pin lv ( sheng chan xi tong ke neng shi jian hui hen chang )
  SELECT Start_Recid, Start_Time, End_Recid, End_Time, Minutes
  FROM (SELECT Test.*, Rownum AS Rn
  FROM (SELECT b.Recid Start_Recid,
  To_Char(b.First_Time, 'yyyy-mm-dd hh24:mi:ss') Start_Time,
  a.Recid End_Recid,
  To_Char(a.First_Time, 'yyyy-mm-dd hh24:mi:ss') End_Time,
  Round(((a.First_Time - b.First_Time) * 24) * 60, 2) Minutes
  FROM V$log_History a, V$log_History b
  WHERE a.Recid = b.Recid + 1
  AND b.First_Time > SYSDATE - 1
  ORDER BY a.First_Time DESC) Test) y
  WHERE y.Rn < 30
  18、 qiu hui gun duan zheng zai chu li de shi wu
  SELECT a.NAME, b.Xacts, c.Sid, c.Serial#, d.Sql_Text
  FROM V$rollname a, V$rollstat b, V$session c, V$sqltext d, V$transaction e
  WHERE a.Usn = b.Usn
  AND b.Usn = e.Xidusn
  AND c.Taddr = e.Addr
  AND c.Sql_Address = d.Address
  AND c.Sql_Hash_Value = d.Hash_Value
  ORDER BY a.NAME, c.Sid, d.Piece;
  19、 qiu mou ge shi wu de chong zuo xin xi (bytes)
  SELECT s.NAME, m.VALUE
  FROM V$mystat m, V$statname s
  WHERE m.Statistic# = s.Statistic#
  AND s.NAME LIKE '%redo size%';
  20、 qiu cache zhong huan cun chao guo qi 5% de dui xiang
  SELECT o.Owner, o.Object_Type, o.Object_Name, COUNT(b.Objd)
  FROM V$bh b, Dba_Objects o
  WHERE b.Objd = o.Object_Id
  GROUP BY o.Owner, o.Object_Type, o.Object_Name
  HAVING COUNT(b.Objd) > (SELECT To_Number(VALUE) * 0.05
  FROM V$parameter
  WHERE NAME = 'db_block_buffers');
  21、 qiu buffer cache zhong de kuai xin xi
  SELECT o.Object_Type, Substr(o.Object_Name, 1, 10) Objname, b.Objd, b.Status,
  COUNT(b.Objd)
  FROM V$bh b, Dba_Objects o
  WHERE b.Objd = o.Data_Object_Id
  AND o.Owner = '&owner'
  GROUP BY o.Object_Type, o.Object_Name, b.Objd, b.Status;
  22、 qiu ri zhi wen jian de kong jian shi yong
  SELECT Le.Leseq Current_Log_Sequence#,
  100 * Cp.Cpodr_Bno / Le.Lesiz Percentage_Full
  FROM X$kcccp Cp, X$kccle Le
  WHERE Le.Leseq = Cp.Cpodr_Seq;
  23、 qiu deng dai zhong de dui xiang
  SELECT /*+rule */
  s.Sid, s.Username, w.Event, o.Owner, o.Segment_Name, o.Segment_Type,
  o.Partition_Name, w.Seconds_In_Wait Seconds, w.State
  FROM V$session_Wait w, V$session s, Dba_Extents o
  WHERE w.Event IN (SELECT NAME
  FROM V$event_Name
  WHERE Parameter1 = 'file#'
  AND Parameter2 = 'block#'
  AND NAME NOT LIKE 'control%')
  AND o.Owner <> 'sys'
  AND w.Sid = s.Sid
  AND w.P1 = o.File_Id
  AND w.P2 >= o.Block_Id
  AND w.P2 < o.Block_Id + o.Blocks
  24、 qiu dang qian shi wu de chong zuo chi cun
  SELECT V$statname.NAME,VALUE
  FROM V$mystat, V$statname
  WHERE V$mystat.Statistic# = V$statname.Statistic#
  AND V$statname.NAME = 'redo size';
  25、 huan xing smon qu qing chu lin shi duan
  column pid new_value Smon
  set termout off
  SELECT p.Pid
  FROM Sys.v_$bgprocess b, Sys.v_$process p
  WHERE b.NAME = 'SMON'
  AND p.Addr = b.Paddr;
  /
  SET Termout ON Oradebug Wakeup &Smon Undefine Smon
  26、 qiu hui tui lv
  SELECT b.VALUE / (a.VALUE + b.VALUE), a.VALUE, b.VALUE
  FROM V$sysstat a, V$sysstat b
  WHERE a.Statistic# = 4
  AND b.Statistic# = 5;
  27、 qiu free memory
  SELECT *
  FROM V$sgastat
  WHERE NAME = 'free memory';
  SELECT a.NAME, SUM(b.VALUE)
  FROM V$statname a, V$sesstat b
  WHERE a.Statistic# = b.Statistic#
  GROUP BY a.NAME;
  cha kan yi xia shui zai shi yong na ge ke yi de hui gun duan , huo zhe cha kan yi xia mou ge ke yi de yong hu zai shi yong hui gun duan ,
  zhao chu ling hui gun duan bu duan zeng chang de shi wu , zai kan kan ru he chu li ta , shi fou ke yi jiang ta commit, zai bu xing
  jiu kan kan neng fou kill ta , deng deng , cha kan dang qian zheng zai shi yong de hui gun duan de yong hu xin xi he hui gun duan xin xi :
  set linesize 121
  SELECT r.NAME "ROLLBACK SEGMENT NAME ", l.Sid "ORACLE PID",
  p.Spid "SYSTEM PID ", s.Username "ORACLE USERNAME"
  FROM V$lock l, V$process p, V$rollname r, V$session s
  WHERE l.Sid = p.Pid(+)
  AND s.Sid = l.Sid
  AND Trunc(l.Id1(+) / 65536) = r.Usn
  AND l.TYPE(+) = 'TX'
  AND l.Lmode(+) = 6
  ORDER BY r.NAME;
  28、 cha kan yong hu de hui gun duan de xin xi
  SELECT s.Username, Rn.NAME
  FROM V$session s, V$transaction t, V$rollstat r, V$rollname Rn
  WHERE s.Saddr = t.Ses_Addr
  AND t.Xidusn = r.Usn
  AND r.Usn = Rn.Usn
  29、 cha kan nei cun zhong cun de shi yong
  SELECT Decode(Greatest(CLASS, 10),
  10,
  Decode(CLASS, 1, 'Data', 2, 'Sort', 4, 'Header', To_Char(CLASS)), 'Rollback') "Class",
  SUM(Decode(Bitand(Flag, 1), 1, 0, 1)) "Not Dirty",
  SUM(Decode(Bitand(Flag, 1), 1, 1, 0)) "Dirty",
  SUM(Dirty_Queue) "On Dirty", COUNT(*) "Total"
  FROM X$bh
  GROUP BY Decode(Greatest(CLASS, 10),
  10,
  Decode(CLASS, 1, 'Data', 2, 'Sort', 4, 'Header', To_Char(CLASS)), 'Rollback');【原文】【汉音对照
 
 
 
 
 
 
 
 
日版宠物情人插曲《Winding Road》歌词

日版宠物情人2017的插曲,很带节奏感,日语的,女生唱的。 最后听见是在第8集的时候女主手割伤了,然后男主用嘴帮她吸了一下,插曲就出来了。 歌手:Def...

兄弟共妻,我成了他们夜里的美食

老钟家的两个儿子很特别,就是跟其他的人不太一样,魔一般的执着。兄弟俩都到了要结婚的年龄了,不管自家老爹怎么磨破嘴皮子,兄弟俩说不娶就不娶,老父母为兄弟两操碎了心...

如何磨出破洞牛仔裤?牛仔裤怎么剪破洞?

把牛仔裤磨出有线的破洞 1、具体工具就是磨脚石,下面垫一个硬物,然后用磨脚石一直磨一直磨,到把那块磨薄了,用手撕开就好了。出来的洞啊很自然的。需要猫须的话调几...

我就是扫描下图得到了敬业福和爱国福

先来看下敬业福和爱国福 今年春节,支付宝再次推出了“五福红包”活动,表示要“把欠大家的敬业福都还给大家”。 今天该活动正式启动,和去年一样,需要收集“五福”...

冰箱异味产生的原因和臭味去除的方法

有时候我们打开冰箱就会闻到一股异味,冰箱里的这种异味是因为一些物质发出的气味的混合体,闻起来让人恶心。 产生这些异味的主要原因有以下几点。 1、很多人有这种习...

 
 
xing neng xiang guan nei rong 1、 bu zhuo yun xing hen jiu de SQL column username format a12 column opname format a16 column progress format a8 SELECT Username, Sid, Opname, Round(Sofar * 100 / Totalwork, 0) || '%' AS Progress, Time_Remaining, Sql_Text FROM V$session_Longops, V$sql WHERE Time_Remaining <> 0 AND Sql_Address = Address AND Sql_Hash_Value = Hash_Value; 2、 qiu DISK READ jiao duo de SQL SELECT St.Sql_Text FROM V$sql s, V$sqltext St WHERE s.Address = St.Address AND s.Hash_Value = St.Hash_Value AND s.Disk_Reads > 300; 3、 qiu DISK SORT yan chong de SQL SELECT Sess.Username, SQL.Sql_Text, Sort1.Blocks FROM V$session Sess, V$sqlarea SQL, V$sort_Usage Sort1 WHERE Sess.Serial# = Sort1.Session_Num AND Sort1.Sqladdr = SQL.Address AND Sort1.Sqlhash = SQL.Hash_Value AND Sort1.Blocks > 200; 4、 jian kong suo yin shi fou shi yong alter index &index_name monitoring usage; alter index &index_name nomonitoring usage; select * from v$object_usage where index_name = &index_name; 5、 qiu shu ju wen jian de I/O fen bu SELECT Df.NAME, Phyrds, Phywrts, Phyblkrd, Phyblkwrt, Singleblkrds, Readtim, Writetim FROM V$filestat Fs, V$dbfile Df WHERE Fs.File# = Df.File# ORDER BY Df.NAME; 6、 cha kan huan mei ti jiao de shi wu select * from v$locked_object; select * from v$transaction; 7、 hui gun duan cha kan SELECT Rownum, Sys.Dba_Rollback_Segs.Segment_Name NAME, V$rollstat.Extents Extents, V$rollstat.Rssize Size_In_Bytes, V$rollstat.Xacts Xacts, V$rollstat.Gets Gets, V$rollstat.Waits Waits, V$rollstat.Writes Writes, Sys.Dba_Rollback_Segs.Status Status FROM V$rollstat, Sys.Dba_Rollback_Segs, V$rollname WHERE V$rollname.NAME(+) = Sys.Dba_Rollback_Segs.Segment_Name AND V$rollstat.Usn(+) = V$rollname.Usn ORDER BY Rownum 8、 cha kan xi tong qing qiu qing kuang SELECT Decode(NAME, 'summed dirty write queue length', VALUE) / Decode(NAME, 'write requests', VALUE) "Write Request Length" FROM V$sysstat WHERE NAME IN ('summed dirty queue length', 'write requests') AND VALUE > 0; 9、 ji suan data buffer ming zhong lv SELECT a.VALUE + b.VALUE "logical_reads", c.VALUE "phys_reads", Round(100 * ((a.VALUE + b.VALUE) - c.VALUE) / (a.VALUE + b.VALUE)) "BUFFER HIT RATIO" FROM V$sysstat a, V$sysstat b, V$sysstat c WHERE a.Statistic# = 40 AND b.Statistic# = 41 AND c.Statistic# = 42; SELECT NAME, (1 - (Physical_Reads / (Db_Block_Gets + Consistent_Gets))) * 100 h_Ratio FROM V$buffer_Pool_Statistics; 10、 cha kan nei cun shi yong qing kuang SELECT Least(MAX(b.VALUE) / (1024 * 1024), SUM(a.Bytes) / (1024 * 1024)) Shared_Pool_Used, MAX(b.VALUE) / (1024 * 1024) Shared_Pool_Size, Greatest(MAX(b.VALUE) / (1024 * 1024), SUM(a.Bytes) / (1024 * 1024)) - (SUM(a.Bytes) / (1024 * 1024)) Shared_Pool_Avail, ((SUM(a.Bytes) / (1024 * 1024)) / (MAX(b.VALUE) / (1024 * 1024))) * 100 Avail_Pool_Pct FROM V$sgastat a, V$parameter b WHERE (a.Pool = 'shared pool' AND a.NAME NOT IN ('free memory')) AND b.NAME = 'shared_pool_size'; 11、 cha kan yong hu shi yong nei cun qing kuang SELECT Username, SUM(Sharable_Mem), SUM(Persistent_Mem), SUM(Runtime_Mem) FROM Sys.v_$sqlarea a, Dba_Users b WHERE a.Parsing_User_Id = b.User_Id GROUP BY Username; 12、 cha kan dui xiang de huan cun qing kuang SELECT Owner, Namespace, TYPE, NAME, Sharable_Mem, Loads, Executions, Locks, Pins, Kept FROM V$db_Object_Cache WHERE TYPE NOT IN ('NOT LOADED', 'NON-EXISTENT', 'VIEW', 'TABLE', 'SEQUENCE') AND Executions > 0 AND Loads > 1 AND Kept = 'NO' ORDER BY Owner, Namespace, TYPE, Executions DESC; SELECT TYPE, COUNT(*) FROM V$db_Object_Cache GROUP BY TYPE; 13、 cha kan ku huan cun ming zhong lv SELECT Namespace, Gets, Gethitratio * 100 Gethitratio, Pins, Pinhitratio * 100 Pinhitratio, Reloads, Invalidations FROM V$librarycache 14、 cha kan mou xie yong hu de hash SELECT a.Username, COUNT(b.Hash_Value) Total_Hash, COUNT(b.Hash_Value) - COUNT(UNIQUE(b.Hash_Value)) Same_Hash, (COUNT(UNIQUE(b.Hash_Value)) / COUNT(b.Hash_Value)) * 100 u_Hash_Ratio FROM Dba_Users a, V$sqlarea b WHERE a.User_Id = b.Parsing_User_Id GROUP BY a.Username; 15、 cha kan zi dian ming zhong lv SELECT (SUM(Getmisses) / SUM(Gets)) Ratio FROM V$rowcache; 16、 cha kan undo duan de shi yong qing kuang SELECT d.Segment_Name, Extents, Optsize, Shrinks, Aveshrink, Aveactive, d.Status FROM V$rollname n, V$rollstat s, Dba_Rollback_Segs d WHERE d.Segment_Id = n.Usn(+) AND d.Segment_Id = s.Usn(+); 17、 qiu gui dang ri zhi de qie huan pin lv ( sheng chan xi tong ke neng shi jian hui hen chang ) SELECT Start_Recid, Start_Time, End_Recid, End_Time, Minutes FROM (SELECT Test.*, Rownum AS Rn FROM (SELECT b.Recid Start_Recid, To_Char(b.First_Time, 'yyyy-mm-dd hh24:mi:ss') Start_Time, a.Recid End_Recid, To_Char(a.First_Time, 'yyyy-mm-dd hh24:mi:ss') End_Time, Round(((a.First_Time - b.First_Time) * 24) * 60, 2) Minutes FROM V$log_History a, V$log_History b WHERE a.Recid = b.Recid + 1 AND b.First_Time > SYSDATE - 1 ORDER BY a.First_Time DESC) Test) y WHERE y.Rn < 30 18、 qiu hui gun duan zheng zai chu li de shi wu SELECT a.NAME, b.Xacts, c.Sid, c.Serial#, d.Sql_Text FROM V$rollname a, V$rollstat b, V$session c, V$sqltext d, V$transaction e WHERE a.Usn = b.Usn AND b.Usn = e.Xidusn AND c.Taddr = e.Addr AND c.Sql_Address = d.Address AND c.Sql_Hash_Value = d.Hash_Value ORDER BY a.NAME, c.Sid, d.Piece; 19、 qiu mou ge shi wu de chong zuo xin xi (bytes) SELECT s.NAME, m.VALUE FROM V$mystat m, V$statname s WHERE m.Statistic# = s.Statistic# AND s.NAME LIKE '%redo size%'; 20、 qiu cache zhong huan cun chao guo qi 5% de dui xiang SELECT o.Owner, o.Object_Type, o.Object_Name, COUNT(b.Objd) FROM V$bh b, Dba_Objects o WHERE b.Objd = o.Object_Id GROUP BY o.Owner, o.Object_Type, o.Object_Name HAVING COUNT(b.Objd) > (SELECT To_Number(VALUE) * 0.05 FROM V$parameter WHERE NAME = 'db_block_buffers'); 21、 qiu buffer cache zhong de kuai xin xi SELECT o.Object_Type, Substr(o.Object_Name, 1, 10) Objname, b.Objd, b.Status, COUNT(b.Objd) FROM V$bh b, Dba_Objects o WHERE b.Objd = o.Data_Object_Id AND o.Owner = '&owner' GROUP BY o.Object_Type, o.Object_Name, b.Objd, b.Status; 22、 qiu ri zhi wen jian de kong jian shi yong SELECT Le.Leseq Current_Log_Sequence#, 100 * Cp.Cpodr_Bno / Le.Lesiz Percentage_Full FROM X$kcccp Cp, X$kccle Le WHERE Le.Leseq = Cp.Cpodr_Seq; 23、 qiu deng dai zhong de dui xiang SELECT /*+rule */ s.Sid, s.Username, w.Event, o.Owner, o.Segment_Name, o.Segment_Type, o.Partition_Name, w.Seconds_In_Wait Seconds, w.State FROM V$session_Wait w, V$session s, Dba_Extents o WHERE w.Event IN (SELECT NAME FROM V$event_Name WHERE Parameter1 = 'file#' AND Parameter2 = 'block#' AND NAME NOT LIKE 'control%') AND o.Owner <> 'sys' AND w.Sid = s.Sid AND w.P1 = o.File_Id AND w.P2 >= o.Block_Id AND w.P2 < o.Block_Id + o.Blocks 24、 qiu dang qian shi wu de chong zuo chi cun SELECT V$statname.NAME,VALUE FROM V$mystat, V$statname WHERE V$mystat.Statistic# = V$statname.Statistic# AND V$statname.NAME = 'redo size'; 25、 huan xing smon qu qing chu lin shi duan column pid new_value Smon set termout off SELECT p.Pid FROM Sys.v_$bgprocess b, Sys.v_$process p WHERE b.NAME = 'SMON' AND p.Addr = b.Paddr; / SET Termout ON Oradebug Wakeup &Smon Undefine Smon 26、 qiu hui tui lv SELECT b.VALUE / (a.VALUE + b.VALUE), a.VALUE, b.VALUE FROM V$sysstat a, V$sysstat b WHERE a.Statistic# = 4 AND b.Statistic# = 5; 27、 qiu free memory SELECT * FROM V$sgastat WHERE NAME = 'free memory'; SELECT a.NAME, SUM(b.VALUE) FROM V$statname a, V$sesstat b WHERE a.Statistic# = b.Statistic# GROUP BY a.NAME; cha kan yi xia shui zai shi yong na ge ke yi de hui gun duan , huo zhe cha kan yi xia mou ge ke yi de yong hu zai shi yong hui gun duan , zhao chu ling hui gun duan bu duan zeng chang de shi wu , zai kan kan ru he chu li ta , shi fou ke yi jiang ta commit, zai bu xing jiu kan kan neng fou kill ta , deng deng , cha kan dang qian zheng zai shi yong de hui gun duan de yong hu xin xi he hui gun duan xin xi : set linesize 121 SELECT r.NAME "ROLLBACK SEGMENT NAME ", l.Sid "ORACLE PID", p.Spid "SYSTEM PID ", s.Username "ORACLE USERNAME" FROM V$lock l, V$process p, V$rollname r, V$session s WHERE l.Sid = p.Pid(+) AND s.Sid = l.Sid AND Trunc(l.Id1(+) / 65536) = r.Usn AND l.TYPE(+) = 'TX' AND l.Lmode(+) = 6 ORDER BY r.NAME; 28、 cha kan yong hu de hui gun duan de xin xi SELECT s.Username, Rn.NAME FROM V$session s, V$transaction t, V$rollstat r, V$rollname Rn WHERE s.Saddr = t.Ses_Addr AND t.Xidusn = r.Usn AND r.Usn = Rn.Usn 29、 cha kan nei cun zhong cun de shi yong SELECT Decode(Greatest(CLASS, 10), 10, Decode(CLASS, 1, 'Data', 2, 'Sort', 4, 'Header', To_Char(CLASS)), 'Rollback') "Class", SUM(Decode(Bitand(Flag, 1), 1, 0, 1)) "Not Dirty", SUM(Decode(Bitand(Flag, 1), 1, 1, 0)) "Dirty", SUM(Dirty_Queue) "On Dirty", COUNT(*) "Total" FROM X$bh GROUP BY Decode(Greatest(CLASS, 10), 10, Decode(CLASS, 1, 'Data', 2, 'Sort', 4, 'Header', To_Char(CLASS)), 'Rollback');
󰈣󰈤
  免责声明:本文仅代表作者个人观点,与王朝网络无关。王朝网络登载此文出于传递更多信息之目的,并不意味着赞同其观点或证实其描述,其原创性以及文中陈述文字和内容未经本站证实,对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
时尚性感的燕子(3)
时尚性感的燕子(2)
纯美的女生生活写真(14)
纯美的女生生活写真(13)
来自束河[]
恰巧-巧家~~
高尔夫
行摄匆匆天子山
 
>>返回首页<<
 为你推荐
 
 
 转载本文
 UBB代码 HTML代码
复制到剪贴板...
 
 热帖排行
 
 
 
 
©2005- 王朝网络 版权所有