Oracle SQL jumpstart Gavin Powell : very good

The book one shot with index block clears up my fuzzy and wrong concept about index; i know that index is stored in separate tablespace but showhow got an image that ordering index is same as ordering table :p.

The book one short with simple sentence clears up my concept about cursor, it just a memory to hold the querry data :p, much better than other books which cannot seem to give a clear and simple concept.

I am scanning the book because it is a reference book and got a lot of goodies.

scanning and detail reading is ying and yang

http://oracle-bubul.blogspot.com/2009/07/scanning-and-reading-in-detail-is-ying.html

Scanning and reading in detail is ying and yang

When you just start reading a book especially a big book, or tackle a complicated project. Always scan the book first, read it non sequentially back and front, front and back. Read only the part that you feel like needing to read or interest you. Only when you have get the overview picture of the book and feel you can go no more, then only you decide whether to read the book detailly and sequentially. Scanning a complex book prevent jamming when detail reading and memorizing.

Scanning the book is a necessary step. And reading the book detailly and memorizing is also a necessary step becasue without the details you cannot get the job done, there is too many things you are not familiar with. So both are needed, yin and yang.

Dont mix scanning and detail reading together.

It is better you read the end book first because you know where the goal is and know what to look in detail like scanning SQL tuning first before reading SQL book.

You will be facing a lot of sitatuion where the task is big and complex, use the ying and yang.

Exploration is linking things together

Grow a tree like crystal.

Read on the internet or book the metaphorming process by Todd Siler

Programming is much more fun than database administration

Much much more fun, it is almost like a spiritual practice making pottery.

My new direction

Now my new direction is to fully understand Oracle in aspect of SQL tuning. Memorizing for OCA admin is pointless and cannot produce at work, plus it doesn't bring excitement which makes Oracle great.

Oracle gives positivity

Today i read the positivity book by Barbara Fredrickson and i think have something to look forward to is the best way to increase positivity, instead of mindfulness, or gratitude.

Oracle always offers endless novelty, excitement, trill of conquest when found new book in its land of oz.

We are always more inspired by novelty instead of gratitude for the usual. That is why xbox is more effective than prayer or gratitude, and why Oracle is better than Xbox.

Two SQL books that may save my Oracle career

That SQL performance tuning book by Peter Gulutzan and SQL tuning by Dan Tow, the prose just sucks, cant explain things clearly.

I found two Oracle SQL tuning book which is probably much better:

Oracle Performance Tuning for 10gR2, Second Edition by Gavin JT Powell

Oracle SQL High-Performance Tuning by by Guy Harrison

Edit 28 July
The Oracle Performance Tuning for 10gR2, and Oracle SQL:jumpstart by Example by Gavin JT Powell probably saved my Oracle life.

Disovered them on 27 July 2009, and coincidentally my self motivation poster is on this date to take the OCA exam. I will later attach a photo.

I might buy a Palm Tunsten T3 to read the two great books.

Probably the best PLSQL and SQL book

Rampant press has produced a few probably best oracle books that explains concepts intuitively:

Easy Oracle PL/SQL Programming: Get Started Fast with Working PL/SQL Code Examples (Paperback)

by John Garmany


This book is probably much better than PLSQL for dummies or the online manual. I am getting a copy from Amazon. Sample can find in google books.

Easy Oracle SQL: Get Started Fast Writing SQL Reports with SQL*Plus (Paperback)

by John Garmany

This book is probably better than head first SQL.

Focus on SQL tuning now

After understanding most of the material for OCA, and now halfway in memorizing, i took a look at Oracle SQL tuning books to relieve my monotomy, and noticed that my Oracle understanding is still quite low.

I am mainly interested in tuning, like tuning a racecar or tuning a strategy game.

Now i know if i got OCA i still dont have the competency, thus now i will focus to understand how oracle works by going into SQL tuning.

PLSQL is just a language can be easily learned, can do it later. Most important is SQL tuning.

SQL tuning by Dan Tow

Bought the book after 1 hour search!

Looks like a great book that gives you a map to understand how querrying works, and gives you steering wheel to drive.

