Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

Discussions

How to disable FLASH_CACHE DEFAULT.

edited Jan 23, 2018 4:01AM in Database Install/Upgrade/Opatch (MOSC) 2 commentsAnswered

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

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.

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center