Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Performance difference issue between two users of the same database

Re: Performance difference issue between two users of the same database

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Sat, 28 May 2005 00:11:40 GMT
Message-ID: <Xns9663AEE99BE4ESunnySD@68.6.19.6>


Talk2Vineet_at_gmail.com wrote in
news:1116911759.883646.259340_at_g43g2000cwa.googlegroups.com:

> Hi All,
>
> I have a problem, would appriciate you if your help makes me resolve
> this issue. I have created two users in the same database and when i
> run a query in these two users, one user executes it in a minute, while
> other takes more than 10 minutes. Query to be run has mixture of views
> and tables while views in turn has many tables joined with each other.
> I have checked all the indexes and both the users have similiar
> indexes, when checked default tablespaces, the fast user's is system
> while other's is users. According to Expain plan of the query, the user
> which is fast using an index on a table while other is not. I got stuck
> in it for the last 2 weeks but could not make it work, even i created
> many users and even in different schemas also but it didn't work.
> Please help me out.
>
>

Enable event 10046 at level 12, run the resultant trace file thru TKPROF; with EXPLAIN_PLAN & post the results back here.

OS Name & verion?
Oracle vesion to 4 places.
CBO or RBO?
Are statistics current on both? Received on Fri May 27 2005 - 19:11:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US