RE: Switch between two statspack ( perfstat ) schemas
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: <ranko.mosic@xxxxxxxxx>, "_oracle_L_list" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 21 Apr 2006 11:45:11 -0700
Why not just periodically purge the older data from your statspack tables? Tim
Gorman has a handy script for this over at evdbt.com:
http://www.evdbt.com/tools.htm#sppurpkg
Regards,
Brandon
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Ranko Mosic
Sent: Friday, April 21, 2006 9:53 AM
To: _oracle_L_list
Subject: Switch between two statspack ( perfstat ) schemas
Hi List,
I need to switch between two statspack schemas every 3 months ( tables become
too big so we want to
switch back and forth with snapshot truncate and dbms_job modification during
the switch ).
I'll have perfstat1 and perfstat2 users and each of them will have it's own set
of statspack tables.
The question is: how do I make it transparent to the user so they always
connect to the same user.
Let's say they connect to perfstat1. How do I make them use perfstat2
tables/objects ?
Local tables always takes precedence when referenced, no matter what I do with
synonyms.
If exec snapshot.snap it will always exeecute perfstat1 proc.
Oracle V9x ( irrelevant I guess).
--
Regards,
Ranko Mosic
Contract Senior Oracle DBA
B. Eng, Oracle 10g, 9i Certified Database Professional
Phone: 416-450-2785
email: mosicr@xxxxxxxxxx
http://ca.geocities.com/mosicr@xxxxxxxxxx/ContractSeniorOracleDBARankoMosicMain.html
Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do not
consent to Internet email for messages of this kind. Opinions, conclusions and
other information in this message that do not relate to the official business
of this company shall be understood as neither given nor endorsed by it.
Other related posts:
