| Urgent Help Needed:Oracle 10g [message #175077] |
Wed, 31 May 2006 11:56  |
AnilOrafaq
Messages: 12
Registered: May 2006
|
Junior Member |
|
|
Dear All,
We have a production database migrated to Oracle 10g from 9.2.From the first day of the db migration we are facing a performance problem in certain activities.This is happening in-spite of the the tables/indexes have been properly analyzed.Could you please give me any other factors which will influence the performance problem in 10g which was running very fine in 9.2.
I'll come back with specific performance problem which we are facing. Thank you.
[Updated on: Wed, 31 May 2006 11:57] Report message to a moderator |
|
|
|
| Re: Urgent Help Needed:Oracle 10g [message #175129 is a reply to message #175077] |
Wed, 31 May 2006 21:18  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
>we are facing a performance problem in certain activities
For those "activities" enable SQL_TRACE, run the results thru TKPROF & then see where the actual time is being spent/wasted.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
