db_block in SGA
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: db_block in SGA

  1. #1
    Join Date
    Jan 2001
    Posts
    4
    Just a clarification,
    The data block in a database contains rows.Suppose i am selecting a singe row from the data block, will the entire block be read into the data block of databuffers in SGA (i.e all the rows contained in the data block of database?

    Pl. let me know,
    Thanks in advance.

  2. #2
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    Yes,if u select a single row from a table Oracle will load the entire block into the database buffer cache in the SGA.U dont know in which datablock Oracle will store the data but for performance point of view it is helpful.In case of any doubts please be free to ask to me at rohitsn@altavista.com


    Regards,
    Rohit Nirkhe,Oracle DBA,OCP 8i
    rohitsn@altavista.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width