Client Support
cancel

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

SOLVED
Go to solution
Highlighted
Yuri Prado
Super 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
Yuri Prado
Super Contributor.
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
Acclaimed Contributor.

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 Micro Focus**