Database Tuning (MOSC)

MOSC Banner

a question on about DBLINK

edited May 17, 2012 2:35PM in Database Tuning (MOSC) 2 commentsAnswered

DB1: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0
DB2: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0
there is a table named PROD_INST that has one hundred million rows on DB1:
-- Create table
create table PROD_INST
(
PROD_INST_ID NUMBER(12) not null,
PRODUCT_ID NUMBER(12),
ACC_PROD_INST_ID NUMBER(12),
ADDRESS_ID NUMBER(12),
OWNER_CUST_ID NUMBER(12),
PAYMENT_MODE_CD VARCHAR2(6),
PRODUCT_PASSWORD VARCHAR2(30)
)
tablespace TBS_DATA_GC
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
-- Create/Recreate indexes
create UNIQUE index PK_PROD_INST on PROD_INST (PROD_INST_ID)
tablespace TBS_DATA_GC
pctfree 10
initrans 2
maxtrans 255

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