Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle Flash Cache

781089Aug 4 2010 — edited Jan 21 2011
Hi im using 11g/R2.

Could anyone point me in the direction of a simple tutorial for using oracle flash cache?

Any help would be appriciated

Comments

rui_catcuddler
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
rajeysh
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 
NS
What OS/version?
781089
im using Ubuntu 10.04lts
NS
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
rui_catcuddler
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
781089
sorry what is exadata? and why can't I implement flash cache using linux?
781089
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?
NS
It should automatically works provided you have OEL.
781089
ok, thanks, ,,,, last question...

im new to linux... how would I go about installing oel?
Aman....
user9200169 wrote:
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....
rui_catcuddler
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.
781089
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?
781089
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?
NS
Its Oracle Enterprise Linux. YOu can download from http://edelivery.oracle.com/.
rui_catcuddler
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
781089
why can't i use it on ubuntu??
781089
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?
781089
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?
781089
I have been to this site and registered, but can't see OEL on the download list.??!

Can someone plzzzz help me!
Sam R. Alapati
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
1 - 21
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 18 2011
Added on Aug 4 2010
21 comments
2,648 views