Discussions
How to disable FLASH_CACHE DEFAULT.
How to disable FLASH_CACHE DEFAULT, when ever I created object it takes FLASH_CACHE DEFAULT value. There is no entry in spfile or pfile for this parameter so I can't alter parameter using .
We are not using Flash drive.
Using Oracle 11.2.3 Standard Edition, Windows 64.
example of Metadata of Table:
CREATE TABLE "X"."GEOPOLI_Test"
( "ID" NUMBER(*,0) NOT NULL ENABLE,
"IS_SYNONYM" CHAR(1),
CONSTRAINT "PK_GEOPOLITest" PRIMARY KEY ("ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 3145728 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "IAODBDATA25" ENABLE
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255