Re: Oracle SPA Use case

Hi Lok,

I think you confusing RAT and database replay. RAT consists of Database Replay and SPA. Database Replay is seen as the "real thing" quite often and therefore it is often used synonym to RAT. You can not use the AWR data, because it is aggregated data . It does not necessarily reflect you tuning set accurately. In particular bind variables used will change things.
To be able to compare apples to apples you have to run your set twice. SPA is more about plan changes than about hardware performance, although you can use it that way.

Regards

Lothar

Am 26.02.2021 um 09:36 schrieb Lok P:
> Hi Listers, We are on RDBMS version 11.2.0.4 of Oracle exadata and are
> migrating from exadata X5 to X8 and want to perform a basic
> performance test on the new X8. We don't currently have the time and
> flexibility to perform a real application testing(RAT) test which
> would have been a full fledged test of the exact behaviour of the
> application on X8. So we want to go for the SPA(sql performance
> analyzer) option as a quick alternate. I have few questions around SPA
> testing.
>
> 1)In the SPA test I am seeing we don't have an option to have the
> DML/DDl tested on the current 11.2 version.So is there any alternate
> way to achieve/test this?
> 2) And also after capturing the sql tuning sets from the AWR , it's
> asking to run, create and analyze tasks on the current database which
> is again going to take time as it will run the SELECT part of the
> statements(DML/DDL) behind the scene. So my question was as we already
> have the AWR data in the current database why i have to again run it
> and that is going to take time and resources on the current production
> database? is it simply possible to capture the sql tuning set from
> current production for a certain period (say 3-4hrs) and then just
> export and import it to the new X8 database and then run it  there and
> compare and see the difference in performance?
>
> Regards
> Lok

--
http://www.freelists.org/webpage/oracle-l