TM contention and INSERT /*+ APPEND */ parallel sessions?

Today I did a reorganization on 1,7TB tablespace, finally reduced to 620GB. (I have to have 10% free in a tablespace to not cause alerts). There were some tables arround 30GB with smaller LOBs and two tables with one 1TB LOB and 500GB LOB. To know it will work a testcase on the standby database…

Little Statspack Performance monitoring SQL

Well, you know Average Active Sessions, if you don’t have AWR than this is a way how to get some information, use Statspack. The query displays how many users were working(active) in a second. select t.snap_time,round(t.dbtime/t.elapsed,2) as “AvgActiveSessions” from ( select snap_time, stat_name, nvl(round((l.value-lag(l.value) over (order by l.snap_id))/1000000,2),0) as dbtime, nvl((s.snap_time-lag(s.snap_time) over (order by s.snap_id asc))*24*60*60,0)…