From the book

Here is an analogy that works pretty well. Understanding the first step gives you a clear windshield; you know where you are. Understanding the second step gives you a working steering wheel; you can go somewhere else. Understanding the third step gives you a map, with marks for both where you are and where you want to be.


Upload to freedrive.com

ordering Oracle Performance Tuning 101

From amazon today!

Finding a good book brings controls back into life!!!! SQL Performance Tuning

I was reading Niemic Oracle performance tuning tips book, really lost hope in becoming a oracle tuning expert, the book was long winded, showing a little piece here a little piece there without introducing a overall tuning concept.
Same opionion here:
http://www.dbasupport.com/forums/archive/index.php/t-35457.html

Then read oracle wait interface, by the author of Oracle performance tuning 101, also long winded, a little bit here, a little bit there, got really desperate. Is Oracle performance tuning 101 the same thing?

Couldn't get Oracle performance tuning 101 in singapore library or kinokuniya, must buy from amazon.

Then searching searching in Amazon, reading reviews. Checking out free ebooks. Then finally found this book:

SQL Performance Tuning (Paperback)

by Peter Gulutzan

Peter Gulutzan (Author)

› Visit Amazon's Peter Gulutzan Page

Find all the books, read about the author, and more.

See search results for this author

Are you an author? Learn about Author Central

(Author), Trudy Pelzer (Author)


The first few page immediately it builds the important concept, immediately things becomes clear, logic brought into chaos, chaos subdued and order emerged.

Actually to become successfully in life, is to bring order into chaos. To be more successful is to bring more order into chaos.

Reading this book bring back life, bring back order, bring back excitement, and hope into life, it is like holding a big toy in my hand that will dispel anxiety and boredom. Getting good books is very important.




Found this book today at approximately 12 am July 05. Uploaded pdf copy to freedrive.com. Order book from singapore library.

When i read this in the book immediately i have a very good impression

Everybody has heard of sluggish SQL queries, or even whole systems, that a heroic someone improved with small effort. Usually the improvement is small too, so we will avoid extravagant promises. But we will make you the following guarantees.

You will be able to follow our arguments without deep thinking or hard work. All we assume is that you have basic knowledge of programming

and standard SQL syntax. In fact, you can read this book on a plane or at the beach.

All of our observations have been confirmed by tests on real DBMSs within the last several months.

We know that "optimizing" is very different from "over-clocking," and we only discuss safe, rational, relational techniques.

Edit: July 08,09

Wow, at first i find the second chapter of the book difficult to read, transivity and all, but after the 3rd reading at zzz lunchtime, wow it is a damn good book, very logical and straightforward:

"

Specific Tuning To this point, we've talked about general tuning of search conditions. Now we'll look at how you can improve your code using specific SQL operators. AND When everything else is equal, DBMSs will evaluate a series of ANDed expressions from left to right (except Oracle, which evaluates from right to left when the cost-based optimizer is operating). No rule says they must—that's just what they do. You can take advantage of this behavior by putting the least likely expression first or—if both expressions are equally likely—putting the least complex expression first. Then, if the first expression is false, the DBMS won't bother to evaluate the second expression.

"


"

For this kind of statement, we believe the essential question is—Should there be an index on column1? So we've devoted a whole chapter to the subject of indexes—what they look like, what variations exist, how indexes affect data changes, and so on. In another chapter, we address the question of how to use EXPLAIN (or its equivalent) to find out whether your particular DBMS actually uses an index for a particular SELECT. That illustrates our priority—we think that the first priority is the concept: indexes. Certainly, though, we must also care about the method: diagnostic tools. We hope that, with the concepts firmly planted in your mind, you will quickly arrive at the right point. We don't recommend that you implement any idea in this book without testing it first—but without ideas, you'll flounder randomly between plans without knowing if your final choice really is the best one."

How i got hots on Oracle RAC

saw this picture the other day, now my wallpaper. It is the internet, looks eerily like the brain, fratalness of the universe.

Few days later I eerrily got interested in Oracle real application cluster

Knowledge is like a tree. The more you link the tree up, the more godlike and happier you are.