Switch between two statspack ( perfstat ) schemas

  • From: "Ranko Mosic" <ranko.mosic@xxxxxxxxx>
  • To: _oracle_L_list <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 21 Apr 2006 12:52:59 -0400

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).
Ranko Mosic
Contract Senior Oracle DBA
B. Eng, Oracle 10g, 9i Certified Database Professional
Phone: 416-450-2785
email: mosicr@xxxxxxxxxx

Other related posts: