RE: Freelist group setting
From: Bobak, Mark <Mark.Bobak_at_proquest.com>
Date: Sun, 7 Jun 2009 20:05:49 -0400
Message-ID: <6AFC12B9BFCDEA45B7274C534738067F164410F7_at_AAPQMAILBX02V.proque.st>
No, freelists/freelist groups do not apply if you're using ASSM.
From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] On Behalf Of Ram Raman [veeeraman_at_gmail.com] Sent: Sunday, June 07, 2009 19:58
To: ORACLE-L
Subject: Freelist group setting
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<mailto:SYSADM_at_SID>>
SYSADM_at_SID<mailto: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 20:05:49 -0400
Message-ID: <6AFC12B9BFCDEA45B7274C534738067F164410F7_at_AAPQMAILBX02V.proque.st>
No, freelists/freelist groups do not apply if you're using ASSM.
From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] On Behalf Of Ram Raman [veeeraman_at_gmail.com] Sent: Sunday, June 07, 2009 19:58
To: ORACLE-L
Subject: Freelist group setting
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<mailto: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<mailto:SYSADM_at_SID>>
SYSADM_at_SID<mailto: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 - 19:05:49 CDT