Shulou(Shulou.com)05/31 Report--

This article will explain in detail the example analysis of the Oracle query script. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

-- query rollback segment information

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

Before 10g, get the target trace file with the following statement

Col TRACE_FILE_NAME for a100

Set linesize 200

Select d.value | |'/'| | lower (rtrim (i.instance, chr (0) | |'_ ora_' | | p.spid | | '.trc' trace_file_name

From (select p.spid

From v$mystat m, v$session s, v$process p

Where m.statistic# = 1

And s.sid = m.sid

And p.addr = s.paddr) p

(select t.instance

From v$thread t, v$parameter v

Where v.name = 'thread'

And (v.value = 0 or t.thread# = to_number (v.value)) I

(select value from v$parameter where name = 'user_dump_dest') d

-- query hidden parameters in mount

Col name for a50

Col value for a20

Col describ for a100

Set linesize 200

SELECT x.ksppinm NAME, y.ksppstvl VALUE, x.ksppdesc describ

FROM SYS.x$ksppi x, SYS.x$ksppcv y

WHERE x.inst_id = USERENV ('Instance')

AND y.inst_id = USERENV ('Instance')

AND x.indx = y.indx

AND upper (x.ksppinm) like'% _ AUTOTUNE%'

This is the end of this article on "sample Analysis of Oracle query script". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it out for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.