Home » RDBMS Server » Performance Tuning » :x ORA-01920: user name 'PERFSTAT' conflicts with another user or role name :x (oracle 10.2.0.3.0 DB running on Vista ultimate)
:x ORA-01920: user name 'PERFSTAT' conflicts with another user or role name :x [message #303352] Thu, 28 February 2008 23:52 Go to next message
racman
Messages: 8
Registered: February 2008
Junior Member
I was trying to run a statspack report. For the first time, I run successfully, but the problem was, I was not able to see the c:\stats_report.txt. It ran in dos window, but I was not able to copy the whole report, the window being small.

Then I rerun the whole thing and I got stuck up like this. Can you help me to solve this issue please?



Choose the PERFSTAT users's default tablespace. This is the tablespace
in which the STATSPACK tables and indexes will be created.
TABLESPACE_NAME CONTENTS STATSPACK DEFAULT TABLESPACE
------------------------------ --------- ----------------------------
STATSPACK PERMANENT
SYSAUX PERMANENT *
USERS PERMANENT
Pressing <return> will result in STATSPACK's recommended default
tablespace (identified by *) being used.
Enter value for default_tablespace: statspack
Using tablespace STATSPACK as PERFSTAT default tablespace.

Choose the Temporary tablespace for the PERFSTAT user
-----------------------------------------------------
Below is the list of online tablespaces in this database which can
store temporary data (e.g. for sort workareas). Specifying the SYSTEM
tablespace for the user's temporary tablespace will result in the
installation FAILING, as using SYSTEM for workareas is not supported.
Choose the PERFSTAT user's Temporary tablespace.
TABLESPACE_NAME CONTENTS DB DEFAULT TEMP TABLESPACE
------------------------------ --------- --------------------------
TEMP TEMPORARY *
Pressing <return> will result in the database's default Temporary
tablespace (identified by *) being used.
Enter value for temporary_tablespace: temp
Using tablespace temp as PERFSTAT temporary tablespace.

... Creating PERFSTAT user
create user perfstat
*
ERROR at line 1:
ORA-01920: user name 'PERFSTAT' conflicts with another user or role name

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
Re: :x ORA-01920: user name 'PERFSTAT' conflicts with another user or role name :x [message #303360 is a reply to message #303352] Fri, 29 February 2008 00:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
To get a report you have to run spreport.sql.
spcreate.sql is for creating StatsPack environment.

Please read spdoc.txt in the same directory.

Regards
Michel
Re: :x ORA-01920: user name 'PERFSTAT' conflicts with another user or role name :x [message #303462 is a reply to message #303352] Fri, 29 February 2008 07:47 Go to previous messageGo to next message
orafan23
Messages: 13
Registered: December 2005
Junior Member
First drop the existing Perfstat user before running the spcreate again.There should be a script called spdrop.sql which would do this for you. Then run spcreate to create the statspack environment.once created login to perfstat and run the execute statspack.snap at different intervals and run spreport to see the statspack report.

Hope that helps.

Re: :x ORA-01920: user name 'PERFSTAT' conflicts with another user or role name :x [message #303464 is a reply to message #303352] Fri, 29 February 2008 07:53 Go to previous message
racman
Messages: 8
Registered: February 2008
Junior Member
Thanks guys!

Orafan! I ran the spdrop.sql and got the statspack report successfully.
Previous Topic: Seperate datafiles for tables in Same schema
Next Topic: drop partition slow
Goto Forum:
  


Current Time: Sat Dec 10 05:09:32 CST 2016

Total time taken to generate the page: 0.09072 seconds