Hi
I am running an update on Advance row compress table by selecting data from
another table on Unique Seq No. Runing Select from other table is very fast and
even running Select instead of update columns is very fast BUT WHEN update
comes, it is taking almost an hour to just update 5 mil Records. Does Compress
for OLTP be factor for so many single block phsuicall Read as I am monitoring
the trace and what it is doing is name='cell single block physical read'
ela=1511 celhas=12345555 diskhash=12345555 bytes=8192 obj#0
time=11111111name='cell single block physical read' ela=1511 celhas=12345555
diskhash=12345555 bytes=8192 obj#540334 time=11111111
So can see doing this against obj#0 and obj#540334
Any help is appreciated.
TIASanjay