AppletTalk.com Java discussions newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Time spent by DB for a particular query          AppletTalk.com Forum Index -> Java and Databases View previous topic :: View next topic   Author Message gp Guest Posted: Mon Aug 29, 2005 8:59 pm    Post subject: Time spent by DB for a particular query Hi, I use Oracle 10g as my backend repository. I am trying to do some performance analysis against this DB. All I need is time spent by DB for a particular query. I used statspack to capture DB statistics. But, I am not able to comprehend usefull information from the report. How can I get that information. If not statspack, are there any other tools? Thanks, gp Back to top Roy Brokvam Guest Posted: Mon Aug 29, 2005 10:49 pm    Post subject: Re: Time spent by DB for a particular query You should ask this question in the Oracle groups, as this is not a Java question at all. There are several Oracle tools that will help you analyze your query, and Statspack is one of the most powerful. It is well documented in the Oracle documentation. Regards, Roy "gp" <parcha (AT) gmail (DOT) com> wrote Quote: Hi, I use Oracle 10g as my backend repository. I am trying to do some performance analysis against this DB. All I need is time spent by DB for a particular query. I used statspack to capture DB statistics. But, I am not able to comprehend usefull information from the report. How can I get that information. If not statspack, are there any other tools? Thanks, gp Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         AppletTalk.com Forum Index -> Java and Databases All times are GMT Page 1 of 1   Jump to: Select a forum Java Newsgroups----------------Java DiscussionsWeb-based java games comp.lang.java 3D Graphics API's for Java Java: Support and criticism Java System Announcements comp.lang.java.api JavaBeans Java and CORBA Java and Databases comp.lang.java.developer Java GUI Toolkits Java Help comp.lang.java.javascript JVM, native methods and hardware comp.lang.java.misc Java Language Programming Security and Java comp.lang.java.setup Java Software Tools comp.lang.java.tech ibm.software.java.linux  Non-English Java Newsgroups----------------Java Language (German)Language Java (Français)Java (Italian)  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.