|
cell flash cache read hits vs. cell writes to flash cache statistics on Exadata
-
tanelpoder.com
-
12 years ago
-
eng
When the Smart Flash Cache was introduced in Exadata, it was caching reads only. So there were only read “optimization” statistics like cell flash cache read hits and physical read requests/bytes optimized in V$SESSTAT and V$SYSSTAT (the former accounted for the read IO requests that got its data from the flash cache and the latter ones accounted the disk IOs avoided both thanks to the flash cache and storage indexes). So if you wante....
|
|
cell flash cache read hits vs. cell writes to flash cache statistics on Exadata
-
tanelpoder.com
-
12 years ago
-
eng
When the Smart Flash Cache was introduced in Exadata, it was caching reads only. So there were only read “optimization” statistics like cell flash cache read hits and physical read requests/bytes optimized in V$SESSTAT and V$SYSSTAT (the former accounted for the read IO requests that got its data from the flash cache and the latter ones accounted the disk IOs avoided both thanks to the flash cache and storage indexes). So if you wante....
|
|
This is the start of a three series blog post that I will write over Google's augmented reality game. If you are not aware of this game, I'd recommend reading the Wikipedia entry over the subject, then return back to this post. This post is very
|
|
Letting PHP know that its connection behind NGINX is over HTTPS
-
thomashunter.name
-
12 years ago
-
eng
|
Update 2019-07-17: I have released a follow up post Go Binary Sizes Are Relatively Stable which speaks on what's happened in the time since this was published. Note: This is not intended as a "Go Sucks" post. I love Go. I am not saying the developers are lazy or dumb or any of the things Reddit has implied. I am not implying I could build a better compiler. Rob Pike and the Go team are geniuses whom I look up to. The tone o....
|
Update 2019-07-17: I have released a follow up post Go Binary Sizes Are Relatively Stable which speaks on what's happened in the time since this was published. Note: This is not intended as a "Go Sucks" post. I love Go. I am not saying the developers are lazy or dumb or any of the things Reddit has implied. I am not implying I could build a better compiler. Rob Pike and the Go team are geniuses whom I look up to. The tone o....
|
|
Using LinqPad to query Azure Diagnostics (Best WAD viewing client for Devs imo)
-
blog.gripdev.xyz
-
12 years ago
-
eng
Hi All, Really quick and simple post. In a normal windows azure cloud service you get all your lovely eventlogs put into table storage for you to use when diagnosing issues. Unfortunately that can be a bit daunting as there isn’t, or I didn’t think there was, a handy client to view them all in. With the AzureTableStorage driver for LinqPad I can quickly write complex and simple queries to integrate all the WAD logs and I get lovely in..
|
|
Lean thinking describes seven classical sources of waste ç„¡é§„: Overproduction: Making stuff that nobody buys Over-processing: Creating stuff that is more fancy than what the customer wants Transport: Moving stuff from one place to another in order to create it or give it to a customer Motion: Expending unneeded effort while creating stuff Defects: Having to redo work because it wasn’t done right the first time Inventory: Storing stuff wai..
|
|
I’ve been using a Kindle for a long time now, and I love it. But I keep buying paper books. Lots of them. Actually I buy a lot more books than ebooks and it doesn’t even stop there. Admittedly, I am guilty of repeatedly buying paper editions of ebooks I’ve read on the Kindle. For a very long time I’ve not been able to tell the precise reason why I keep going back to traditional books. It’s not about the reading experience or the sexines..
|
|
Tips for assembling the O2 (Objective2) Headphone Amplifier Kit
-
thomashunter.name
-
12 years ago
-
eng
|
|
For a while I’ve been meaning to do some more advanced posts on optimization problems of all flavors. One technique that comes up over and over again is Lagrange multipliers, so this post is going to be a leisurely reminder of that technique. I often forget how to do these basic calculus-type things, so it’s good practice. We will assume something about the reader’s knowledge, but it’s a short list: know how to operate with vectors and the ..
|
|
For a while I’ve been meaning to do some more advanced posts on optimization problems of all flavors. One technique that comes up over and over again is Lagrange multipliers, so this post is going to be a leisurely reminder of that technique. I often forget how to do these basic calculus-type things, so it’s good practice. We will assume something about the reader’s knowledge, but it’s a short list: know how to operate with vectors and the ..
|
|
For a while I’ve been meaning to do some more advanced posts on optimization problems of all flavors. One technique that comes up over and over again is Lagrange multipliers, so this post is going to be a leisurely reminder of that technique. I often forget how to do these basic calculus-type things, so it’s good practice. We will assume something about the reader’s knowledge, but it’s a short list: know how to operate with vectors and the ..
|
|
This post also applies to non-Exadata systems as hard drives work the same way in other storage arrays too – just the commands you would use for extracting the disk-level metrics would be different. Scroll down to smartctl if you wan’t to skip the Oracle stuff and get straight to the Linux disk diagnosis commands. I just noticed that one of our Exadatas had a disk put into “predictive failure” mode and thought to show how to measure w....
|
|
This post also applies to non-Exadata systems as hard drives work the same way in other storage arrays too – just the commands you would use for extracting the disk-level metrics would be different. Scroll down to smartctl if you wan’t to skip the Oracle stuff and get straight to the Linux disk diagnosis commands. I just noticed that one of our Exadatas had a disk put into “predictive failure” mode and thought to show how to measure w....
|
|
Bitcoin — the decentralized digital currency — has been making a lot of headlines lately. Much of this is driven by the current investment boom around it that has raised the exchange rates over the 1000 USD mark. But really, looking at Bitcoin as a medium for currency or asset speculation is a bad idea. Instead, we should see it purely as a medium of exchange . Not a great holder of value Much of the press stories about Bitcoin see....
|
|
Long story short, I scored a free SGI Fuel computer along with the SGI Origin 300 computer I described two posts ago. But the SGI Fuel is a much more “usable” computer because it is a powerful single-processor graphical desktop computer (what Silicon Graphics was best known for). Here is what it comes with: 4GB RAM 600MHz R14000A MIPS CPU (64-bit) Two SCSI hard disks DVD writer Odyssey video card (DVI) that takes up the entire bottom ..
|
|
Long story short, I scored a free SGI Fuel computer along with the SGI Origin 300 computer I described two posts ago. But the SGI Fuel is a much more “usable” computer because it is a powerful single-processor graphical desktop computer (what Silicon Graphics was best known for). Here is what it comes with: 4GB RAM 600MHz R14000A MIPS CPU (64-bit) Two SCSI hard disks DVD writer Odyssey video card (DVI) that takes up the entire bottom ..
|
|
I’ve been looking for Java alternatives since my first days of Android development. I can’t say I don’t like Java. It’s a nice language, very easy to learn and pretty logical. But the lack of proper functional style constructions often inspires me to check what’s new in the field of JVM languages. So far I’ve tried (tried, I never learnt these languages properly): Mirah - a very nice Ruby-translated-to-Java language.
|
|
Bitcoin — the decentralized digital currency — has been making a lot of headlines lately. Much of this is driven by the current investment boom around it that has raised the exchange rates over the 1000 USD mark. But really, looking at Bitcoin as a medium for currency or asset speculation is a bad idea. Instead, we should see it purely as a medium of exchange . Not a great holder of value Much of the press stories about Bitcoin see....
|
|
While browsing for different breakout boards for the Rover I’ve discovered a nice little board that has a push button and logic pin to control a MOSFET. This little contraption allows switching on and off the power, say through a USB cable.
|
|
I’ve been looking for Java alternatives since my first days of Android development. I can’t say I don’t like Java. It’s a nice language, very easy to learn and pretty logical. But the lack of proper functional style constructions often inspires me to check what’s new in the field of JVM languages. So far I’ve tried (tried, I never learnt these languages properly): Mirah - a very nice Ruby-translated-to-Java language.
|
|
Bitcoin — the decentralized digital currency — has been making a lot of headlines lately. Much of this is driven by the current investment boom around it that has raised the exchange rates over the 1000 USD mark. But really, looking at Bitcoin as a medium for currency or asset speculation is a bad idea. Instead, we should see it purely as a medium of exchange . Not a great holder of value Much of the press stories about Bitcoin see....
|
|
So I did a presentation on Information Security at University today. I think it went rather well, however I couldn’t show a couple of the demonstrations due to some SkyDrive files only being available online. That sucked because those were my best demonstrations, but overall I was happy. A few peopl...
|
|
So I did a presentation on Information Security at University today. I think it went rather well, however I couldn’t show a couple of the demonstrations due to some SkyDrive files only being available online. That sucked because those were my best demonstrations, but overall I was happy. A few peopl...
|
|
When do Oracle Parallel Execution Slaves issue buffered physical reads – Part 2?
-
tanelpoder.com
-
12 years ago
-
eng
In the previous post about in-memory parallel execution I described in which cases the in-mem PX can kick in for your parallel queries. A few years ago (around Oracle 11.2.0.2 and Exadata X2 release time) I was helping a customer with their migration to Exadata X2. Many of the queries ran way slower on Exadata compared to their old HP Superdome. The Exadata system was configured according to the Oracle’s “best practices”, that include..
|
|
When do Oracle Parallel Execution Slaves issue buffered physical reads – Part 2?
-
tanelpoder.com
-
12 years ago
-
eng
In the previous post about in-memory parallel execution I described in which cases the in-mem PX can kick in for your parallel queries. A few years ago (around Oracle 11.2.0.2 and Exadata X2 release time) I was helping a customer with their migration to Exadata X2. Many of the queries ran way slower on Exadata compared to their old HP Superdome. The Exadata system was configured according to the Oracle’s “best practices”, that include..
|
|
When do Oracle Parallel Execution Slaves issue buffered physical reads – Part 1?
-
tanelpoder.com
-
12 years ago
-
eng
This post applies both to non-Exadata and Exadata systems. Before Oracle 11.2 came out, it was true to say that Oracle Parallel Execution slaves always do direct path reads (bypassing buffer cache) when doing full segment scans. This should not be taken simplistically though. Even when you were doing full table scans, then yes the scanning was done with direct path multiblock reads – but if you had to visit other, additional blocks out ....
|
|
When do Oracle Parallel Execution Slaves issue buffered physical reads – Part 1?
-
tanelpoder.com
-
12 years ago
-
eng
This post applies both to non-Exadata and Exadata systems. Before Oracle 11.2 came out, it was true to say that Oracle Parallel Execution slaves always do direct path reads (bypassing buffer cache) when doing full segment scans. This should not be taken simplistically though. Even when you were doing full table scans, then yes the scanning was done with direct path multiblock reads – but if you had to visit other, additional blocks out ....
|
|
This is a presentation I recently gave to provide an overview of PostgreSQL and some of it's excellent features, including full-text search, multiple built in datatypes, data compression and extensions. Also, Morgan Freeman is narrating. You're welcome.
|
|
I love The Verge — I really do. Not long after posting Credibility and Bullies with Blogs , where I took Josh Topolsky to task for his wholly inappropriate reaction to many justifiable criticisms regarding his publication’s device reviews, I subscribed to The Verge. Today it not only serves as my primary news source, but I also follow The Vergecast and tune in for their live coverage of Apple’s events. Lately, however, I have been increa..
|