Database Software

http://www.dba-oracle.com/t_flash_cache.htm

http://blogs.sun.com/BestPerf/entry/oracle_flash_cache_sga_caching

http://guyharrison.squarespace.com/blog/2009/11/24/using-the-oracle-11gr2-database-flash-cache.html

should get you started

http://www.google.com/search?q=++Oracle+Flash+Cache++in+11gR2&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:unofficial&client=iceweasel-a

Total Questions: 11 (10 unresolved)

Posters, please mind these common-sense rules when participating here:

- When asking a question, provide all the details that someone would need to answer it. Consulting documentation first is highly recommended.
- When answering a question, please be courteous and respectful; there are different levels of experience represented here. A poorly worded question is better ignored than flamed - or better yet, help the poster ask a better question.
- It is considered good etiquette to reward answerers with points (as "helpful" - 5 pts - or "correct" - 10pts).
- See more tips in the FAQ

Thanks for doing your part to make this community as valuable as possible for everyone!

- OTN 

What OS/version?

im using Ubuntu 10.04lts

Not possible on this platform.

It is specifically designed for Exadata for now, with a backport you can run it with OEL.

For more info - http://guyharrison.squarespace.com/blog/2009/11/24/using-the-oracle-11gr2-database-flash-cache.html

HTH

uhhh...

there is the database flash cache which can be "managed"/implemented (as Guy Harrison's post shows) as opposed to the exadata one which is out of our control

Edited by: rui_catcuddler on Aug 4, 2010 12:05 PM

sorry what is exadata? and why can't I implement flash cache using linux?

so is it as simple as downlaoding and runnign the following patch:

8974084:META BUG FOR FLASH CACHE 11.2PL BUGS TO BACKPORT TO 11.2.0.1 OEL

Than specifying the flash DB_FLASH_CACHE_FILE and DB_FLASH_CACHE_SIZE.

Then it should automatically work??

is this correct?

It should automatically works provided you have OEL.

ok, thanks, ,,,, last question...

im new to linux... how would I go about installing oel?

Start from here,
http://www.oracle.com/technology/tech/linux/install/index.html

HTH
Aman....

this presupposes that you have some sort of flash technology in the server for this to work.... this is an advanced feature so you need to make sure that you have everything in place for this to work.

iv just had a look at the link you posted, however it appears to be a list of guides for installing oracle on linux...

I already have 11g/r2 installed on ubuntu 10.04lts...

So what exactly am i suppost to be looking for?

I have a flash drive mounted on the server yes ... i have been using it for various oracle tests, (mainly storing tablespeaces)

I want to test flash cache, but im unsure about what OEL is and how I would go about installing it?

Its Oracle Enterprise Linux. YOu can download from http://edelivery.oracle.com/.

oel - Oracle Enterprise Linux (essentially RedHat rejigged with Oracle extensions)

it's a whole new operating system and that patch is specific to the OS - you can't use it on Ubuntu...

So you would have to install that OS, install the oracle software, install that patch, then build your db and play around with that parameter.

Edited by: rui_catcuddler on Aug 4, 2010 1:07 PM

why can't i use it on ubuntu??

installing another version of oracle on my ubuntu server is not optional, ... I have no more space available.

Is it possible to install on Windows?

So your saying I would have to install OEL an entire new OS

Then install 11g/r2 on OEL

Then Patch

Then mount the SSD

And only then I can use flash cache?

I have been to this site and registered, but can't see OEL on the download list.??!

Can someone plzzzz help me!

Oracle Database Smart Flash Cache is available on two platforms right now: Solaris and Oracle Linux.

This is available only in the Oracle Database 11.2 release and in order to use the feature, you'd need flash storage devices, such as the Sun Storage F5100 Flash Array or the Sun Flash Accelerator F20 PCIe card. You can use ASM to manage the devices if you wish.

Thanks! Sam

Sam R. Alapati
samalapati@yahoo.com