V$SEGSTAT or GV$SEGSTAT Views (Doc ID 1532624.1) typo and X$KSOLSFTS ?
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#;