Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

saving SQL Profile

Status
Not open for further replies.
ksbrace

ksbrace

Programmer
May 13, 2000
501
US
Oracle db 10.2.0.2 on Solaris 64-bit Solaris 10

I have a db that's cloned every evening.

I ran the SQL Tuning Advisor on some statements and received recommendations that suggested implementing a SQL PROFILE for a particular statement that executed during the nightly refresh/clone.

I Implemented the recommendation and the statement ran much faster.

The problem is that the code in question is executed each night after the instance has been refreshed and it's not available in the source instance for the refresh.

How do I save the SQL PROFILE that was recommended so that I can reapply it to the new version of the instance?

 
Sort by date Sort by votes
How do you clone the database? If it's a copy of a cold backup then you can set the profile in the source database.

Anand
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

George L
  • Locked
  • Question
web app not saving "all" records suddenly
Replies
3
Views
763
carp
carp
Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
848
Andrzejek
Andrzejek
Livia8
  • Locked
  • Question
SQL SELECT - where date is null or greater than 2
Replies
9
Views
4K
carp
carp
annie1975
  • Locked
  • Question
sql script in an cron job script failing
Replies
3
Views
282
carp
carp
Livia8
  • Locked
  • Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC 2
Replies
5
Views
322
Livia8
Livia8

Part and Inventory Search

Sponsor

Back
Top