Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Measuring performance gains
> anupcomp_at_giasbm01.vsnl.net.in writes:
..The response time for users is a crucial factor. How do we
> measure it? Is someone doing something like this?
..
We identified some complex views which get used frequently by online users. We picked the most troublesome one and set up a scheduled sqlplus run of it once a day with timing on to display the runtime. We plot this and watch for spikes. I hope to add more views and make the script accumulate the times in a history file I can suck into EXCEL and plot.
![]() |
![]() |