469,643 Members | 1,236 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,643 developers. It's quick & easy.

no performance when creating or extending a tablespace

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
1 1565

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.

Similar topics

14 posts views Thread by Sean C. | last post: by
1 post views Thread by Evan Smith | last post: by
3 posts views Thread by robert | last post: by
3 posts views Thread by jane | last post: by
46 posts views Thread by dunleav1 | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.