db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mah_habbal <mahmoud.alhab...@sphere.ae>
Subject Re: Statistical Information of overall queries
Date Tue, 10 Jun 2008 05:37:30 GMT

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.


Mime
View raw message