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