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

Home -> Community -> Usenet -> c.d.o.server -> Re: Q: Perfromance problems on AIX

Re: Q: Perfromance problems on AIX

From: Waldemar Schlonsok <Waldemar.Schlonsok_at_quantum.de>
Date: Fri, 14 Jan 2000 14:01:06 +0100
Message-ID: <387F1E12.400042BD@quantum.de>


Hallo,

here the results of ulimit:

ULIMIT                Production    Test

time(seconds)         unlimited    unlimited
file(blocks)             unlimited    unlimited
data(kbytes)           256000     131072
stack(kbytes)         32768        32768
memory(kbytes)     32768        32768
coredump(blocks)  100000      2048

nofiles(descriptors) unlimited unlimited

cwalkersddpc_at_my-deja.com schrieb:

> Check the ULIMIT for the UNIX user that is running the UNIX
> process that is running statement.
> This will usually be similiar to this:
>
> oracle 13252 1 0 06:41:38 ? 0:14 oraclesupport (LOCAL=NO)
>
> In this case the unix user Oracle is running the process.
> Log in as that user and run this statement at the UNIX prompt:
> ulimit -a
>
> The output will be similiar to the following:
> time(seconds) unlimited
> file(blocks) 2097151
> data(kbytes) 131072
> stack(kbytes) 32768
> memory(kbytes) 32768
> coredump(blocks) 2048
> nofiles(descriptors) unlimited
> Check the output on both machines and compare them.
> If they are different make them the same and try again.
>

Any suggestions?

Yours sincerely,
Waldemar Schlonsok Received on Fri Jan 14 2000 - 07:01:06 CST

Original text of this message

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