RE: Freelist group setting
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: "veeeraman@xxxxxxxxx" <veeeraman@xxxxxxxxx>, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 7 Jun 2009 20:05:49 -0400
No, freelists/freelist groups do not apply if you're using ASSM.
________________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] On Behalf
Of Ram Raman [veeeraman@xxxxxxxxx]
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@SID<mailto:SYSADM@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@SID<mailto:SYSADM@SID>>
SYSADM@SID<mailto:SYSADM@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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
