Oracle ILM Assistant

Teams..

Has anyone used the Oracle ILM Assistant to show customers the advantages of moving older, partitioned data to cheaper disk and realizing the cost benefits associated with that ?

It's a free tool from Oracle that allows values of the cost of different types of disk (SAS, SATA) to be plugged in that then generates a spreadsheet with approximate costs of different amounts of data on different types of disk

More info is available here

http://www.oracle.com/ocom/groups/public/@otn/documents/webcontent/261281.htm

Thanks

-Saty

Responses(2)

zhaos2

643 Posts

0

December 5th, 2012 18:00

Hi Saty, below the reply from some Oracle experts:

Answer 1:

Yes I did use it years ago. I am surprised this product is still alive and kicking?

At the time I used it – almost 3 years ago – it was more of a ‘documentation’/ theoretical product that had no bearing in executing of the policies.

Smiti

Answer 2:

I actually created a storage grid workshop for Oracle while I worked there - and using ilm assistant was part of that. Let me see if I can dig up the materials .... It would generate SQL to partition and move data. It did not actually execute the SQL. Like Smiti, I have not touched it for at least 3 years.

Jim Olsen

Answer 3:

Attached ppt is from the Oracle Storage Grid workshop.

Jim Olsen

Answer 4:

The obvious answer is that FAST VP will do it natively, and in both directions. For those that attended the last OOW you’ll recall that Oracle is taking a new approach on this subject

http://www.databasejournal.com/features/oracle/oracle-12c-new-features.html so investing in the old one is probably not a good strategy.

Dar Yaron

1 Attachment

03_ILM_assistant.zip

M

MacBookPro_9_2

46 Posts

0

December 10th, 2012 09:00

Thanks all..

The product is alive (like so many other Oracle features that were introduced earlier)..

I had thought about resecurrecting the Storage Grid workshop which we built (at the OSC) and have it setup as a 1 hour demo on demand in vLab perhaps, which could be used by Oracle specialists in the field to show the cost savings associated with having an algorithm like FAST VP move data to different tiers of disk, in addition to whiteboarding FAST VP for Oracle.

Do we have a tool from the EMC side which shows the movement of data from one tier to another ?

This would be for those customers that are still on older versions of the database, prior to 12c

Thanks

Saty

View All

No Events found!