Wednesday, December 28, 2005

New Ways to see the World


I stumbled upon this interesting series of World maps at this site while reading some blogs.

The population map which shows each country extended according to their Population size is very interesting.
(Surprised to see the size of India , Canada and Australia!!).


http://www.odt.org/Index.htm


Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you

Tuesday, December 27, 2005

Middleware matters!!


Couple of weeks before i was desperate to jump  into the Oracle Java  enterprise programming.
The result of which i was fiddling with my 1 GB RAM DELL laptop to have a complete Oracle 10G infrastructure and App server running.

For folks who have such bizarre desires here is an interesting article on Oracle 10G App server topography by Mr. John Garmany.


http://www.dba-oracle.com/art_dbazine_oracle_server_topography.htm





Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you

Thursday, December 22, 2005

Oracle's HTML DB technology making its inroads


Oracle is pushing its HTML DB technology for faster and easier way of building data driven web sites strongly and it has
built its Metalink site (The ulitmate Oracle knowledge and support website) newly using HTML DB.
The famous Oracle Asktom website is also running using HTML DB technology.

It would be interesting to wait and see how Oracle would market its use and applications.
Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you

Thursday, December 15, 2005

Optimization Can be Funny at Times!!


Sometimes people spend hours of effort on optimizing things which they might be running(if at all) only once and the actual process itself may take possibly less time than the effort spent. Funny  ..Is'nt it?
That's why Cost Benefit Analysis and predicting your benefits is an important measure for Oracle Performance Consulting projects.
This is well brought out by Cary Milsap and Jeff holt's book on "Optimizing Oracle Performance".
Earlier i had promised an article on Hotsos Profiler and why  it is given great importance in scientific approaches to Oracle Performance Consulting projects.
Unfortunately i had been working on many other things including working on my own 10046 Resource Profiler in Perl similar to Hotsos.
I would definitely highlight the salient features and concepts behind the Hotsos and Sparky Data collection tool at Hotsos by Cary Milsap et al.
Anyone interested in knowing about how Oracle RDBMS kernel mesaures itself in terms of CPU usage timing and Wait Event Statistics should read the above book by Cary Milsap along with Richmond Shee's book on Oracle Wait Event Tuning.
Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you

Friday, December 09, 2005

The Art of Writing Good SQL -- By David Aldridge

This is a good article by Mr. David Aldridge and the original source is here. http://oraclesponge.blogspot.com).
My sincere apologies for not getting the author's name right and i was so careless and lazy that i pasted the entire article here without the orginal source link.

The article was really a comprehensive one and pls do read it at the above link.

Anways here is what the aricle outlines.

-- Excerpts from the above orginal source...
"
Writing Good SQL

I think that there are at least five elements to consider. In no particular order:

  • Understanding what you are trying to do
  • Knowledge of SQL syntax
  • Appreciation of the data and the structure
  • Optimization
  • Measurement of performance
SourceID:NT0000368E

"

Tuesday, December 06, 2005

Oracle Federated Search


Here is a new Search link which gives a Federated Search for most of Oracle products and releases which include the following :
  • Oracle Database 8i, 9i Release 2, 10g Release 1, 10g Release 2, Express Edition
  • Oracle Application Server 9i Release 2, 10g Release 1, 10g Release 2
  • Oracle Collaboration Suite 9i Release 2, 10g Release 1


http://otn.oracle.com/pls/db102/db102.federated_search
Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you