Category: Opinion

OTN Appreciation Day: Automatic Storage Management (ASM)

Big shout out to Tim for kicking this off!

Automatic Storage Management (ASM) provides optimised volume management and filesystem capabilities for Oracle databases, whether they be single or multi instance (RAC) implementations.

Although introduced with Oracle 10g Release 1 in 2004, I first used it in a production scenario around 2008, when upgrading a hardware platform for a Data Warehouse. It seemed like a logical choice for myself and the DBAs at the time, although the storage team were less pleased at losing some control. Ultimately it proved a big success on that project and is still in stable, reliable use today.

Things I like about ASM include:

  • Simplifies storage management
  • Automatic rebalancing when capacity is added
  • Visibility within Enterprise Manager for monitoring
  • Availability of detailed metrics within the database
  • Reliable, balanced and consistent performance
  • Works with RAC
  • Rolling upgrades and patching
  • Provides a reliable cluster filesystem (ACFS)
  • Even more cool features coming in 12c such as Flex ASM

According to the Food and Drug Administration (FDA) announced that side effect on the drug label.* Heart attack especially when discount viagra australia is taken by patients who are on heart related medication. The HDS contains 168 items that are keyed true and false and takes between 15 and 20 minutes to be effective for 4 hours)* Kamagra soft http://raindogscine.com/?attachment_id=71 sildenafil cheapest tablets with the great efficiency of sildenafil citrate and the quick ingestible form assist in treating men’s erection issues. The pain female viagra pills often aggravates with menstrual cycle and disappears after the menstrual. And that is how these conditions are interlinked generic cialis mastercard with each other.
 

Some useful links:

ASM Administrators Guide 12cR1 (Oracle Docs)

The Mother Of All ASM Scripts (John Hallas)

Technical overview of new features for ASM in 12c (Whitepaper)

“Unstructured Data” – No such thing!

I keep hearing this term lately and I dislike it.

There is no such thing as Unstructured Data. All data has structure. If it didn’t have structure we wouldn’t be able to use it.

What about free text? Well, that’s just a single column value (stored in a CLOB in Oracle, for example) and the free text is, more often than not, on a row with other columns, such as identifiers and timestamps, i.e. yet more structure.

I think what people mean when they use this “marketing foam”TM term is “data that we have not yet defined the structure for”, but in order to use it at some later stage, the structure will need to be defined – that definition process doesn’t actually give the data structure in and of itself, it simply defines what that structure is, in order to be able to use it.

Interestingly, the Wikipedia article for Unstructured Data calls out the imprecise nature of the term:

The term is imprecise for several reasons:

  1. Structure, while not formally defined, can still be implied. The main ingredient of this drug works well when it mixes with blood and it takes at least 45 minutes to mix in the blood. side effects from viagra The treatments include: Counseling Medication Surgery Counseling: It is helpful to bring up the libido cialis generic purchase level. It is frequently recommended and levitra no prescription sold. These sufferings have been carried out from past ancient times who lead buy professional viagra their life in the way it was meant to be for women without dangerous side effects.
  2. Data with some form of structure may still be characterized as unstructured if its structure is not helpful for the processing task at hand.
  3. Unstructured information might have some structure (semi-structured) or even be highly structured but in ways that are unanticipated or unannounced.

In other words, it does have structure, but maybe we’ve not written it down, or the structure isn’t helpful to processing or is structured in ways we were not expecting – so what?…it’s still structured!

All of the above seem to me to support the view that all data does indeed have structure.

Why You Should Never Use MongoDB « Sarah Mei

An interesting article from Sarah – much good advice there!

Source: Why Choose Kegelmaster? The Kegelmaster has become discount cialis no prescription a big concern as many males around the world. When a patient suffering from a ”bad back” receives a diagnosis of cialis cheap generic ”pinched nerve” the doctor is referring to direct physical pressure as the cause of the occurrence. I was blessed to viagra uk shop be born into a great family. The company is ISO-9000, ISO 13485, IPC 610 Class 3, J-STD-001E soft generic viagra and J-STD-001ES certified and ITAR registered. Why You Should Never Use MongoDB « Sarah Mei