ORACLE SETALL PARAMETER this parameter could be found in the option and the init.ora parameter filesystemio_options: see the file init.ora in your systemOracle init.ora: filesystemio_options = SETALL or JFS2 mount option: mount -o dio /oradata/ts1.dbf
your box is slow because you still do not have enough memory - it scans to frees itself to a virtual halt. You have occasionally a scan to free rate of 30:1 - anything above 4 would be considered a problem. Your minperm is too high, set it to 3% and set min/maxfree to 960/1088. If this would be my box, I would add at least 20 GB just as a starter and take it from there.
Furthermore your disk response times are a disaster and hdisk2 is completely saturated, hdisk1 doesnt look much better. Assuming that hdisk2 is your pagingdisk, this will get better with more memory too - still you should spread your load across more disks.
As you have already a whole lot of memory in your box, my next question would be 'how big is your SGA', did the DBAs pin it into memory - and does it have to be THAT big. I can see that you have some decent IO in both reads and writes so you are moving data - but still not enough to explain almost 100 GB memory usage. And a too big SGA both slows down the server + oracle itself because it ironically takes longer for oracle to use that memory.
I would still like to see the output of mount without any options.
Regards
zxmaus
Last edited by zxmaus; 12-12-2010 at 09:06 PM..
Reason: logical error - wrong tunable mentioned - now corrected
What version of Oracle are you running?
Are you using Enterprise Manager?
If not are you using statspack?
Have the database objects been analyzed lately?
Is it one query that you're having problems with or are all queries slow?
If it's one query, can you run this:
post the contents of query.log
If all queries are slow, then generate an AWR report (Enterprise Manager) or a statspack report (statspack). Run these reports for the time period you see the slowdown, but have the report cover no more than a 1 hour time period, preferably 15 to 30 minutes. You can run multiple reports, if necessary, to cover subsequent time periods.
Depending on the version, there may be a DBA view called V$SESSION_LONGOPS. You can query this view to see what operations are taking a long time to complete as well.
Hello,
All the commands on AIX are running very slow.
Below is few stats but I didn't find any issue in cpu or memory reosurces
vmstat
System configuration: lcpu=4 mem=6144MB ent=1.00
kthr memory page faults cpu
----- -----------... (2 Replies)
Hello,
Please help me with a script with which I can check long running processes on the database server and the os is AIX.
Best regards,
Vishal (5 Replies)
Hi Guys,
Need you help in one point!
I am working on one shell script which takes following steps :
1. Taking one query result from oracle database
2. Exporting that result to Xls file
3. Mailing that file to my own mail ID
Now, I want to give a threshold limit to one of the column... (0 Replies)
good morning
what is the better solution to examen a P570 ?
because i use topas and nmon, and the results are totally different !!!
with nmon, i have 80% free cpu, and with nmon, i have 90% of used cpu !!!!!!
i take a shot with an intervall of 10s during 10 mn.
thank you (0 Replies)
Hi,
I am running an oracle db 9.2.0.5.0 on ibm p5 550 aix 5.3 with 10g ram, 10G swap space 3 database instances each SGA about 500Meg.
I am getting the following error in my alert log file from time to time:
skgpspawn failed:category = 27142, depinfo = 11, op = fork, loc = skgpspawn3
... (0 Replies)
hi,
how can i diplay:
- the ammount RAM used /free
- ammount of ram used from a pid or prozess
we have the problem, that malloc is returing a NULL pointer errno = 12 ( not enough space).
but i think there is still ram free.
nmon : shows all memory used ?
Memory Use Physical Virtual... (7 Replies)