Home » RDBMS Server » Server Administration » buffer pool selection
buffer pool selection [message #251543] Sat, 14 July 2007 09:52 Go to next message
vijaychauhan
Messages: 106
Registered: December 2005
Senior Member
I am using oracle 9i with 9.2.0.8, have a table with about 141 mb size and db_cache_size of 16 mb, the table contains lots of duplicate data, when I, give the query select * from table_name it only gives distint rows, then I, created another table of about .4 mb and it again gives distinct records. whereas for small table it gives all duplicate values, can someone pleas explain how this works.
Thank you.

Report message to a moderator

Re: buffer pool selection [message #251544 is a reply to message #251543] Sat, 14 July 2007 09:59 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>can someone pleas explain how this works.
How what works?
We are not behind you watching what you did.
We only know what you posted & you've provided no useful details!
I have NO clue what the TITLE has to do with the content of the post.

[Updated on: Sat, 14 July 2007 10:01] by Moderator

Report message to a moderator

Re: buffer pool selection [message #251545 is a reply to message #251543] Sat, 14 July 2007 10:02 Go to previous messageGo to next message
vijaychauhan
Messages: 106
Registered: December 2005
Senior Member
I meant was when I, am using very large table it does not show duplicate rows in output, only the distinct values are shown, where as with small tale all the records are shown.

Report message to a moderator

Re: buffer pool selection [message #251546 is a reply to message #251543] Sat, 14 July 2007 10:06 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Post the SQL used to load the small table.
I can only conclude the small table was "loaded" with the same record multiple times.

Report message to a moderator

Re: buffer pool selection [message #251547 is a reply to message #251543] Sat, 14 July 2007 10:17 Go to previous messageGo to next message
vijaychauhan
Messages: 106
Registered: December 2005
Senior Member
for very large table
select * from qwert;
The table has 5116 rows and the size is 0.4 mb.
for small table
select * from empd;
the table has 28 rows.

Report message to a moderator

Re: buffer pool selection [message #251549 is a reply to message #251543] Sat, 14 July 2007 10:22 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Your questions seems to involve the contents of a couple of tables.
Posting the row counts of the tables is as useful/useless as posting the outside air temperature at your location.

Since you don't want to answer my question "Post the SQL used to load the small table." & I have no useful information to proceed,
You're On Your Own (YOYO)!

You might get a more meaningful response if you read & follow the posting guidelines in the #1 STICKY post at the top of this forum,
but I am not going to hold my breath waiting for that to happen.

[Updated on: Sat, 14 July 2007 11:41] by Moderator

Report message to a moderator

Previous Topic: 10GR2 creation is blocked on last version serveur 2003 R2
Next Topic: Using dbstart, getting error ORA-01031: insufficient privileges
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 09:22:12 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.