Unsolved
This post is more than 5 years old
46 Posts
0
848
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
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
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