Inline View takes which memory

All posts relating to Oracle database administration.

Moderator: Tim...

Inline View takes which memory

Postby Guest » Mon Nov 01, 2004 6:09 pm

Tim,

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,
Ram
Guest
 

RE:Inline View takes which memory

Postby Tim... » Mon Nov 01, 2004 6:09 pm

Hi.

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.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17966
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 2 guests

cron