Search

OakieTags

Who's online

There are currently 0 users and 22 guests online.

Recent comments

Affiliations

Uncategorized

Monitoring Application TCP traffic on Mac

viamoi

photo by Stuart Williams

My internet provider said my service was degraded due to the large amount of data uploading from my computer. As far as I knew, my computer wasn’t uploading anything but I didn’t know how to prove it.

I decided to try and write a DTrace program to look at it. (I also installed “Little Snitch” which seems pretty cool).

Importance of Feedback

4386925065_1ef4a396b8_z

photo by  Idaho National Laboratory

The human brain works so well because it calculates outcomes as it takes actions feeding back the current results compared to the expected results  which allows immediate corrections if the two are not aligning.

automate or die – the revolution will be automated

:mobilestreetlife_1

photo by David Blackwell.

The worst enemy of companies today is thinking that they have the best processes that exist, that their IT organizations are using the latest and greatest technology and nothing better exists in the field. This mentality will be the undermining of many companies.

Continuous Integration for Database Development

Below is a good presentation from Vladimir Bakhov that Dominic Delmolino pointed me to.
( Dominic just did a good presentation with Redgate on CI and TDD available at http://youtu.be/smkb4Sa54d0 )

Screen Shot 2013-12-26 at 10.48.45 AM

 

 

 

DataBase CI ENG

Christo Kutrovsky on Oracle, memory & Linux at Oaktable World 2013

Screen Shot 2013-12-23 at 3.46.31 PM

Christo Kutrovsky, from Pythian, gives an awesome talk at Oaktable World 2013 (see http://oaktableworld.com )

Dear Santa

dba_gitfts

 

Dear Santa,

It’s no secret that there are some tasks that overwhelm existing database architectures, making projects consistently come in over budget and overdue.  This holiday season, on behalf of Database Administrators everywhere, we’d like to ask Santa for:

  1. An end to the constant struggle for more and more disk space for databases and copies

  2. An army of smart elves to run and test backups

  3. Less dependence on physical/virtual administration and storage teams to create working environments for development and QA

The challenge of optimization

With every release of Oracle, more and more power comes to the optimizer.  Many of these are new features (such as adaptive cursor sharing, adaptive optimization, dynamic sampling, etc)…but also within the "core" of the optimizer, there are continuing efforts to transform and interrogate SQL’s to try derive a ‘smarter’ query and hence hopefully a smarter plan.

Its always a balancing act…how much can you re-jig a query without running the risk of actually changing what the query does…

Here’s an example of where that balance is slightly wrong in 12c

Data IS the constraint.

7557271168_41e1584f65_c

photo by David Blackwell

by Woody Evans

When the Oracle wait interface isn’t enough, part 2: understanding measurements.

In my blogpost When the oracle wait interface isn’t enough I showed how a simple asynchronous direct path scan of a table was spending more than 99% of it’s time on CPU, and that perf showed me that 68% (of the total elapsed time) was spent on a spinlock unlock in the linux kernel which was called by io_submit().

This led to some very helpful comments from Tanel Poder. This blogpost is a materialisation of his comments, and tests to show the difference.

First take a look at what I gathered from ‘perf’ in the first article: