| 0ra-1920 [message #268875] |
Wed, 19 September 2007 23:56  |
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 #269189 is a reply to message #268883] |
Fri, 21 September 2007 01:02  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
