Oracle 11g - Statspack installation issue.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Oracle 11g - Statspack installation issue.

  1. #1
    Join Date
    Mar 2010
    Location
    Los Angeles
    Posts
    20

    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 ?

  2. #2
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    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.

  3. #3
    Join Date
    Mar 2010
    Location
    Los Angeles
    Posts
    20
    hi,
    By adding 100M datafile on TBS2 tablespace solved this issue.

  4. #4
    Join Date
    Mar 2010
    Location
    Los Angeles
    Posts
    20
    Quote Originally Posted by vnktummala View Post
    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 ......

  5. #5
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    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.

  6. #6
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    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.

  7. #7
    Join Date
    Mar 2010
    Location
    Los Angeles
    Posts
    20
    Quote Originally Posted by vnktummala View Post
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width