This content has been marked as final. Show 17 replies
Good point, Jer. Of course you (user525100) can turn off reverse lookups in configuration of webserver.
The reason I ask is because it might have to do with your web server doing reverse-dns lookups for the logging.
1. You can turn on the sqlnet tracing on client (oracle) alon with server sqlnet tracing on Oracle database. Trace files will show you whether is problem with connectivity or not.
2. I think SQL tracing on webserver will be more relevant than on TOAD.
Little of topic suggestion:
Seem you don't using Bind variables. If your application will be most accessed then better use them.
If you do sqlplus to the database server from theAlmost without any delay. There are also other applications on the server working with the database and they don't have these problems. In addtition I added some debug code to output the execution time of the script. The most time is lost right after the execute statement.
webserver, how long does it take to connect?
Does the webserver take a while to serve requestsThere is a wiki installed on the server. It has no connection to a databse and writes directly into test files. I couldn't observe the issue with these pages.
that are of static pages? What about php scripts
that aren't database-driven?
Here some information out of the phpinfo, which might be relevant:
PHP Version 5.0.2
OCI8 Support enabled
Revision $Revision: 1.257 $
Active Persistent Links 1
Active Links 1
Temporary Lob support enabled
Collections support enabled
Message was edited by:
Hello,What are your environment variables for ORACLE_HOME and NLS_LANG? I know the newer versions of oci8 require those... is there anything else in the php change log that would point to differences? I don't think Apache is giving you the problems.
I tried to update Xampp with apache 2.0.52 and PHP 5.0.2
and oci8 rev 1.257 to apache 2.2.2 and PHP 5.1.4 .
I uncommentet the line extension=php_oci8.dll and the
extension directory is correctly set by xampp.
And the first environment Path of the System is still
linked to ...\oracle\ora92\bin .
Starting the Apache server I get the error message: "The
procedure entry point OCILobRead2 could not be located
in the dynamic link library OCI.dll"
With the old version the only thing I had to do was
uncommenting the extension line, but with the new
version it simply doesn't want to work.
After renaming my backup folder with the old server
everything is working again. But not the new version.
Thanks for any help!
Perceived slowness is something that is dealt with by using process called "tuning". Tuning process requires an extensive knowledge because it should go from end to end, starting with the application. There may be an issue with your application, database, operating system, middle tier or network and one has to know all of the above to be able to tune the application properly. It's always the application one tunes, because it's the application that makes the end users unhappy. In your posts, there is not enough information to even begin thinking about tuning, so I will outline the tuning process for you. One always begins the tuning process by blaming the network and by letting the network engineers use sniffer and dig out the slow component. Typical response from the network people is "network is OK but the server XXX is slow with responses
and that's what causing the timeouts"). Now you know where the problem is so you can concentrate on a single server and figure out what the problem is. Whatever the problem is, it is usually solved by improving the cache hit ratio by increasing the SGA. Network engineers are
used to that and they do not mind, but if you want to be mr. nice guy, you can go directly to your boss and ask him for more memory. That is so called modified method C, by Cary Millsap. That is why it's called "method C".