A brief discussion on Oracle ASM and some of its advantages over other file systems.
Notes:
Data, the Cloud and other thoughts.
A brief discussion on Oracle ASM and some of its advantages over other file systems.
Notes:
If you are having trouble getting your head around the basics of Oracles Architecture, this video does a good job of simplifying things and making it easy to remember by breaking it down and describing it via everyday examples. You can skip to around 2:30 for the real start of the video.
Notes;
Notes:
Data appliance
Exadata offloads work to its storage servers which reduces the data that needs to travel over the network to the database servers.
This is a great discussion on and around Oracle Exadata by 2 performance tuning experts.
Notes:
There is always faster hardware.
Smartscan.
Most apps do more than the business need requires. Giving more data to the user or carrying more data than is needed through the calulations
Filter earlier to reduce unwanted work.
Pushing that sort of work down to the hardware level makes things much faster.
Big pipe between the storage and the db buffer cache.
Difficult to predict how fast an exadata machine will perform a particular opperation because there are ahost of features that kick in at particular times.
Inconsistency in execution times can vary a lot especially before a system gets up to speed.