Client Support
cancel
Showing results for 
Search instead for 
Did you mean: 

TRIM On Oracle DB's - Need SQL Statements to set baseline

SOLVED
Go to solution
Highlighted
Yuri Prado
Member

TRIM On Oracle DB's - Need SQL Statements to set baseline

Hi All,

 

We are about to substantially increase our TRIM Oracle DBs cache table memory. As a result of this configuration change I need to obtain a baseline on the current performance, by executing SQL statments directly through Oracle and time how long it takes to produce result.

 

Can anyone give me some basic SQL statments for TRIM that I can run on our database, obviously utilsing the standard tables (TSRecord, etc).

 

Thanks

 

Y.

2 REPLIES
Yuri Prado
Member
Solution

Re: TRIM On Oracle DB's - Need SQL Statements to set baseline - Self Solved (Activity Log Window)

Hi All,

 

I just realised that I can see the sql statments when activating the activity log pane :)

 

 

 

Greg Fraser_1
HPE Expert

Re: TRIM On Oracle DB's - Need SQL Statements to set baseline - Self Solved (Activity Log Window)

That was an easy one ;)

**Any opinions expressed in this forum are my own personal opinion and should not be interpreted as an official statement on behalf of Hewlett Packard Enterprise**
//Add this to "OnDomLoad" event