8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Database Smart Flash Cache in Oracle Database 12c Release 1


Javid Hasanov said...

Dear Tim,
Great thanks to you for such interesting blog.
I just want to note that following syntax worked as expected for me.

alter system set DB_FLASH_CACHE_FILE='/mnt/vdisk1','/mnt/vdisk2' scope=spfile;

Best Regards.

Tim... said...

Hi.

I think the lack of single quotes in my ALTER SYSTEM statements was the issue. When I added them the stuff went into the SPFILE correctly (without them) and it worked fine. I've cleaned up the article. Thanks for the heads-up. :)

Cheers

Tim...

Marin Velichkov said...

Hi Tim,
I have one questions

What will happen in this case:
ALTER SYSTEM SET DB_FLASH_CACHE_FILE = '/mnt/vdisk1', '/mnt/vdisk2' SCOPE=SPFILE;
ALTER SYSTEM SET DB_FLASH_CACHE_SIZE = 1G SCOPE=SPFILE;
SHUTDOWN IMMEDIATE;
STARTUP;

Error or database will use only first device ?

Thanks
Best Regards.

Tim... said...

Hi.

I honestly can't remember. I would suggest you try it. If it fails to start the DB, just create a PFILE, alter the setting. Recreate the SPFILE and start the DB.

Cheers

Tim...

Marin said...

Hi Tim,
I test and don't work!

Best Regards.

Tim... said...

Hi.

Good to know. Thanks. :)

Cheers

Tim...

Ian Jones said...

This works in OEL7 as well once you apply patch number 19504946 as per Oracle Doc ID:2123908.1.

Tim... said...

Hi.

Thank for the heads-up. I've added that reference to the warning at the start. :)

Cheers

Tim...

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.