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

making a table available

All posts relating to Oracle database administration.

Moderator: Tim...

vivek_k47
Member
Posts: 27
Joined: Sun Aug 05, 2012 11:45 am

making a table available

Postby vivek_k47 » Thu Dec 13, 2012 2:31 pm

Hi,
Is it possible to make a table which is accessed frequently available in the SGA?Please explain.
Thanks
Vivek

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

Re: making a table available

Postby Tim... » Thu Dec 13, 2012 8:11 pm

Hi.

By default Oracle manages the SGA using a Least Recently Used (LRU) queue. This means that blocks that are used frequently will likely be in the buffer cache already. Oracle does this by default, so it is best to leave it alone to do what it does best.

Sometimes people attempt to cache tables, in the hope that it will improve performance, but all they do is fill the cache with objects they believe are important, leaving less room for oracle to cache what it feels is important. The product is in trying to improve performance they make things worse.

If you feel you know better than Oracle you can either use the CACHE option on the table:

http://docs.oracle.com/cd/B28359_01/ser ... m#i2215507

Or you can look at using query caching, that can be very useful to improve performance of some types of SQL.

http://www.oracle-base.com/articles/11g ... -11gr1.php

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 5 guests