Database Administration (MOSC)

MOSC Banner

V$SEGSTAT or GV$SEGSTAT Views (Doc ID 1532624.1) typo and X$KSOLSFTS ?

edited Sep 19, 2019 5:07AM in Database Administration (MOSC) 6 commentsAnswered

hI,

Doc ID, seems like a typo ?

11.2.0.4 RAC on Linux 6.7

Slow Performance When Querying V$SEGSTAT or GV$SEGSTAT Views (Doc ID 1532624.1)

1)

Anyone know why the query here doesn't match the columns below? is this a typo?

2)

what command was used to get to the second part for X$KSOLSFTS

text copy of query above

set linesize 1000select obj#,       nvl(sum(decode(statistic_name, 'physical reads', value, 0)),0) physical_reads,       nvl(sum(decode(statistic_name, 'physical read requests', value,0)),0)        physical_read_requests,       nvl(sum(decode(statistic_name,'physical read direct',value,0)),0)        physcial_reads_direct, sysdate run_timefrom v$segstatwhere statistic_name in ('physical reads', 'physical read requests', 'physical reads direct')and value > 0group by obj#;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center