File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to validate that the query is performing

 
Padma priya Gururajan
Ranch Hand
Posts: 437
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

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

Thanks
 
Martin Vajsar
Sheriff
Pie
Posts: 3747
62
Chrome Netbeans IDE Oracle
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 2372
31
Linux Oracle Postgres Database Python Scala
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic