Friday, January 27, 2006

Blogging and drawing inspiration --Mistaken

In my previous article,i had posted some tips for some quick real time tuning using OEM (9i) without the actual screen shots(for those who view it in other than IE) and for those who want to see the document with pictures here is the download link.
http://rapidshare.de/files/11994839/
Guide_to_Real_Time_Performance_Tuning_
Of_Oracle.doc.html


It would be a good starting point for those who want to see how OEM can be used for tuning ..Pls read the Oracle documentation carefully if you need more understanding of the underlying concepts and issues.

Again , i reiterate....
--------------------------------
It's a natural thing that everyone wants a blog to write whatever they feel and want to share some good things they are interested with others.
When i post good articles from people who have a great experience and well known in Oracle arena here, i do it with the genuine and sincere attempt to just share it with my friends and not to gain any other thing.
If copying the blog template and posting articles by others in my blog hurt/affect the original authors they can mail me so that i would stop doing so.
I accept my mistake that i had misspelled the author's name in one occassion and express my sincere apologies to the author.
Well, i hope people would see that i am genuine here and have nothing here to take credit/gain popularity/"whatever" one can possibly think of.

-------------------------

Real Time Tuning using OEM--Some Tips

This is an article which i had prepared for one of my clients in using OEM for some quick tuning and as a starting point for configuring , using OEM & its tuning packs.

Unfortunately i couldn't post the pictures here ..would be posting it shortly.

Guide to Real Time Performance Tuning Of Oracle

Version 1.0

Jun 26, 2005


CONTENTS

Guide to Real Time Performance Tuning Of Oracle. 1

CONTENTS. 2

INTRODUCTION. 3

OEM Tuning Pack. 3

OMS and OEM Repository. 3

Configuring the OEM console for using the Oracle Management Server (OMS) option. 4

Index Tuning Wizard. 10

Oracle Expert. 10

SQL Analyze. 10


INTRODUCTION

Oracle Enterprise Edition provides a lot of features for Real Time Tuning of an Oracle Database which can be used efficiently to serve as an aid in the tuning process and can help the DBA in identifying the performance bottlenecks in any Oracle system which undergoes constant changes as a result of business changes and also in improving the response time of the application to the satisfaction of the end users.

Oracle Enterprise Edition provides a lot of GUIs in its Tuning Packs that can be launched from OEM console with the Oracle Management Server (OMS) login option.

OEM Tuning Pack

OEM Tuning Packs include the Index Tuning Wizard, Oracle Expert and SQL Analyze as some of the important tools which can help the DBA in accelerate the tuning and also more importantly identify the workload pattern to get the accurate tuning recommendations for the Oracle Database under tuning. These tuning packs require the OEM console to be configured for using with an OEM repository under the OMS option.

OMS and OEM Repository

The Oracle Management Server (OMS) uses an OEM Repository to store all the tuning session details and many other DB related task details in it. OMS uses this repository to store all the tuning statistics and Job details(if jobs are configured) apart from many other things in the OEM repository for all the target databases to which one connects from the OEM console using the OMS option.


Configuring the OEM console for using the Oracle Management Server (OMS) option

OEM console needs to be configured properly for using the Oracle Management Server option. This can be done using the Enterprise Manager Configuration Assistant(EMCA) that can be launched in Oracle for Windows NT platform from the Configuration and Migration Tools menu.

The following steps would illustrate the use of EMCA to configure OEM console for using the OMS option:

STEP 1:


STEP 2:

If you are configuring the OMS to used an OEM repository for the first time, then select the first option. Selecting this option enables one to configure the local OMS on the server. This configuration would create an additional Windows NT service with the naming convention OracleManagementServer. This would then be the NT service responsible for OMS afterwards and needs to be in “Started” state at the end of this configuration process.


STEP 3:

This step would help in creating a repository for the OMS in the server. This OEM repository for the local OMS is just another Oracle Schema which can be configures either in one of the existing databases or in a new database exclusively for the OEM repository.

If you are creating a repository for the first time use the first option here.


STEP 4:

Depending on whether you need to create a new database exclusively for hosting your OEM repository or use one of your existing databases for storing the OEM repository choose either the “Typical” or “Custom” options here.


STEP 5:

If you have chosen the “Typical” option here then you would end up in the following screen which would help you in creating a new database with the default naming conventions, a new Schema (a Repository user along with the configuration data in tables and associated objects under the user).

This new database would be like any other database except for the fact that it would be hosting the OEM repository and everytime one would be connecting to this database whenever you are launching OEM console using the OMS option.


In case you want a “Custom” configuration of OEM repository then you would be presented with the following screen from where you can choose to create a new database( as above) or use an existing database for hosting the OEM repository as below:

One would be prompted to give the OEM repository name and password details later. In case you are choosing an existing database option then you would be prompted to furnish the details of an user having DBA rights in the existing database so that using this DBA login credentials the OEM repository schema can be created in the existing database.

The screens which follow from hereon are self explanatory and any user having a basic understanding of the Oracle DB should be able to finish the configuration process.

In case you run into any problems in configuring the OMS you can always restart the whole process at any time and even if you have ended up with a wrong configuration , one can always drop the repository and recreate a new one.


Index Tuning Wizard

This wizard helps us in arriving at a proper and effective indexing strategy. This Index tuning wizard can go a long way in helping the DBA arrive at a right combination of the indexes for the application and helps in improving the response time of the SQLs which consume more system resources by identifying new possible indexes.

This wizard also gives justifications for the recommended indexes and also generates the script to implement the recommended indexing changes. These recommended changes and the script can then be reviewed by the DBA to arrive at a final Indexing recommendations. Thus the tool helps the DBA in Indexing strategy and thereby accelerating the tuning process

Oracle Expert

This is a very powerful tool which can automate the process of collecting statistics at database, instance, schema and workload levels and help in arriving at recommendations at a more generic level. With real time workload and actual CPU, Memory details of the live system, Oracle Expert recommendations would be extremely effective in performance tuning to the DBA. The manual way of collecting Statspack reports and then using them to arrive at tuning recommendations can be partially automated using this Oracle Expert and also help the DBA in speeding up the tuning process by arriving at recommendations not only at the SQL level but also at the Instance level.

SQL Analyze

SQL Analyze is a powerful SQL tuning tool which comes along with many other wizards like Virtual Indexing wizard, Hint Wizard etc.

SQL Analyze helps the DBA in automating the tuning of resource intensive SQLs by identifying the SQLs under different categories similar to the SQL reports sections in Statspack reports and helps the DBA in tuning them with many supporting utilities like Virtual Indexing wizard.

Virtual Indexing Wizard in particular is one of the most useful and effective tool which helps in identifying the performance improvement without actually creating those recommended indexes.

Conclusion

Oracle tuning of existing systems/already running systems needs to be done with extra care so as to minimize those changes which need more development/maintenance effort and also possibly those inevitable testing efforts. At the same time tuning should also meet the end users objectives in the shortest possible time. Oracle’s tuning tools described here come very handy for the DBA to meet the above requirements.

Blogging and drawing inspiration --Mistaken

It's a natural thing that everyone wants a blog to write whatever they feel and want to share some good things they are interested with others.
When i post good articles from people who have a great experience and well known in Oracle arena here, i do it with the genuine and sincere attempt to just share it with my friends and not to gain any other thing.
If copying the blog template and posting articles by others in my blog hurt/affect the original authors they can mail me so that i would stop doing so.
I accept my mistake that i had misspelled the author's name in one occassion and express my sincere apologies to the author.
Well, i hope people would see that i am genuine here and have nothing here to take credit/gain popularity/"whatever" one can possibly think of.

Friday, January 06, 2006

Good Oracle Books

Thomas Kyte's Good Oracle (Must Read) for DBAs and Developers
---------------------------------------------------------------------------------
1. Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions
2. Expert one-on-one: Oracle
3. Effective Oracle By Design
(you can go for 1 as it contains 10G and also 3 if possible )

For SQL*PLUS and PL/SQL the following are good books
------------------------------------------------------------------------

1 Mastering Oracle SQL and SQL*PLUS -- By Lex De Haan
2 Mastering PL/SQL -- By Connor McDonald

For General Oracle Concepts from Scalability and Performance of Oracle Applications perspective
----------------------------------------------------------------------------------------------------------------------

1. Scaling Oracle 8i (Eventhough the name says 8i it is a very good book whose concepts still apply)
   -- By James Morle(Expert on Scalability,RAID and SAN/NAS concepts)
   (Good thing is this book can be downloaded from www.scalabilities.co.uk site -- http://www.scaleabilities.co.uk/book/scalingOracle8i.pdf)

Other Good Books are :
1.Practical Oracle 8i -- Jonathan Lewis (Again the name'8i' is a misnomer as it is a good book that holds true still)
2. Cost Based Oracle Fundamentals -- Jonathan Lewis (A very good book of recent times )
If you want to understand how Oracle’s Cost Based Optimizer works, you will want to read this book. To get you started, there is a pdf of Chapter 5 (Clustering Factor) that you can download from Apress
 


Yahoo! Photos
Got holiday prints? See all the ways to get quality prints in your hands ASAP.

Tuesday, January 03, 2006

Project Raptor is available now


Oracle has released a new tool called Raptor. This tool is a java-based GUI for accessing Oracle databases. It allows to perform SQL and PL/SQL and to browse database objects.

It includes a lot of useful features, e.g:
- Multiple database connections
- Database reports (pre-defined and user-defined)
- SQL Formatting
- PLSQL debug
- PLSQL OWA output
- ...
http://www.oracle.com/technology/software
/htdocs/eaplic.html?
http://download.oracle.com/otn/other/
raptor-0715.zip



Moreover it is free to use.

At this moment, an early adopters release is available, the production release is scheduled for early 2006.
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

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

Monday, November 14, 2005

Evolution of Oracle App.Server


Pls see this link for interesting information on Oracle App.Server and how it is evolving along with the DB server.
http://www.rittman.net/archives/000745.html
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, November 04, 2005

Famous Scottish Castle Posted by Picasa

Monday, September 19, 2005

Free Download : Oracle Jdeveloper with ADF

EASY WEB APPLICATION DEVELOPMENT USING ADF IN JDEVELOPER 10G

You can download free JDeveloper with ADF(For Windows) from,
http://download.oracle.com/otn/java/jdeveloper/10121/jdev1012.zip
(Around 200MB only )

Note : With ADF(Application Development Framework) in Oracle JDeveloper 10G you can rapidly develop J2EE applications using the
MVC (Model 2 with Struts controller) scalable architecture. ADF Data model and binding helps the J2EE developer with faster development
using the in built ADF runtime components. Just focus on Business services model , draw the business model dragging the enitity beans components.

You can develop a full HTML/web application in just 8 easy wizard driven steps. In addition if you have addtional knowledge on J2EE design you can deploy the components as web services or ADF UIX clients or whatever J2EE component you wish at each level.

For more info on this,
You can Download good presentations from experts at TUSC
http://team.tusc.com/pls/inet/inet_Download_Info_pkg.Get_Info?in_item=doc2004-jdeveloper_web_dev.zip
and http://team.tusc.com/pls/inet/inet_Download_Info_pkg.Get_Info?in_item=laoug2003-quick_web.zip



Sunday, September 18, 2005

Oracle Performance Tuning-Never Dare to enter this sea without sufficient experience

As Steve(DatabaseJournal) points out Oracle Performance Tuning can be like drowning into a pool ..It can be a big confusion of sorts for those who involve in it for the first time without prior experience and sufficient knowledge/skills in this area.
A typical newbie would try to keep his/her hands on everything which may suggest need tuning without a fixed direction.
Tuning Oracle is a profession where your knowlege of how Oracle works would be under real test and expereince counts a lot.
You need to hit the right balance on looking at hit ratios(checklist based tuning) as well as focussing with extended sql trace (Wait interface tuning) and most imortantly on how your business management see this. The more they give importance to the tuning exercise the more would be your efforts..
If just making things work at some acceptable level is what you need, don't waste extra time on it..(personal lessons learnt)
 
Would come up with an interesting article on Extended SQL tracing(10046 event) and hotsos resource profiler(Why Cary Milsap charges you heavily for this..)
 

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Tuesday, September 13, 2005

Flashback Feature in Oracle 10G

Pls see this link

http://www.geocities.com/juancarlosreyesp/OracleAskTom.pdf
(Oracle 10G Flashback feature..thanks to Thomas Kyte)

On Oracle10G Model Clause--Powerful Spreadsheet like Calculations inside database

ORACLE 10G SQL Enhancement Model Clause
Having gone through the feature summary and an example from AskTom Website , it looks to me that
Oracle is trying to eliminate the need for spreadsheet programs which are used to do some inter-row calculations on the results fetched from the database. Looks impressive along with the analytic functions which Oracle has introduced on the SQL arena: For those who want to read the feature summary here is the link for the pdf(Thanks to Thomas Kyte) http://www.oracle.com/technology/products/bi/pdf/10gr1_twp_bi_dw_sqlmodel.pdf

Monday, September 12, 2005

In Scottland with some of my friends  Posted by Picasa

Oracle Application Schema Checklist and Database Checklist

This is a very good checklist from Pete Finnigan(Oracle guru on Security aspects)
http://www.sans.org/score/checklists/Oracle_Database_Checklist.pdf

Pls also see this:
(A useful checklist on Application schema before you put it in live--)

Follow this checklist to make sure your application schemas are ready to be put into production:

  1. Perform physical configuration:

  2. Does each application have its own schema?

  3. Does each schema have its own set of table and index tablespaces?

  4. Are tables and their corresponding indexes in separate tablespaces?

  5. Check on performance issues:

  6. If you are implementing referential integrity, are all core foreign keys indexed?

  7. Are there tables without indexes?

  8. Are there tables with too many indexes?

  9. Are there tables with similar indexes?

  10. Are the schema objects regularly analyzed?

  11. Check on security issues:

  12. Are all object grants performed through roles? (While doing this is not strictly necessary, it does make administration much easier.)

  13. If your applications allow for it, are all updating capabilities granted through nondefault roles?

  14. Check on miscellaneous issues:

  15. Are naming conventions in place for all database objects? (While using consistent naming conventions is not strictly necessary, it does make administration much easier.)

  16. Is the value of the PCTINCREASE parameter for each tablespace greater than 0? This will ensure the automatic coalescing of free space. If you do not want your extent sizes to change, you'll want to ensure that PCTINCREASE is set to 0.

I'll be bringing some useful articles on SQL tracing in my next post.

Apply your Logical reasoning and Intution

"Many times it's pure logical reasoning and Intution that saves time and solves problems that appear to be complex at the outset."
--Message of the Day