Oracle X$ tables – Part 1 – Where do they get their data from?

(Tanel Poder) It’s long-time public knowledge that X$ fixed tables in Oracle are just “windows” into Oracle’s memory. So whenever you query an X$ table, the FIXED TABLE rowsource function in your SQL execution plan will just read some memory structure, parse its output and show you the results in ta

Read More - Register for Free Membership