01-28-2016
I assume you're talking about Oracle DB. The version is unknown, but hopefully not elder than 10.2. Usual requirement from Oracle DBA is to switch
on the async I/O on the server side. If you have Oracle 10.x or later you can enable Concurrent I/O by setting FILESYSTEMIO_OPTIONS to setall in Oracle configuration. Read e.g. this document -
https://docs.oracle.com/cd/B28359_01...9/appa_aix.htm and consult Oracle support if you in doubt. I personally wouldn't switch off async I/O on AIX.
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
LEARN ABOUT MOJAVE
dbix::class::storage::dbi::oracle::wherejoins
DBIx::Class::Storage::DBI::Oracle::WhereJoins(3) User Contributed Perl Documentation DBIx::Class::Storage::DBI::Oracle::WhereJoins(3)
NAME
DBIx::Class::Storage::DBI::Oracle::WhereJoins - Oracle joins in WHERE syntax support (instead of ANSI).
PURPOSE
This module is used with Oracle < 9.0 due to lack of support for standard ANSI join syntax.
SYNOPSIS
DBIx::Class should automagically detect Oracle and use this module with no work from you.
DESCRIPTION
This class implements Oracle's WhereJoin support. Instead of:
SELECT x FROM y JOIN z ON y.id = z.id
It will write:
SELECT x FROM y, z WHERE y.id = z.id
It should properly support left joins, and right joins. Full outer joins are not possible due to the fact that Oracle requires the entire
query be written to union the results of a left and right join, and by the time this module is called to create the where query and table
definition part of the SQL query, it's already too late.
METHODS
See DBIx::Class::SQLMaker::OracleJoins for implementation details.
BUGS
Does not support full outer joins. Probably lots more.
SEE ALSO
DBIx::Class::SQLMaker
DBIx::Class::SQLMaker::OracleJoins
DBIx::Class::Storage::DBI::Oracle::Generic
DBIx::Class
AUTHOR
Justin Wheeler "<jwheeler@datademons.com>"
CONTRIBUTORS
David Jack Olrik "<djo@cpan.org>"
LICENSE
This module is licensed under the same terms as Perl itself.
perl v5.18.2 2013-07-12 DBIx::Class::Storage::DBI::Oracle::WhereJoins(3)