Cute sunset created in studio... :)
what are we ? we are what we experience. And some more. I bring together here, collective experiences from different parts of life..
Wednesday, April 15, 2009
Tuesday, April 7, 2009
All about Dual Table : AskTom
A very very interesting article from AskTom on dual table, its purpose and usage and everything else about it...
Here's some excerpts from it, leaving the rest for reading...
Ask Tom "All about the DUAL table "
Here's some excerpts from it, leaving the rest for reading...
"DUAL is owned by SYS. SYS owns the data dictionary,More
therefore DUAL is part of the data dictionary. You are not to modify the data dictionary
via SQL ever -- wierd things can and will happen"
the optimizer understands dual is a magic, special 1 row table. It stopped on theRead the rest of article here...
select * because there is to be one row in there. Its just the way it works.
Ask Tom "All about the DUAL table "
Blogged with the Flock Browser
Oracle SQL tuning - Burleson Consulting
Burleson Consulting website has come to rescue in many situations. For many questions their site provides great pointers and ideas.
Here's a series of papers/articles on Oracle SQL Tuning -
Oracle SQL tuning parameters
And, here's an article on tuning of individual SQL Statements -
Tuning Individual SQL Statements
Here's a series of papers/articles on Oracle SQL Tuning -
Oracle SQL tuning parameters
And, here's an article on tuning of individual SQL Statements -
Tuning Individual SQL Statements
Blogged with the Flock Browser
SQL - Difference Between Hash Join & Merge Join
Difference Between Hash Join & Merge JoinSQL - Difference Between Hash Join & Merge Join
Merge Join :Oracle performs a join between two sets of row data using the mergejoin algorithm. The inputs are two separate sets of row data. Output isthe results of the join. Oracle reads rows from both inputs in analternating fashion and merges together matching rows in order togenerate output. The two inputs are sorted on join column.
Hash Join :Oracle performs a join between two sets of row data using hash joinalgorithm. Input and Output same as Merge Join. Oracle reads all rowsfrom the second input and builds a hash structure (like has table injava), before reading each row from the first input one at a time. Foreach row from the first input, the hash structure is probed and matchingrows generate output.
Blogged with the Flock Browser
Beware of Question Authorities « H.Tonguç Yılmaz - Oracle Blog
Beware of Question Authorities
Following suggestions are from Mr.Lewis Blog ;Beware of Question Authorities « H.Tonguç Yılmaz - Oracle BlogAnd even when all the details are perfect and there is a repeatable test case - and even after the repeatable test case produces the same results - ask yourself this question
- If it’s not dated - don’t assume it’s true*
- If its date is more than about 18 months old - don’t assume it’s (still) true*
- If there’s no version number - don’t assume it’s true*
- If it’s not your exact version number - don’t assume it’s (still) true
- For ‘technical implementation’ details, if there’s no platform mentioned - don’t assume it’s true
- For ‘technical implementation’ details, if the platform’s not the same as yours - don’t assume it’s true
- If there’s no rational justification supplied, and no repeatable test case - don’t assume it’s true.
Once you’ve got through that lot - then you might be safe trying the advice on a development system.
- Could there be a different explanation for the same set of results - and if so, how badly could this advice damage my system, and how hard would it be to test my alternative hypothesis ?
Mr.Kyte also mentions this problem under the ‘Question Authority.’ terminology;
There are lots of ‘experts’ out there;
- Make them prove everything
- Statements that should raise your eyebrows:
- It is my opinion…
- I claim…
- I think…
- I feel…
- Everything can (and should) be proven - TKPROF goes a long way hereStatspack is great‘Runstats’ is a tool I use as well (search asktom for runstats)
- Things change, expect that
Remember a test becomes a proof when;Reference
- it has a specification- the results are reproducible
- alternative explanations have been eliminated
- it is published- it survives peer-group review
“The Burden of Proof” presentation by Jonathan LewisDon’t take any “guru’s” word, test it and make sure you are convinced of the results..
Blogged with the Flock Browser
Monday, April 6, 2009
wanna walk....
Well, he is growing up like anything and why not...
I have not seen any baby's childhood like I am seeing mine's. You bet it can get better than wonderful. Though there are times when you feel you were in a different situation (e.g. when he doesnt want to sleep at 2 in the night)...
He has already learnt to laugh at will and at prompting.. I can count things on my fingertips which would make him laugh... literally Laugh Out Loud..
And, he's only 4.5 months, but feels like he wants to run. Every time, you try to make him stand, and he would squeak as if he's been given something great... He would try to move his feet, already an attempt to walk...
The sweetness of his actions, various of which are unknown to me (happens with him and his mom), can not be described through words. Like these photos from today, there were taken when he was attempting to walk on my tummy... He was extra happy... photos show it all... better than words...
Its just great... :)
I have not seen any baby's childhood like I am seeing mine's. You bet it can get better than wonderful. Though there are times when you feel you were in a different situation (e.g. when he doesnt want to sleep at 2 in the night)...
He has already learnt to laugh at will and at prompting.. I can count things on my fingertips which would make him laugh... literally Laugh Out Loud..
And, he's only 4.5 months, but feels like he wants to run. Every time, you try to make him stand, and he would squeak as if he's been given something great... He would try to move his feet, already an attempt to walk...
The sweetness of his actions, various of which are unknown to me (happens with him and his mom), can not be described through words. Like these photos from today, there were taken when he was attempting to walk on my tummy... He was extra happy... photos show it all... better than words...
Its just great... :)
Sunday, April 5, 2009
Subscribe to:
Posts (Atom)

