01-27-2016
Disable async IO at OS level
Hi ,
User claims that report refresh is taking longer time than usual time and asking us to disable async IO at OS level.
1 DB is running in this server
This is prod server
OS -- AIX
My question is would there be an impact to database and server if we disable async IO in OS?
is this the right way to fix the issue?
I found following note from Oracle document relevant to my change. Could you please check and comment on this?
Quote:
DISK_ASYNCH_IO controls whether I/O to datafiles, control files, and logfiles is asynchronous (that is, whether parallel server processes can overlap I/O requests with CPU processing during table scans). If your platform supports asynchronous I/O to disk, Oracle recommends that you leave this parameter set to its default value. However, if the asynchronous I/O implementation is not stable, you can set this parameter to false to disable asynchronous I/O. If your platform does not support asynchronous I/O to disk, this parameter has no effect.
If you set DISK_ASYNCH_IO to false, then you can increase DB_WRITER_PROCESSES or use DBWR_IO_SLAVES to simulate asynchronous I/O.
Regards,
Maddy
Last edited by Maddy123; 01-27-2016 at 11:17 PM..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am calling a shell script using PL/SQL stored procedures. This works great but I need the calls to be run synchronously and not asynchronously. I need the shell script to finish before returning control back to the procedure. Any ideas? (3 Replies)
Discussion started by: ted5547
3 Replies
2. UNIX for Dummies Questions & Answers
Solaris 2.8
I know regular filesystems use Async I/O on Solaris 2.8. Does anybody know if NFS uses Sync I/O or Async I/O ? (1 Reply)
Discussion started by: marist89
1 Replies
3. Solaris
Yes, really can't find anything about this. Can anyone suggest a way, how to do it? This is really what I need for. I need for may be list of system calls to read about or probably some C\C++ sources... Please, help... (1 Reply)
Discussion started by: LocalStorm
1 Replies
4. UNIX for Advanced & Expert Users
Hi,
I'm working in an application and the related Java code and the envrionment is in Unix server. We are generating the log messages using loggers of Java.util.log . But, the logs are not getting generated in the log files.
We feel that the people who developed the system might have done some... (6 Replies)
Discussion started by: kelangovan
6 Replies
5. Red Hat
Hi All....
This is related to exporting a file system through nfs. Just wanted to understand the significance of sync/async in nfs.
We give this entry in /etc/export file. What is the difference between these two.
Any hep is appreciated.
Regards,
Amol. (2 Replies)
Discussion started by: Amol21
2 Replies
6. Solaris
what are the major Difference Between run level & init level (2 Replies)
Discussion started by: rajaramrnb
2 Replies
7. Solaris
Hi guys.
This may be a stupid question but I am trying to see if my Solaris 9 server has async i/o enabled...
Is there a quick way to determine this?
Thanks in advance. (1 Reply)
Discussion started by: jamie_collins
1 Replies
8. Red Hat
Hi all Expertise,
I have following issue to solve,
SSL / TLS Renegotiation DoS (low) 222.225.12.13
Ease of Exploitation Moderate
Port 443/tcp
Family Miscellaneous
Following is the problem description:------------------
Description The remote service encrypts traffic using TLS / SSL and... (2 Replies)
Discussion started by: manalisharmabe
2 Replies
9. Red Hat
We have a RHEL 5.8 server at the production level and we have a Java application on this server. I know of the SSL certificate generation at the OS (RHEL) level but it is implemented on the Java application by our development team using the Java keytool. My doubt is that is the SSL generation can... (3 Replies)
Discussion started by: RHCE
3 Replies
10. Programming
hi
i need to asynchronous connect to webpage which has only text file. need to read its content, line by line using linux socket. any samples? (1 Reply)
Discussion started by: leo2008
1 Replies
rpc(n) Tnm Tcl Extension rpc(n)
__________________________________________________________________________________________________________________________________________________
NAME
rpc - A simple RPC protocol for Tcl applications.
_________________________________________________________________
DESCRIPTION
RPC COMMAND
rpc server port
Set up an RPC server listening an port port. This command returns a rpc handle that be used to register Tcl procs that will be
exported by a trivial RPC protocol on top of TCP. This RPC mechanism allows us to write cooperating scripts without worrying much
about the communication protocol.
rpc client host port
Connect to the RPC server running on host with port port. The returned client handle can be used to invoke an exported proc on the
server host.
rpc delete handle
Delete a server or a client RPC handle. All connections associated with the handle will be closed.
rpc register rpchandle proc
Export proc as an RPC callable proc using the server handle rpchandle. Only registered procs can be called by RPC clients.
rpc unregister rpchandle proc
Remove proc from the list of exported procs on server handle rpchandle.
rpc info [rpchandle]
Calling rpc info without any arguments returns a list of all rpc handles that have been created using the rpc server and rpc client
command. Info about a specific rpc file handle rpchandle is returned by using the optional argument. The result is a list contain-
ing the tcp file handle used for the communication and the list of registered commands for a rpc handle and a list of all files that
represent connections to an rpc server. This list is empty if rpchandle belongs to a rpc client.
rpc# [-async] proc arg1 arg2 ...
To invoke a remote procedure proc, use the same syntax as used with a local invocation preceeded by a client rpchandle. The result
of the remote procedure call will be returned or an error if the underlying communication channel signals errors. The -async options
can be used to invoke proc without waiting for it to complete. The async option will never return a result.
SEE ALSO
scotty(1), Tcl(n)
AUTHORS
Juergen Schoenwaelder <schoenw@cs.utwente.nl>
Tnm rpc(n)