troubleshooting Question

Oracle DB connection time/duration

Avatar of rutgermons
rutgermons asked on
Oracle Database
4 Comments1 Solution352 ViewsLast Modified:

I have a requirement to understand how long a connection to Oracle remains active and understand the full impact this connection has on the database i.e. performance footprint on total memory/io/thruput

essentially the connection is a user that on a daily basis makes a direct connection to the database and then reads the entire schema transports the read to a data wharehouse, the issue here is that the read window is growing due to the data growth and I need to measure the window duration made against the database,

all help will do
Naveen Kumar
Production Manager / Application Support Manager

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros