Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

flash cache initialization parameters

781089Aug 11 2010 — edited Aug 11 2010

Hi, i have recently got OEL patched up and running with a flash drive mounted on my system... I want to now have a play around with oracle flash cache...

I need to set the following params ... db_flash_cache_file and db_flash_cache_size

could anyone help me with the syntax to do so? is it something along the lines of

alter system set db_flash_cache_file ='/media/ssd/';

alter system set db_flash_cache_size ='xxgb??';

Any help would be appriciated

for example, I have tried ...

SQL> alter system set db_flash_cache_file ='/media/ssd/';
alter system set db_flash_cache_file ='/media/ssd/'
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified

Edited by: user9200169 on Aug 11, 2010 9:50 AM

This post has been answered by ap on Aug 11 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 8 2010

Added on Aug 11 2010

#general-database-discussions

56 comments

5,789 views