Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to track historic data in QVD

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

3 Replies
ashfaq_haseeb
Champion III
Champion III

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

Not applicable
Author

Refreshing qvd every 5  min is not acceptable in our server.Due to performance issue.

Anonymous
Not applicable
Author

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")