Client Support
Showing results for 
Search instead for 
Do you mean 

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

SOLVED
Go to Solution
Valued Contributor

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
Valued Contributor

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

 

 

 

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