| Setting flash cache initialisation parameters [message #470980] |
Wed, 11 August 2010 13:39  |
dsub42
Messages: 72
Registered: April 2010
Location: uk
|
Member |
|
|
Hi could someone please help me to set up flash cache.,..
I have OEl 5.5 installed and patched.
I have my SSD mounted..
but when i ran the command 'alter system set db_flash_cache_file ='/media/ssd/' scope=spfile;'
.... I totally messed up my database, and It wouldn't startup giving ORA-01078: failure in processing system parameters...
I have now fixed this and am back to square one ...
Could someone plzzzz help me set up the initialisation params?
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Setting flash cache initialisation parameters [message #471263 is a reply to message #471051] |
Fri, 13 August 2010 01:49  |
John Watson
Messages: 8929
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Hi - did you get any further? What was the problem? Not many people have the opportunity to work with a flash cache, I for one would be interested to know your results. What performance did you get when comparing it to disc i/o? For instance,
select name,value from v$sysstat where name in ('physical read flash cache hits','flash cache inserts','physical reads','session logical reads');
select event,total_waits_fg,time_waited_micro_fg,time_waited_micro_fg / total_waits_fg from v$system_event where event in ('db flash cache write','db flash cache single block physical read','db flash cache multiblock physical read','db file sequential read','db file scattered read');
[Updated on: Fri, 13 August 2010 01:59] by Moderator Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
