Home » RDBMS Server » Performance Tuning » 0ra-1920
0ra-1920 [message #268875] Wed, 19 September 2007 23:56 Go to next message
anamika_025
Messages: 81
Registered: July 2007
Location: Indore
Member
hello all,


i have problem in run to statspack. i have a problem
ORA-01920: user name 'PERFSTAT' conflicts with another user or role name

and how to see the output of the statspack..

thanks and regards,
Anamika.
Re: 0ra-1920 [message #268878 is a reply to message #268875] Thu, 20 September 2007 00:01 Go to previous messageGo to next message
BlackSwan
Messages: 25037
Registered: January 2009
Location: SoCal
Senior Member
> i have a problem
I have a problem, I don't what who did what.
Please read & follow posting guidelines in #1 STICKY post at top of this forum and use CUT & PASTE!
Re: 0ra-1920 [message #268883 is a reply to message #268875] Thu, 20 September 2007 00:10 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
ORA-01920: user name 'PERFSTAT' conflicts with another user or role name



ORA-01920: user name 'string' conflicts with another user or role name

Cause: There is already a user or role with that name.

Action: Specify a different user name

or first drop already exist user.

Regards
Mohammed Taj
Re: 0ra-1920 [message #269189 is a reply to message #268883] Fri, 21 September 2007 01:02 Go to previous message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello anamika_025,

Please... read and apply Forum Guide.
Tell us what is your oracle version (4 decimals);
Tell us what is your OS version also.
http://www.orafaq.com/forum/t/88153/0/

Regarding ORA-01920... follows Taj suggestion.

Regarding statspack usage... I guess it is helpful to create a new tablespace for statspack data. And after all just drop the tablespace.
anamika_025 wrote:
and how to see the output of the statspack..
Use:
SQL> @?/rdbms/admin/spreport.sql


In oracle 10g... there is "awr" to consider.

Regards,


mson77

Previous Topic: About Bitmap Index
Next Topic: SQL Sharing Problem (STB_OBJECT_MISMATCH)
Goto Forum:
  


Current Time: Mon Dec 05 09:11:56 CST 2016

Total time taken to generate the page: 0.10196 seconds