| SQL Profiles [message #534813] |
Fri, 09 December 2011 06:28 |
 |
suddhasatwa_bhaumik
Messages: 18
Registered: October 2011
Location: India
|
Junior Member |
|
|
Hello,
During a performance tuning excercise on one of my databases (lets say, D1) running Oracle 10.2.0.3 on Solaris 10, the DBMS_SQLTUNE package recommended using an SQL Profile which I am using now and the query is running much much faster as expected!.
However .... this database D1 is being refreshed/cloned using RMAN Fast Refresh on demand as per my client's business requirement from another database D2. On the source database D2, I have not created this SQL Profile as I mention above.
My Query :: After the next RMAN Fast refresh of D1 from D2, would the above created SQL profile be deleted from this database D1?
For any queries, kindly let me know.
Many Thanks in advance!!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
