cancel
Showing results for 
Search instead for 
Did you mean: 

BR Space taking long time to extent datafile

Former Member
0 Kudos

Hi All,

We have upgraded the oracle database from 10.2 to 11.2.0.3 and upgraded the DB successfully. We are facing the issue in production server that when extent the data file through BR tools it is taking long time( 30 to 40 minutes). But Development and Quality server data file extending very quickly. Production and Quality server database volume is 1.2 TB. Production server is in cluster environment. Only the problem is in production server table space extension taking long time checked and conformed in non peak hours. Kindly help me to solve this issue.

OS details below

kernel release                720

kernel make variant           720_REL

compiled on                   SunOS 5.9 Generic_122300-28 sun4u for sun_

compiled for                  64 BIT

compilation mode              Non-Unicode

compile time                  Apr  8 2013 20:45:57

update level                  0

patch number                  423

Source id                     0.423

---------------------

supported environment

---------------------

database (SAP, table SVERS)   700

                              710

                              701

                              702

                              711

                              720

                              730

operating system

SunOS 5.9

SunOS 5.10

Regards

Jose H.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi All,

I have solved the issue by myself. Issue is kernel files, replaced the Br*.exe files. After that issue was resolved.

Thanks you all for your support.

Regards

Jose H.

Answers (2)

Answers (2)

Former Member
0 Kudos

Hello,

we faced similar issue.

problem was due to filesystem being mounted with incorrect block size.

if there are any recent additions of sapdata FS, please check what is the block size they are installed with. This hugely impacts filesystem IO & hence makes us feel that BR operations got hung.

ideally the block size should be 8KB.

Best Regards

Sachin Bhatt

stefan_koehler
Active Contributor
0 Kudos

Hi Jose,

too less information.

  • What kind of tablespace do you use?
  • What is the wait event of the corresponding session?
  • What is the corresponding I/O throughput on OS level (iostat / zpool iostat)?
  • What are the mount options and the parameter value of filesystemio_options?

Regards

Stefan

former_member206552
Active Contributor
0 Kudos

Hi Stefan,

I agree with the filesystemio options as i had a problem like that where by the filesystem was mounted incorrectly and i had to change the filesystem option for a short term solution to get better preformance

Best Regards

Marius