File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Oracle/OAS and the fly likes How to validate that the query is performing Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "How to validate that the query is performing " Watch "How to validate that the query is performing " New topic
Author

How to validate that the query is performing

Padma priya Gururajan
Ranch Hand

Joined: Oct 05, 2006
Posts: 430
Hi,

How to validate that the query is performing and has minimum impact on the database?

Thanks
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3431
    
  47

You'll run your application and its query under expected load. Then you'll create an AWR report. If your query doesn't appear anywhere in it, it is probably not worth tuning it.

Other than this, it is hard to say. A query which is run once a day outside business hours may not significantly impact the database even if it consumes a lot of resources. A query that is run once (or more) a second may impact the database heavily even if it consumes just a little of database resources. Also, if there are normally many applications running on the same database (a very usual setup nowadays), assessing the query performance in a test/dev environment that doesn't have the load from the other applications can be very misleading.
chris webster
Bartender

Joined: Mar 01, 2009
Posts: 1475
    
  11

You can also do various things while you are developing your query to make sure it will perform well e.g. use EXPLAIN PLAN to check it is using indexes correctly or to figure out where you might want to add indexes to improve performance.


No more Blub for me, thank you, Vicar.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to validate that the query is performing
 
Similar Threads
Question about Calendar
Performing validations for Ajax based page using struts2.0
Validation in ActionForm or ActionClass
Java Lib to Validate SQL Query for Syntex
How to validate HTML form using servlet