This forum is currently locked. You can't register or post questions at this time. (read more)

Inline View takes which memory

All posts relating to Oracle database administration.

Moderator: Tim...

Guest

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

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

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


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 6 guests

cron