no performance when creating or extending a tablespace

[koos]

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

[DBA Infopower Support]

Re: no performance when creating or extending a tablespace


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" <kstorm@kabelfo on.nlwrote in message
news:40228804$0 $3246$58c7af7e@ 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
>
>