Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Re: no performance when creating or extending a tablespace

Re: no performance when creating or extending a tablespace

From: DBA Infopower Support <support_at_dbainfopower.com>
Date: Thu, 5 Feb 2004 22:46:25 -0800
Message-ID: <w4qdnSfpSd5Jq77dRVn-tw@comcast.com>

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_at_kabelfoon.nl> wrote in message news:40228804$0$3246$58c7af7e_at_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
>
>
Received on Fri Feb 06 2004 - 00:46:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US