SQL Performance (MOSC)

MOSC Banner

Poor queries performance / check storage clause of the table ?

edited May 23, 2013 5:14AM in SQL Performance (MOSC) 7 commentsAnswered
Hi ,

 I always have a disastrous execution time each time a DML relates to same table PRODUCTS !.

How can I check that does not come from storage clause of the table PRODUCTS itself ?


Which are the important points to check in a storage clause of a table or index ?

What others points to check related to storage ?

Thank you for help .

GD.

create table PRODUCTS
(
  NO_PARTITION      NUMBER(10) not null,
  -- Others columns ...
)
partition by range (NO_PARTITION)
(
  partition P_PART_1 values less than (1)
    tablespace TBS_DATA
    pctfree 25
    pctused 40
    initrans 1
    maxtrans 255
    storage
    (
      initial 40K
      next 1M
      minextents 1
      maxextents unlimited
      pctincrease 0

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center