RE: [Sydney-Oracle] I need you help. Odd performance difference comparing 4k data block size and 8k databases

From: Nuno Pinto do Souto
Sent on: Wednesday, May 26, 2010 2:40 PM
Bugger, I don't have access to any RHLinux system at the moment...
A couple of things to check, from a vague memory:
1- What file system block size for each db
2- Are datafiles for all dbs on same file system
3- What is the value of filesystemio_options for each db.
4- In sqlplus, what does this produce on each db:
show parameter priority
5- Check and compare SGA memory-related sizes for each db.

Cheers
Nuno Pinto do Souto
DBA Team, Australia/NZ

-----Original Message-----
From: [address removed]
[mailto:[address removed]] On Behalf Of Yury Velikanov
Sent: Wednesday, 26 May 2010 11:18 AM
To: [address removed]
Subject: [Sydney-Oracle] I need you help. Odd performance difference
comparing 4k data block size and 8k databases

Hello everyone,

I need any idea that may came you your head to find out the reason for
the following problem. Please do not hesitate to through any
suggestions and I will  check those for you.
This is a super-duper new Dell server, 11GR2, Red Hat Enterprise Linux
Server release 5.4.

______________________________________________________
    CONFIDENTIALITY NOTICE    
This electronic mail message, including any and/or all attachments, is for the sole use of the intended recipient(s), and may contain confidential and/or privileged information, pertaining to business conducted under the direction and supervision of the sending organization. All electronic mail messages, which may have been established as expressed views and/or opinions (stated either within the electronic mail message or any of its attachments), are left to the sole responsibility of that of the sender, and are not necessarily attributed to the sending organization. Unauthorized interception, review, use, disclosure or distribution of any such information contained within this electronic mail message and/or its attachment(s), is (are) strictly prohibited. If you are not the intended recipient, please contact the sender by replying to this electronic mail message, along with the destruction all copies of the original electronic mail message (along with any attachments).
______________________________________________________

The Pythian Group

Database services & consulting in Australia. Meetup organizer.

Offer a perk for our members and get exposure.

Offer a perk →
Other nearby
Meetups
Why these groups?
x

The Meetup Groups shown here are topically similar to Sydney Oracle Meetup.

Groups are more likely to be displayed here if they:

  • have a Meetup scheduled
  • have a high rating
  • have a group photo
  • are "public" and not "private"
  • have shown they are likely to stick around (older than 30 days)
Find more Meetup Groups
near Sydney

Log in

  • Not registered with us yet?
or

Log in to Meetup with your Facebook account.

Sign up

or

Join this Meetup Group even quicker with your Facebook account.

By clicking the "Sign up using Facebook" or "Sign up" buttons above, you agree to Meetup's Terms of Service