You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-user@db.apache.org by mah_habbal <ma...@sphere.ae> on 2008/06/08 12:24:48 UTC

Statistical Information of overall queries

Hi, 
I am using Hibernate to manage my derby database but I don’t know how to got
statistical information about my database, like how many SQL query my
application is hitting db or how many insert in “a minute” for a particular
table, how many time specific SQL  query executed in “an hour”.
My question is related to overall statistical info, now I don’t care about
info of individual query which I found via calling procedure 

VALUES SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS()

If anyone can help me and tell me if derby and/or hibernate can give those
information 

Thanks 
Mahmoud,
-- 
View this message in context: http://www.nabble.com/Statistical-Information-of-overall-queries-tp17717421p17717421.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: Statistical Information of overall queries

Posted by mah_habbal <ma...@sphere.ae>.

Thanks Rick
I think this will be useful 
I will check SubversionLogVTI and see how i can utilize it 

Regards
=)


Rick Hillegas-2 wrote:
> 
> Hi Mahmoud,
> 
> Some of the information you need can be obtained by setting a tracing 
> property when you bring up the Derby engine. Please see the section 
> titled "derby.language.logStatementText" in the Derby Tuning Guide: 
> http://db.apache.org/derby/docs/10.4/tuning/ Setting this property will 
> cause Derby to log each executed statement along with timestamp and 
> other information. The information will be written to derby.log.
> 
> You can then aggregate those log records. If I were tackling this 
> problem myself, I would be tempted to write a simple table function to 
> parse the log records into timestamp and text columns and then slice and 
> dice the log using SQL. For an example of how to do this, please take a 
> look at the demo directory tree in your 10.4 distribution. In the vtis 
> subtree, you will find a log-reading table function called 
> SubversionLogVTI. The demoFileVtis.sql script shows you how to run SQL 
> against a log-reading table function like this.
> 
> Hope this helps,
> -Rick
> 
> mah_habbal wrote:
>> Hi, 
>> I am using Hibernate to manage my derby database but I don’t know how to
>> got
>> statistical information about my database, like how many SQL query my
>> application is hitting db or how many insert in “a minute” for a
>> particular
>> table, how many time specific SQL  query executed in “an hour”.
>> My question is related to overall statistical info, now I don’t care
>> about
>> info of individual query which I found via calling procedure 
>>
>> VALUES SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS()
>>
>> If anyone can help me and tell me if derby and/or hibernate can give
>> those
>> information 
>>
>> Thanks 
>> Mahmoud,
>>   
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/Statistical-Information-of-overall-queries-tp17717421p17748125.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: Statistical Information of overall queries

Posted by Rick Hillegas <Ri...@Sun.COM>.

Hi Mahmoud,

Some of the information you need can be obtained by setting a tracing 
property when you bring up the Derby engine. Please see the section 
titled "derby.language.logStatementText" in the Derby Tuning Guide: 
http://db.apache.org/derby/docs/10.4/tuning/ Setting this property will 
cause Derby to log each executed statement along with timestamp and 
other information. The information will be written to derby.log.

You can then aggregate those log records. If I were tackling this 
problem myself, I would be tempted to write a simple table function to 
parse the log records into timestamp and text columns and then slice and 
dice the log using SQL. For an example of how to do this, please take a 
look at the demo directory tree in your 10.4 distribution. In the vtis 
subtree, you will find a log-reading table function called 
SubversionLogVTI. The demoFileVtis.sql script shows you how to run SQL 
against a log-reading table function like this.

Hope this helps,
-Rick

mah_habbal wrote:
> Hi, 
> I am using Hibernate to manage my derby database but I don’t know how to got
> statistical information about my database, like how many SQL query my
> application is hitting db or how many insert in “a minute” for a particular
> table, how many time specific SQL  query executed in “an hour”.
> My question is related to overall statistical info, now I don’t care about
> info of individual query which I found via calling procedure 
>
> VALUES SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS()
>
> If anyone can help me and tell me if derby and/or hibernate can give those
> information 
>
> Thanks 
> Mahmoud,
>