performance

-how to performance tuning in oracle 9i database
-with example
-what is degaster recovery
-what is wait event, what impotance of wait event
:eek::eek:

Your question is too much theoritical to answer. It is beyond the scope of this discussion to explain al that here.
Please find the details [URL="http://www.google.com/search?sourceid=navclient&ie=UTF-8&rls=WZPA,WZPA:2007-05,WZPA:en&q=performance+tuning+in+oracle+9i+database"]here.[/URL]

Your question is already replied . Please do not post the same question repeatedly.

which performance tuning do u need?
There are different types of tuning mechanisms.
They are Database tuning,Memory tuning,Application tuning.

what is the diff between oracle9i & 10g

[QUOTE=simsim;28614]what is the diff between oracle9i & 10g[/QUOTE]

Please find oracle 10g new features [URL="http://www.pafumi.net/New_Features_Oracle_10G.html#Transportable_Tablespaces"]here[/URL].

[QUOTE=koushlesh.kushwah;17389]-how to performance tuning in oracle 9i database
-with example
-what is degaster recovery
-what is wait event, what impotance of wait event
:eek::eek:[/QUOTE]

Hello,

For percormance tunning u have to see the explain plan of the query in sql.

There are different parts through we can modifies the queries performance like

which way the query is written like what it has been used in that if it using subquery then for big recordset we cant use subquery it heat the database.

sorting is a expensive process etc.

we can measure it through explain plan.

in pl/sql there is also diff. tunning we can do in that.