This content has been marked as final. Show 7 replies
Oh no! This has come up again! I would suggest that you don't assume anything being faster/slower/whatever before reading this post from Jonathan and also, read all the links in that post.
You are leaving out so much, it is hard to make any comment.
Probably you enjoy posting mysteries?
A few items
- No platform information was included
- no file system information was included, no info about the disk block size
- Do you think the size of the table Oracle deals with is the number of blocks in dba_segments? In a full table scan the only thing that counts is the High Water Mark. Do you think all tables are equally big in terms of High Water Mark? Potentially you are comparing apples and pears
- As you don`t post table definitions, don´t post actual selects and don´t post explain plans: are you aware of the difference between variable length and fixed length semantics?
You really need to post much more detail, and get away from the fairy tale domain. Previous experiments have shown the net difference is zero.
Likely your test is biased or you subscribe to the Multiple Block size Myth.
Senior Oracle DBA
running select * from table_namevery misleading Test. You have not factored PacketSizes and SQLNet RoundTrips. A SELECT * causes Oracle to send all the rows and columns (ok, single column) to the client, with a default/specified ARRAYSIZE being used but subject to fragmentation into multiple packets (even if your sqlplus client process is on the same host as the database server process).
Hemant K Chitale
Really thankful for posting that *"Jonathan links"* - which was very informative. Let me save it into my library
Thanks sir and How the work is going on ORACLE 11g Release 2. Let me know when you come across to "Bangalore"
- Pavan Kumar N
11gr2 is good . I shall be at Banglore next week, you are at Banglore?
Yes sir, send across a mail to my mail id, my mobile number got changed. Next saturday I will leave to hyderabad and back on next coming monday to Bangalore. let me know prior information from your end, so that I can meet you.
- Pavan Kumar N
Oh, so you have joined fianlly Oracle Corp is it? Send me your email over OC.