......
If this script is automatically called from spcreate (which is
the supported method), all STATSPACK segments will be created in
the PERFSTAT user's default tablespace.

Using perfstat tablespace to store Statspack objects

... Creating STATS$SNAPSHOT_ID Sequence

Sequence created.

create public synonym STATS$SNAPSHOT_ID  for STATS$SNAPSHOT_ID
                      *
ERROR at line 1:
ORA-00955: name is already used by an existing object


Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Pr
oduction
With the Partitioning, OLAP and Data Mining options

SQL> select owner, synonym_name
  2  from dba_synonyms
  3  where synonym_name='STATS$SNAPSHOT_ID';

OWNER                          SYNONYM_NAME
------------------------------ ------------------------------
PUBLIC                         STATS$SNAPSHOT_ID

SQL> conn /as sysdba
Connected.
SQL>
SQL> select username, account_status
  2  from dba_users
  3  where username='PERSTAT';

no rows selected
SQL>
SQL>
SQL> set pagesize 9999
SQL> set linesize 200
SQL> col owner format a20
SQL> col table_owner format a20
SQL> select owner, synonym_name, table_name, table_owner
  2  from dba_synonyms
  3  where synonym_name='STATS$SNAPSHOT_ID';

OWNER                SYNONYM_NAME         TABLE_NAME           TABLE_OWNER
-------------------- -------------------- -------------------- -----------------
---
PUBLIC               STATS$SNAPSHOT_ID    STATS$SNAPSHOT_ID    PERFSTAT

SQL> drop synonym STATS$SNAPSHOT_ID;
drop synonym STATS$SNAPSHOT_ID
             *
ERROR at line 1:
ORA-01434: private synonym to be dropped does not exist

SQL>select TB.owner, TB.table_name,
2  SY.table_owner, SY.synonym_name
3  from dba_tables TB, dba_synonyms SY
4  where TB.owner=SY.owner
5* and tb.table_name='PERFSTAT'
no rows selected

SQL> drop synonym STATS$SNAPSHOT_ID;
drop synonym STATS$SNAPSHOT_ID
             *
ERROR at line 1:
ORA-01434: private synonym to be dropped does not exist

SQL>Show user
USER is "SYS"

C:\>set oracle_sid=2003dbclone
C:\>
C:\>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Sep 12 10:29:16 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn /as sysdba
Connected.
SQL> drop synonym perfstat.STATS$SNAPSHOT_ID
  2  ;
drop synonym perfstat.STATS$SNAPSHOT_ID
                      *
ERROR at line 1:
ORA-01434: private synonym to be dropped does not exist


SQL> conn perfstat/tuananhtran
Connected.
SQL> drop synonym STATS$SNAPSHOT_ID;
drop synonym STATS$SNAPSHOT_ID
             *
ERROR at line 1:
ORA-01434: private synonym to be dropped does not exist

SQL>show user
User is "PERFSTAT'
SQL> @C:\oracle\product\10.2.0\NeoDb\RDBMS\ADMIN\spreport.sql

Current Instance
~~~~~~~~~~~~~~~~

   DB Id    DB Name      Inst Num Instance
----------- ------------ -------- ------------
 2058405159 NEO86               1 neo86



Instances in this Statspack schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  from stats$database_instance
       *
ERROR at line 7:
ORA-01775: looping chain of synonyms



Using 2058405159 for database Id
Using          1 for instance number
       from stats$database_instance
            *
ERROR at line 5:
ORA-06550: line 5, column 13:
PL/SQL: ORA-01775: looping chain of synonyms
ORA-06550: line 4, column 6:
PL/SQL: SQL Statement ignored
ORA-06550: line 11, column 13:
PL/SQL: ORA-04020: deadlock detected while trying to lock object
PERFSTAT.STATS$SNAPSHOT
ORA-06550: line 10, column 6:
PL/SQL: SQL Statement ignored


Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Pr
oduction
With the Partitioning, OLAP and Data Mining options

C:\>