08-12-2010
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
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 SUSE
ccw_device_start
CCW_DEVICE_START(9) The ccw bus CCW_DEVICE_START(9)
NAME
ccw_device_start - start a s390 channel program
SYNOPSIS
int ccw_device_start(struct ccw_device * cdev, struct ccw1 * cpa, unsigned long intparm, __u8 lpm, unsigned long flags);
ARGUMENTS
cdev
target ccw device
cpa
logical start address of channel program
intparm
user specific interruption parameter; will be presented back to cdev's interrupt handler. Allows a device driver to associate the
interrupt with a particular I/O request.
lpm
defines the channel path to be used for a specific I/O request. A value of 0 will make cio use the opm.
flags
additional flags; defines the action to be performed for I/O processing.
DESCRIPTION
Start a S/390 channel program. When the interrupt arrives, the IRQ handler is called, either immediately, delayed (dev-end missing, or
sense required) or never (no IRQ handler registered).
RETURNS
0, if the operation was successful; -EBUSY, if the device is busy, or status pending; -EACCES, if no path specified in lpm is operational;
-ENODEV, if the device is not operational.
CONTEXT
Interrupts disabled, ccw device lock held
AUTHOR
Cornelia Huck <cornelia.huck@de.ibm.com>
Author.
COPYRIGHT
Kernel Hackers Manual 2.6. July 2010 CCW_DEVICE_START(9)