1. Slow query in Java by JDBC but not in other systems (TOAD) stackoverflow.comHello i have a query to an Oracle System which involves a view which joins other tables by apliying an TO_NUMBER() to the tables primary key. If i do the query using ... |
2. Setting and updating connection pool (OracleConnectionPoolDataSource) properties for best performance stackoverflow.comIn a Java web application I am working on, we are using OracleConnectionPoolDataSource for a database connection pool functionality. Each getConnection call includes the user's Oracle ID and password. So each ... |
3. Fast Oracle Select [Huge Data] stackoverflow.comI have a project whereby I'm reading huge volumes of data from an Oracle database from Java. I have the feeling that the application we are writing is going to process the ... |
4. Choosing betwen JDBC or ADO.NET, performance studies on Oracle stackoverflow.comWe are starting a new project, wich talks to an Oracle database with millions of data. The system is mission critical and should be highly performant. We are now choosing ... |
5. Huge performance hit when using Java/OJDBC stackoverflow.comI am having some strange behavior with the using the Java with the "ojdbc.jar" as the client. I have a simple program that tries to just inserts 500 rows using one query. ... |
6. Any solution for Oracle TNS inefficiencies (many roundtrips, latency) from a Java app? stackoverflow.comI was looking at a very slow SQL query (originating from a Java app using Hibernate deployed in JBoss 5.1). This particular query returned about 10K records but still took 40s ... |
7. Performance issues with JDBC stackoverflow.comI'm currently facing an issue where a specific SQL-query is taking about 30 seconds to issue from within my Java application but <1 sec in a SQL-client (SQL Developer). In the ... |
8. Performance implications of handling CLOBs with Oracle JDBC using SetBigStringTryClob stackoverflow.comI am in process of reviewing some old Java/JDBC code for CLOB-handling on oracle database. Existing code uses approach similar to the approach mentioned in this question. I found |
9. Oracle total query executions with count and execution time (for Java program) stackoverflow.comI want to know total how many queries got executed with its count and execution time for my Java program (I dont have the source code). I am planning to write PL/SQL ... |
10. performance problem in saving/retrieving huge blob from oracle DB using Java stackoverflow.comI am saving huge blob(500 MB) into oracle DB using JDBC. It takes a lot of time in insertion and later on retrieval. Please suggest, if any of you have encountered this ... |
11. Sybase TEXT vs Oracle CLOB performance stackoverflow.comWe're in the process of converting our database from Sybase to Oracle and we've hit a performance problem. In Sybase, we had a TEXT field and replaced it with a ... |
12. Performance overhead of using java in oracle stackoverflow.comGreetings everybody, I came across the feature of using java in oracle, a few days back. Ever since I am wondering about the possibility of writing static methods in ... |
13. Performance of Oracle xpath: two select scenarios stackoverflow.comI am using oracle 11g and have a table with an XMLType. There are many records in this table and each XML contains a list of 0 to n answers ... |
14. How often does oracle revise a query plan? stackoverflow.comWhen running a performance benchmark for our data processing application we start with a FOO_TABLE empty and then insert records from one thread while in another thread we select the same ... |
15. Performance of SELECT query- Oracle/JDBC stackoverflow.comI have a existing query in the system which is a simple select query as follows:
|
16. Is oracle jdbc driver tuned up and is there any method of carrying out early? stackoverflow.comSince I am a Japanese, I am poor at English. Please understand the situation. Its best was done in the method of issue of the present SQL or the query of java ... |
17. Oracle performance coderanch.com |
18. Oracle performance hit for 1 million record coderanch.comHello, My client is using a product for managing data consisting of millions of records. My problem is related to sorting of data on an alphanumeric column - Product_Name. A non-clustered index is created on it. Product_Id is the primary key. It is taking more than 20 secs to display 100 records. The problem is oracle specific, because the query itself ... |
19. Optimize Oracle Performance? coderanch.comConnection pooling, connection pooling, connection pooling. Also, if connection times are slow, then often the network is slow in general and it becomes even more important to use Statement.setFetchSize() (or Oracle's non-standard OracleConnection.setDefaultRowPrefetch() ). By default, the Oracle driver will retrive ResultSets in 10-row chunks; usually, raising the fetch size improves performance significantly (at the cost of using more memory for ... |
20. Oracle 9i reading BLOB performance issues coderanch.comWindows XP Pro SP2 JDK 1.5.0_05 Oracle 9i Oracle Thin Driver for JDK 1.4 v.10.2.0.1.0 DBCP v.1.2.1 Spring v1.2.7 (I am using the JDBC template for convenience) ________________________ I have run into serious performance issues reading BLOBs from Oracle using oracle's JDBC thin driver. I am not sure if it a constraint/mis-configuration with oracle or a JDBC problem. I am hoping ... |
21. Oracle Function returns a Ref Cursor to a ResultSet object - Performance issues coderanch.comMy program calls an Oracle PL/SQL function which returns a ref cursor to a ResultSet object. I know that the function runs to completion relatively quickly when i run it in an anonymous block but when the call is made through my Java application the resultset takes about 30 mins to return. Below is a snippet of my code: currentConnection = ... |
22. Regarding performance in Oracle DB coderanch.comHi all, I am writing a query to fetch records based on some condition. Instead of putting a where clause can I put a concat operation for the condition and join them and execute as a single condition ? Which is the more efficient one ? E.g. Instead of using select * from table name where column1 ='21' and column2 = ... |
23. Performance tuning for Oracle CLOBs with a remote database coderanch.comI am accessing an Oracle database that is about 4000 miles away. The bandwidth on both ends is adequate, and the performance is reasonable so long as I set the fetch size to an appropriate number. Retrieving 31,000 rows of data without CLOBS behaves as follows: fetch size | seconds ------------+-------- default | 84 100 | 11 1000 | 3 When ... |
24. Oracle: Type2 vs. Type4 drivers' performance coderanch.comI am using Oracle 10g database. For large rowset (more than 10,000 rows) retrieval which type of driver is better in terms of performance? For long ago I read Type2 is better than Type4 in terms of performance. I don't know the recent changes in their implementation hence requesting your feedback. Thanks. |
25. Oracle Database 11g: Performance Tuning-Certification forums.oracle.comDear All! I want to take exam 1z0-054 for "Oracle Database 11g: Performance Tuning". I've completed an Oracle authorized couse of "Oracle Database 11g: Performance Tuning DBA" in 2008,which is one of requirements to get that certificate. Please any info regarding to expiration of complilation of courses? If I pass 1z0-054 exam ,will the above mentioned couse considered? And the last ... |