?
Solved

More and More migrated and chained rows

Posted on 2005-03-31
3
Medium Priority
?
307 Views
Last Modified: 2006-11-18
I have created a locally managed tablespace and then created a table.
Its have more than 5 millions chained rows.It is going on increasing every day.
Please give me some suggestion.
I think I the table is not correctly created with good space.
I am attaching the script how I have created the tablespace and the table.


CREATE TABLESPACE COMM DATAFILE
  '/oradata/pecom/db4/pecom01.dbf' SIZE 2100M AUTOEXTEND OFF,
  '/oradata/pecom/db1/pecom02.dbf' SIZE 1500M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M,
  '/oradata2/pecom/db6/pecom03.dbf' SIZE 1500M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M,
  '/oradata2/pecom/db7/pecom04.dbf' SIZE 1500M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M,
  '/oradata/pecom/db4/pecom05.dbf' SIZE 1500M AUTOEXTEND OFF
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO;

-----------------------------------------------------------------------

CREATE TABLE VOTE_TODAY
(
  AGENDA_NBR             CHAR(9 BYTE)           NOT NULL,
  PROPOSAL_NBR           NUMBER(3)              NOT NULL,
  VOTE_GROUP_ID          NUMBER(10)             NOT NULL,
  SHARES_FOR             NUMBER(17,5),
  SHARES_AGAINST         NUMBER(17,5),
  SHARES_ABSTAIN         NUMBER(17,5),
  SHARES_TNA             NUMBER(17,5),
  SHARES_MEETING_ATTEND  NUMBER(17,5),
  CREATED_ON             TIMESTAMP(6)           NOT NULL,
  CREATED_BY             CHAR(18 BYTE)          NOT NULL,
  MODLAST_ON             TIMESTAMP(6),
  MODLAST_BY             CHAR(18 BYTE)
)
TABLESPACE PECOM
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            MINEXTENTS       1
            MAXEXTENTS       2147483645
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
LOGGING
NOCACHE
NOPARALLEL;
Please suggest.



0
Comment
Question by:ballioballi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 25

Accepted Solution

by:
jrb1 earned 2000 total points
ID: 13674542
I'd recommend:

1) analyze table vote_today compute statistics;

2)

select least(round(100-((2*avg_row_len)/(8096/10))),95) pctused
,greatest(round((2*avg_row_len)/(8096/10)),5) pctfree
from dba_tables
where table_name = 'VOTE_TODAY';


3) Use the first value for your pctused, the second for pctfree.

alter table vote_today pctused #newnum1 pctfree #newnum2;

4) Probably want to do something to reorg the table.
0

Featured Post

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question