Re: Switch between two statspack ( perfstat ) schemas
- From: "Ranko Mosic" <ranko.mosic@xxxxxxxxx>
- To: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- Date: Fri, 21 Apr 2006 18:17:14 -0400
They want to keep them available for 3 months
On 4/21/06, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx> wrote:
>
> 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.
>
--
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
Other related posts:
