Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
Cache table in Buffer Pool
This is a discussion on Cache table in Buffer Pool within the Oracle forums, part of the Databases category; Suppose a table occupies 1 GB physical disk space. If I want to cache the same table in Buffer Pool, Will it occupy the same 1 GB space or less. ...
|
|||||||
| Oracle Oracle 9i & Oracle 10g Knowledge Base Learn and Share Oracle Technology related articles, white papers, tutorials / study materials, example codes, FAQ's, Tips and Tricks. |
 |
| LinkBack | Thread Tools | Display Modes |
09-03-2007
|
|||
|
|||
|
Cache table in Buffer Pool
Suppose a table occupies 1 GB physical disk space. If I want to cache the same table in Buffer Pool, Will it occupy the same 1 GB space or less. Because we can have very large disk space upto 400GB, but RAM space is limited only upto 6 GB.
Question asked by visitor RakeshSayini 
|
| Sponsored Links |
|
09-04-2007
|
|||
|
|||
|
Re: Cache table in Buffer Pool
Well -getting entire table to RAM is not a wise Idea unless the tables is small and accessed too frequently just to read. If the table undergoes frequent updation, then the cache needs to be re-built.
So- my recommendation increase the cache size for the server - let it do the caching for you - so do not try caching the entire table. -Kalayama
__________________
[COLOR="Blue"][SIZE="2"]"If you are not living on the edge of your life, you are wasting space"[/SIZE][/COLOR] Someone says "Impossible is nothing". The man next him says "Let me see you licking your elbow tip!"
|
|
|
«
Access sdo_elem_info and sdo_ordinates from sdo_geometry
|
calculating the sum of a field in a query with join
»
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How will you expand the swimming pool 4 times more | mallesh_thavva | Brainteasers | 12 | 04-19-2008 01:51 PM |
| Is PERSISTENT cache - STATIC/DYNAMIC? | Geek_Guest | Data Warehousing | 1 | 08-24-2007 09:18 AM |
| How to Clear Input Buffer | blenda | C and C++ | 1 | 11-12-2006 03:08 PM |
| Memory Layers In Shared Pool | Allan Paul | Oracle | 3 | 10-13-2006 07:01 PM |
| Explain about Assemblies, native assemblies, and the Global Assembly Cache | GeekAdmin | VB.NET | 0 | 05-17-2006 11:59 PM |
All times are GMT -4. The time now is 04:29 PM.
