Thanks for your service.
1.) Could you explain which memory ( tablespace ) oracle uses when it has to serve for a query with multiple inline views?
2.) How do i monitor ths space usage of oracle (memory used when dealing with inline view) when it is serving for long running query with inline view?
Thanks in advance,
You seem to be a little confused. You seem to be switching between references to memory and tablespaces. These are not the same thing. A tablespace holds physical objects such as tables and indexes etc. Views are stored queries in the dictionary. Inline views are generated at runtime as the query is processed. Neither type of view has anythign to do with tablespaces.
If you are concerned about the memeory usage of a query I suggest you check out the v$sesstat view. This provides all the statistical information Oracle has related to a session. The names of the statistics can be displayed in a more readable form using the v$statname view.
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: https://oracle-base.com
My blog: https://oracle-base.com/blog
Who is online
Users browsing this forum: No registered users and 2 guests