By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,502 Members | 1,878 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,502 IT Pros & Developers. It's quick & easy.

no performance when creating or extending a tablespace

P: n/a
Hi,

I`m a unix system administrator and they asked me to investigate a
performance problem. When de DBA extends or creats a tablespace by 2Gb then
we cannot connect to the database we already did increase the aio setting on
the OS AIX 4.3.11 but that did not resolve the problem. Have anyone any idea
what is te matter.

Koos
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

Hello Koos,

For a start, please ask DBA to generate statspack (or bstat/estat) report
during the event and post it to the group.

From the unix side, check what is vmstat showing on r/b columns.

Regards,

Support
DBA Infopower LLC
http://www.dbainfopower.com
"koos" <ks****@kabelfoon.nl> wrote in message
news:40**********************@news.kabelfoon.nl...
Hi,

I`m a unix system administrator and they asked me to investigate a
performance problem. When de DBA extends or creats a tablespace by 2Gb then we cannot connect to the database we already did increase the aio setting on the OS AIX 4.3.11 but that did not resolve the problem. Have anyone any idea what is te matter.

Koos

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.