Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I connecting to Oracle database and pulling Session log from v$session, but It is having only sessions for latest data for 5min .I need to store the trend for rolling 4 hr.I can't refresh qvd every 5 min.
What is the best way to handle this type of situation.
Thanks,
Rahul
Hi,
I think for this you have to store data in qvd every 5 minute you load.
upon completion of 4 hours remove the required data.
Regards
ASHFAQ
Refreshing qvd every 5 min is not acceptable in our server.Due to performance issue.
I would suggest to contact with DBA and make data storage for v$session data, if it doesn't work you need to load data to the qvd every 5 minutes with previous data loads concatenation (see "Incremental data loading")