performance « oracle « Java Database Q&A





1. Slow query in Java by JDBC but not in other systems (TOAD)    stackoverflow.com

Hello 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.com

In 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.com

I 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.com

We 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.com

I 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.com

I 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.com

I'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.com

I 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.com

I 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.com

I 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.com

We'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.com

Greetings 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.com

I 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.com

When 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.com

I have a existing query in the system which is a simple select query as follows: SELECT <COLUMN_X>, <COLUMN_Y>, <COLUMN_Z> FROM TABLE <WHATEVER> Over time, <WHATEVER> is growing in terms of records. Is ...

16. Is oracle jdbc driver tuned up and is there any method of carrying out early?    stackoverflow.com

Since 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.com

Hello, 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.com

Connection 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.com

Windows 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.com

My 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.com

Hi 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.com

I 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.com

I 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.com

Dear 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 ...