Home » SQL & PL/SQL » SQL & PL/SQL » Calculate the count of Concurrent connections to a website for every minute
Calculate the count of Concurrent connections to a website for every minute [message #216663] Mon, 29 January 2007 19:15 Go to next message
vamsi88
Messages: 6
Registered: January 2007
Junior Member
Hi ,

I've a requirment to count the concurrent connections to a website for every minute,hour or day..

My data will look like this...

Plz check the attachment for the the data sample..

Thanks a ton..
  • Attachment: a.txt
    (Size: 1.45KB, Downloaded 254 times)
Re: Calculate the count of Concurrent connections to a website for every minute [message #216664 is a reply to message #216663] Mon, 29 January 2007 19:25 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
I'm confused. What does this have to do with Oracle?
Re: Calculate the count of Concurrent connections to a website for every minute [message #216666 is a reply to message #216664] Mon, 29 January 2007 19:29 Go to previous messageGo to next message
vamsi88
Messages: 6
Registered: January 2007
Junior Member
Need to write a sql statement to Calculate the count of Concurrent connections to a website for every minute.
Re: Calculate the count of Concurrent connections to a website for every minute [message #216716 is a reply to message #216663] Tue, 30 January 2007 02:32 Go to previous message
nksnare
Messages: 9
Registered: November 2006
Location: KL, Malaysia
Junior Member

HI, Does that mean you have all the site counter statistics in a oracle table and you have to write a query in order to get the concurrent connections?
Previous Topic: STORED PROCEDURES
Next Topic: count(*) or count(1)
Goto Forum:
  


Current Time: Tue Dec 06 04:12:02 CST 2016

Total time taken to generate the page: 0.07908 seconds