|
|
Sponsored Content
Operating Systems
AIX
ORACLE Database running slow on AIX ( nmon / topas )
Post 302444629 by zxmaus on Thursday 12th of August 2010 09:55:23 AM
08-12-2010
Moderator
zaxxon,
we switch on cio or let oracle decide where to use cio because we want to avoid double buffering (what we have when both is on). If you switch off buffering completely (what you do with SETALL and cio both active) and you have a high transaction database, you are running the risk of saturating disks what used to happen in our company pretty frequently and slowed down the DBs more than not having anything activated.
But you are right - this is only true from Oracle 10g upwards - and we still do not know which DB version filosophizer is using
Kind regards
Nicki
we switch on cio or let oracle decide where to use cio because we want to avoid double buffering (what we have when both is on). If you switch off buffering completely (what you do with SETALL and cio both active) and you have a high transaction database, you are running the risk of saturating disks what used to happen in our company pretty frequently and slowed down the DBs more than not having anything activated.
But you are right - this is only true from Oracle 10g upwards - and we still do not know which DB version filosophizer is using
Kind regards
Nicki
This User Gave Thanks to zxmaus For This Post:
|
|
8 More Discussions You Might Find Interesting
1. AIX
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)
Discussion started by: Lazzar
7 Replies
2. Filesystems, Disks and Memory
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)
Discussion started by: hawkerpacific
0 Replies
3. AIX
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)
Discussion started by: pascalbout
0 Replies
4. AIX
Is there a 'top' command equivalent in AIX 4.2 ?
I already checked and I do not see the following ones anywhere:
top
nmon
topas (1 Reply)
Discussion started by: Browser_ice
1 Replies
5. Solaris
what is the command to see which database ie..oracle in running on solaris 10 (2 Replies)
Discussion started by: tv.praveenkumar
2 Replies
6. Shell Programming and Scripting
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)
Discussion started by: Agupte
0 Replies
7. AIX
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)
Discussion started by: Vishal_dba
5 Replies
8. AIX
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)
Discussion started by: Vishal_dba
2 Replies
LEARN ABOUT OPENDARWIN
exdbuf
exdbuf(3alleg4) Allegro manual exdbuf(3alleg4) NAME
exdbuf - How to use double buffering to avoid flicker. Allegro game programming library. SYNOPSIS
#include <allegro.h> Example exdbuf DESCRIPTION
This program demonstrates the use of double buffering. It moves a circle across the screen, first just erasing and redrawing directly to the screen, then with a double buffer. SEE ALSO
BITMAP(3alleg4), END_OF_MAIN(3alleg4), SCREEN_H(3alleg4), SCREEN_W(3alleg4), acquire_screen(3alleg4), allegro_error(3alleg4), alle- gro_init(3alleg4), allegro_message(3alleg4), blit(3alleg4), circlefill(3alleg4), clear_keybuf(3alleg4), clear_to_color(3alleg4), cre- ate_bitmap(3alleg4), desktop_palette(3alleg4), destroy_bitmap(3alleg4), font(3alleg4), install_keyboard(3alleg4), install_timer(3alleg4), keypressed(3alleg4), makecol(3alleg4), release_screen(3alleg4), retrace_count(3alleg4), screen(3alleg4), set_gfx_mode(3alleg4), set_pal- ette(3alleg4), textprintf_ex(3alleg4) Allegro version 4.4.2 exdbuf(3alleg4)