executes

[milinda]

My query never executes and takes a long time, What could I do?

[slimdave]

You could learn to RTFM, and stop bombarding us with your generic class assignment questions.

[milinda]

Thanks for ur help, Actually I am new to this, Sorry If I disturb u people. I go through sites u gave me.

[Tarry]

Originally posted by milinda
My query never executes and takes a long time, What could I do?

Tell it to execute and take a less time (In the code I mean)

[gbrabham]

What does the data look like??? How many rows in the tables ???
What does the query look like??? Are you using cost or rule
based optimization??? Are you statistics updated ???
What does the execution plan look like ???

If you are using multiple table joins, you should try to use
the "smallest - least rows returned" table as the driving table...
Have you looked at the "explain plan" to see the path Oracle is
taking? Have you tried "Hints" ...

What does that SGA look like .......

There are many different reasons for a query to be slow ...

Gregg

[balajiyes]

My query never executes and takes a long time, What could I do?
paste ur query and the no. of records in the tables used by the query.