Oracle Partitioning Choices/Strategies

Partitioning in Oracle(live blog-growing with me)

Single-Level Partitioning

• Range- if data can be divided into ranges eg. 0-100, 100-200 and so on. Important thing is the access by queries, to take advantage of partition pruning or partition level access.
• Hash- Lot of data and I know the columns frequently used to access but data doesn't fit in type of range or list.. I this case just divide the total data  into finite partitions(10,20 or more), generally would depend on size of the table and system performance. To start 100k per partition you can start with. Need to experiment  a little bit to get to a optimal number.
• List- Lot of data but can be divided  per list eg. Finite list of zip codes, regions, types etc. Other criteria still apply like access by list of values and quantity of data.

Composite Partitioning: or sub partition is again another way to divide the data into further smaller manageable pieces and improve access speed to get required data as quickly as possible using partition keys and other required conditions. 

• Composite Range-Range Partitioning
• Composite Range-Hash Partitioning
• Composite Range-List Partitioning
• Composite List-Range Partitioning
• Composite List-Hash Partitioning
• Composite List-List Partitioning
• Composite Hash-Hash Partitioning
• Composite Hash-List Partitioning
• Composite Hash-Range Partitioning

Considerations:

1. Size of table and number of rows.
2. Queries accessing the table and their frequency, specifically the conditional clause. to take advantage of partition pruning.
3. Can application/queries be  modified to take advantage of partitioning.
4. Any retention plan for the data/maintainence of data.

Important Consideration for Vendor Software(Oracle EBS Suite/Sieble/etc)

• Evaluation of partition, if it can be done from vendor(warranty consideration).
• Approval must from vendor for warrenty reasons.
• Safer to attempt only for custom objects.
• Better ask than be sorry later, always ask vendor, is it do-able or are there any concerns. Vendor has experience dealing with multiple customers, they are in better position to confirm than any of us,

Operations:

http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/Partitioning/12c_parti.html

Google Home in India- It works in India

Google Home -It works in India     (Launched in India on flipkart )

Installed google home few months back and BOY!!!! I am happy with it.

It my first device that's futuristic, take command and does it flawlessly(mostly) with whatever features are available in india.

Why have it?, here are the reasons if you are thinking of any thing similar:
1. It works on Voice commands like 'Ok google or Hi Google (would luv to have custom call like a petname or something, maybe in future. I like googlee 😊😊😊😊)

2. Configured and subscribed to google music : Any song/bhajan/etc is just a shout out away eg: Ok google  play Arijit songs ...it start playing. This probably is the most utilized feature at my place.

3. Ask any question, it responds almost immidiatlely and apologises if can't. Most of the time rephrase the question and would get a response. Lot wiki responses though, which I like.

4. Kids play games(trivia)/music and ask random questions and never been disappointed.

Pluses:

• Intiuitive
• Response is always quick but dependent on wifi
• Sound quality is awesome-don't miss my home theater, amazing for the size the device is.
• Configuration is very easy, mobile app is used to configure it.
• Touch control in addition to voice command very helpful.
• if you have chrome cast device(TV/dongle/etc), google home can control it.
• Google Music collection is awesome and compliments this device very well.

Minus:

• No calling feature at the moment in India-WANT IT!!!!!
• Not many devices available that can be controlled and are inexpensive-still exploring (More on this later)
• No internal battery-can carry to a place without power source.(No much of a deterrent though)

If you are plugged into android/googel ecosystem and this is a good device to have, otherwise GET STARTED!!!!