Empty sql_id and other columns in v$session for jobs - 10.2.0.3
06 Jul
Posted by: gato in: Administration, DBA, Oracle
10.2.0.3 has a nasty bug, where one is not able to see what SQL is job actually executing, the following fix will resolve that partially. For parallel slaves the relevant v$session columns are still going to be empty.
5928612 SQL ADDRESS COLUMN IN V$SESSION VIEW FOR JOB IS ZERO
This might be resolved completely in 10.2.0.4, anyone?
Bookmark to:
Leave a reply