Re: AIX Oracle Slowness Issue

Hello,

On the original post:
"I am using CIO mounted filesystems for Oracle. Since I'm using CIO,
isn't tweaking the vmo values moot?"

there are no cronjobs that happen during that time nor do any cronjobs
fail. Also the DBA's have not done anything tweak wise.

I think it has something to do with giving "oracle" user "-1" values in
the /etc/security/limits file for pretty much everything. So 'rss' has
"-1" value so that means oracle user can essentially usurp all
available memory for it's own processes outside of the SGA scope.


Silver Mane wrote:
dawaves wrote:
Hello,

I'm coming across this odd issue where every so often (really
sporadic), my p5 510 running 1.9Ghz 1-way with 5GB of RAM on AIX 5.3
ML04 will run in a super slow state. It always happens on a weekday,
always between 9:15AM - 10:00AM, and the only fix seems to be a reboot.
I try to run commands during this state but the response is too long
for me to wait since this is a Production machine. I run my commands
from the console too, but still takes too long. I can ping the server,
but my oracle apps can't connect.

Feel free to follow the advice given by the other guys but also answer
the following questions:

1. Has anything changed on the system recently i.e. new fix installed?
2. Have the Oracle DBA's set any new or changed any jobs in cron that
run around that time?
3. Have you added any other cron or at jobs to run around that time?
4. Do any jobs run over the weekend that are running into Monday and
hanging i.e. backup jobs or scripts to monitor things such as backup?

Has this problem always happened or is it recent?

Thanks

.

Relevant Pages

  • Re: Informix beats Oracle
    ... case Oracle performs 20% slower than IDS on 80% more hardware. ... the available jobs. ... 80% of those skilled in hamburger administration get jobs at McDonald's and ...
    (comp.databases.informix)
  • Re: I cant schedule more than one jobs with Oracle Scheduler
    ... What do you mean by "Note execute immediate mandatory" as shown below? ... Is it possible at all to schedule more than 1 jobs with Oracle ...
    (comp.databases.oracle.server)
  • Re: Jobs do not run
    ... sessions we can see that CJQ0 is running but no Jxxx processes. ... the machine the jobs still being there may still not be committed. ... Follow Daniels advice and go to 9.2.0.8 or Oracle will drop the phone ... patch and hit this. ...
    (comp.databases.oracle.server)
  • Re: Is IBM actually doing something with IDS?
    ... pool in the job market. ... Oracle has lot more demand ... and also there are lot of oracle professionals in the ... Oracle Jobs - 276 ...
    (comp.databases.informix)
  • RE: Is IBM actually doing something with IDS?
    ... It's a sad day for Oracle when the best benchmark numbers they can come up ... pool in the job market. ... Oracle Jobs - 276 ... Informix Jobs - 6 ...
    (comp.databases.informix)