-
Oracle 11g - Statspack installation issue.
1) Created a tablespace and named it as TBS2.
SQL> create tablespace TBS2
2 datafile 'C:\app\test\admin\dba\Datafile\data1.dbf'
3 size 100m;
create tablespace TBS2
2)Executed the spcreate.sql script to create statspack report.
SQL> @C:\app\test\product\11.1.0\db_1\RDBMS\ADMIN\spcreate.sql
3)PERFSTAT user password : perfstat
4)Default tabelspace name to store statspack report : TBS2
5) Enter the value of Temp tabelspace : TEMP
6) Statspack report started generating.
7) The report failed due to following reason.
create table STATS$FILE_HISTOGRAM
*
ERROR at line 1:
ORA-01659: unable to allocate MINEXTENTS beyond 7 in tablespace TBS2.
May i know what is the reason for the failure ?
-
ERROR at line 1:
ORA-01659: unable to allocate MINEXTENTS beyond 7 in tablespace TBS2.
add more space to the table space TBS2.
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
Originally Posted by vnktummala
add more space to the table space TBS2.
Thanks,
Could you please tell me what is the meaning for the error message ???
I initially thought that something to do with Minextent configuration ......
-
By adding 100M datafile on TBS2 tablespace solved this issue.
your solution tells you the meaning of the error ... No required space is available in the table space to create the new objects.
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
just curious to know, why are you configuring statspack in 11G???
why don't you use AWR & ADDM??
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
Originally Posted by vnktummala
just curious to know, why are you configuring statspack in 11G???
why don't you use AWR & ADDM??
Thanks,
I am new to Oracle 11g and i am just exploring it ...
I will also go through AWR & ADDM .....
Thanks buddy for your help
-
hi,
By adding 100M datafile on TBS2 tablespace solved this issue.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|