Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > Performance & Tuning

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 14th September 2001, 21:28
naabi0 naabi0 is offline
Member
 
Join Date: Sep 2001
Location: Alabama
Posts: 81
naabi0 is on a distinguished road
Question Oracle 8i Block Size

Hello,

I recently installed Baan 4c4 on a new Dec/Compaq/HP ES40 Alpha box. We are running Tru64 Unix 5.1 and Oracle 8i 8.1.7.
After almost 1 month of installation time, I finally got Baan and 8 service packs installed. I installed all of the localizations except the language specific ones and I did not install the Aerospace and Defense localization. It was a long process. The most confusing part was getting the porting set to work. I put on 6.1c.06.02 and I think I still have problems because when I try to run MRP using Table Boosters I lose my host mode connection.

At this time, my main question concerns block sizes.

On our old Alpha box, we are running Tru64 Unix 4.0D, Oracle 7.3.4 and Baan 4c2. Our database was created with an 8k block size. We also do software raid 0+1 with 256k stripe sizes.

I set the new machine up to us a 16k block size in Oracle and more then doubled the size of the SGA. Also, it is hardware raid. The HSZ80 controllers were setup to read and write to cache with a 256 block chunk (I don't know what size a block is at this point, maybe 512 bytes) and the stripe sets have a 256k stripe size. I also decided to use Locally Managed Tablespaces and the redo logs are not residing on raid disks.

The new Alpha box is twice as fast as the old and has twice as much ram but seems to be slower in most situations using Baan. Is Oracle 8i just slower then Oracle 7 or did I go over board with the block sizes.

Thanks for any advice.
Reply With Quote
  #2  
Old 14th September 2001, 22:31
patvdv's Avatar
patvdv patvdv is offline
Board Master
 
Join Date: Aug 2001
Location: Belgium
Posts: 2,167
patvdv is on a distinguished road
Baan: n/a - DB: n/a - OS: AIX, HP-UX, Linux
It depends

With most of these questions, the answer is: it depends...

According to Oracle Support, Oracle8i *is* slower so this would be another case where added functionality has to be compensated by better hardware. With the new hardware setup you describe, I'd assume it should have improved your situation: faster CPU, more RAM, hardware RAID. I am not familiar with striping as I prefer a simple RAID 1 setup with a larger I/O cache.

Some questions you should ask:
  • How big is your I/O cache? Is it sufficient? What RAID level do you use now?
  • Can you extract performance statistics from your RAID controller? If so, what do they show?
  • What are your Oracle performance indicators like? hit ratio's?

I haven't used locally managed tablespaces myself but I wonder does it have any impact on how you calculate statistics? Do you generate statistics at all?

As to the 16K block size: here's some pointers:
  • small block sizes (4k-8k) tend to be better for OLTP systems than larger block sizes (16k-32k). OLTP is characterized by random writes and small, granuler data sets (like Baan)
  • bigger block sizes give better index performance
  • bigger block sizes can cause a waste on I/O if you don't use the full 16K of data when read into the buffer
  • bigger block sizes can cause more contention as more transactions can possibly run against 1 block.

Did you adjust your init.ora parameters when switching from 8K to 16K?
__________________
Regards,

Patrick Van der Veken - Admin & Founder - (c) 2001-2017 baanboard.com/baanforums.com
Reply With Quote
  #3  
Old 14th September 2001, 23:30
naabi0 naabi0 is offline
Member
 
Join Date: Sep 2001
Location: Alabama
Posts: 81
naabi0 is on a distinguished road
I did change the init.ora parameters accordingly and our cache size is 256M.

Do you now of any one using a 16K block size with Oracle.
Reply With Quote
  #4  
Old 14th September 2001, 23:36
patvdv's Avatar
patvdv patvdv is offline
Board Master
 
Join Date: Aug 2001
Location: Belgium
Posts: 2,167
patvdv is on a distinguished road
Baan: n/a - DB: n/a - OS: AIX, HP-UX, Linux
8K max

We use 8K max.
__________________
Regards,

Patrick Van der Veken - Admin & Founder - (c) 2001-2017 baanboard.com/baanforums.com
Reply With Quote
  #5  
Old 18th September 2001, 13:22
James James is offline
Retired Founder
 
Join Date: Aug 2001
Location: Bristol, UK
Posts: 158
James is on a distinguished road
Baan: Triton,Baan IV,ERP - DB: Oracle 7/8i/9i - OS: HPUX,Tru64,Linux
Idea

Hi,

A good idea would be to determine 'what' is exactly running slower, and by how much.

Access to Baan? Displaying data? Processing of sessions? Printing of reports?

What is the factor difference? 5% or 20%?

If you can pinpoint an area which is running slow then this area can be analysed. Unix processes, i/o, memory, cpu, disk stats can be anaysed/monitored - eventually a bottleneck will be found. Oracle stats for the sql statement being run can also be analysed.

Oracle8 is indeed slightly slower than Oracle7. And Oracle8 works in a different way that needs to be setup correctly depending upon the OS configuration. Certain settings need to be carefully tuned during the migration to Oracle8, namely the db writer proceses.

Judging by the upgrade in hardware, this should offset any minor performance reduction in Oracle8 and Baan should in fact perform better.

Also, for Oracle, I would stick to 8k block size when using Baan, unless your OS block size is greater than 8k.

Let us know if you need more info.
__________________
James Gittins
(c) 2002 Baanboard.com
Reply With Quote
Sponsored Links
  #6  
Old 18th September 2001, 22:14
naabi0 naabi0 is offline
Member
 
Join Date: Sep 2001
Location: Alabama
Posts: 81
naabi0 is on a distinguished road
How do you determine the OS block size? I thought it was 512 bytes. Our I/O write and read size is 256K.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to calculate row size for Oracle egarciad Operating Systems & Databases 6 18th December 2003 21:18
Paging size ??? learner Operating Systems & Databases 1 12th August 2003 20:44
Error installing B4c4 with Oracle 8.1.7 on NT syllepage Tools Administration & Installation 2 22nd July 2002 13:52


All times are GMT +2. The time now is 11:23.


©2001-2017 - Baanboard.com - Baanforums.com