Freelist group setting
From: Ram Raman <veeeraman_at_gmail.com>
Date: Sun, 7 Jun 2009 18:58:16 -0500
Message-ID: <effc058d0906071658q7097d416h52062e502a04c5bd_at_mail.gmail.com>
Hi,
CREATE INDEX "SYSADM"."PS_PSACCESSLOG" ON "SYSADM"."PSACCESSLOG" ("OPRID", "LO
GIPADDRESS", "LOGINDTTM")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 40960 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "PSINDEX" SYSADM_at_SID>
SYSADM_at_SID> select dbms_metadata.get_ddl('TABLESPACE','PSINDEX') from dual; more..
DBMS_METADATA.GET_DDL('TABLESP
CREATE TABLESPACE "PSINDEX" DATAFILE
'+INDEX/SID/datafile/psindex1' SIZE 8589934592
AUTOEXTEND ON NEXT 5242880 MAXSIZE 32767M,
'+INDEX/SID/datafile/psindex2' SIZE 8589934592
AUTOEXTEND ON NEXT 5242880 MAXSIZE 32767M,
'+INDEX/SID/datafile/psindex3' SIZE 8589934592
AUTOEXTEND ON NEXT 5242880 MAXSIZE 32767M,
'+INDEX/SID/datafile/psindex4' SIZE 8589934592
AUTOEXTEND ON NEXT 5242880 MAXSIZE 32767M LOGGING ONLINE PERMANENT BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO ALTER DATABASE DATAFILE
'+INDEX/SID/datafile/psindex1' RESIZE 21361590272
ALTER DATABASE DATAFILE
'+INDEX/SID/datafile/psindex2' RESIZE 21141389312
ALTER DATABASE DATAFILE
'+INDEX/SID/datafile/psindex3' RESIZE 21188575232
ALTER DATABASE DATAFILE
'+INDEX/SID/datafile/psindex4' RESIZE 21167603712
Date: Sun, 7 Jun 2009 18:58:16 -0500
Message-ID: <effc058d0906071658q7097d416h52062e502a04c5bd_at_mail.gmail.com>
Hi,
We are moving from single node to RAC on a 10g database that runs peoplesoft 10.2. They are on different hardware plaforms. I extracted the ddls for creating tablespaces from the old single isntance server to the new RAC server. I have attached one sample index below. Do I need to worry about the freelist, freelist group setting, given that that the tablespaces use ASSM:
1* select dbms_metadata.get_ddl('INDEX','PS_PSACCESSLOG') from dual
SYSADM_at_SID> /
more..
DBMS_METADATA.GET_DDL('INDEX',
CREATE INDEX "SYSADM"."PS_PSACCESSLOG" ON "SYSADM"."PSACCESSLOG" ("OPRID", "LO
GIPADDRESS", "LOGINDTTM")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 40960 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "PSINDEX" SYSADM_at_SID>
SYSADM_at_SID> select dbms_metadata.get_ddl('TABLESPACE','PSINDEX') from dual; more..
DBMS_METADATA.GET_DDL('TABLESP
CREATE TABLESPACE "PSINDEX" DATAFILE
'+INDEX/SID/datafile/psindex1' SIZE 8589934592
AUTOEXTEND ON NEXT 5242880 MAXSIZE 32767M,
'+INDEX/SID/datafile/psindex2' SIZE 8589934592
AUTOEXTEND ON NEXT 5242880 MAXSIZE 32767M,
'+INDEX/SID/datafile/psindex3' SIZE 8589934592
AUTOEXTEND ON NEXT 5242880 MAXSIZE 32767M,
'+INDEX/SID/datafile/psindex4' SIZE 8589934592
AUTOEXTEND ON NEXT 5242880 MAXSIZE 32767M LOGGING ONLINE PERMANENT BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO ALTER DATABASE DATAFILE
'+INDEX/SID/datafile/psindex1' RESIZE 21361590272
ALTER DATABASE DATAFILE
'+INDEX/SID/datafile/psindex2' RESIZE 21141389312
ALTER DATABASE DATAFILE
'+INDEX/SID/datafile/psindex3' RESIZE 21188575232
ALTER DATABASE DATAFILE
'+INDEX/SID/datafile/psindex4' RESIZE 21167603712
Thanks.
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Jun 07 2009 - 18:58:16 CDT