Re: Siebel with Oracle DB

In http://www.quest.com/newsletter/v2i5/index.asp?body=block.html you can read:

>> ...Handling Large Rows
 

>>There was a significant decrease in performance when rows became larger
than a block.
...
...."Here are some of the observations we made:

• Batch jobs took a long time to complete
• The log files generated by the job were eight to ten times larger than the data that was loaded
• The online application that maintained the "private" columns was extremely slow compared to similar applications
• Both the job and the online application generated many more disk reads than rows being accessed

As you can guess, there was row spanning in the table. Row spanning is a type of row chaining that occurs when the row is larger then a block. ...."

 About the Author

Eyal Aronoff is Vice President of Technology and Engineering at Quest Software. He is the inventor of SQLab database monitoring, administration, and tuning tools. He is also a certified Oracle DBA and the co-author of the Advanced ORACLE Tuning and Administration book published by Oracle Press. Eyal can be contacted via e-mail: earonoff_at_quest.com

In Conclusion:
I'am sure you are rigth and I'm must be wrong....

Keep on with this good performance...

J Meirim

Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam> escreveu na mensagem news:399a6c28.5416192_at_news-server...
> On Wed, 16 Aug 2000 01:37:01 +0100, Jorge Meirim
> <transparente_at_mail.telepac.pt> wrote:
>
> >Does any one know about a place where one can find more information
> >about
> >Siebel working with Oracle ? (tips, tunning, implementations ...)
>
> No.
>
> >
> >For example I would like to know what is the block size that most of the
> >DBA's are working with.
> >The recommended by Siebel is 2K but there are many tables with more than
> >5K
> >total length.
>
> Jorge, the database block size does not necessarily have to match the
> table size! The database block size is simply the equivalent in disk
> of page size in memory: the unit size of transfer between program and
> data storage. Nothing more, nothing less.
>
> If you need more help, give me a ping via e-mail and we can talk about
> it.
>
> Cheers
> Nuno Souto
> nsouto_at_nsw.bigpond.net.au.nospam
> http://www.users.bigpond.net.au/the_Den/index.html
Received on Wed Aug 16 2000 - 18:26:31 CDT