Michael, Answer to your below query are: 1) We although tired the query doesn't provide us any ouput. 2) Yes, there are no sort or update. Thanks, Amit Verma On Mon, Jan 25, 2010 at 2:34 AM, Michael Elkin <melkin4u@xxxxxxxxx> wrote: > Can you trace this session with simple select from that view and see what > are we waiting for? > > I assume that we are not talking about some sort of select for update , am > i right > > Michael > > > > > > On Sun, Jan 24, 2010 at 9:11 PM, AMIT VERMA <verma.labs@xxxxxxxxx> wrote: > >> Thanks Michael, >> >> There are 7 tables which is joined by 1 view. The structure of 7 tables >> are equal. Through that view my other programs fetchs the records. >> >> The problem we had faced: View didn't respond it seems like to us hung or >> non responsive. Later we have found that the 1st table was non responsive >> where as other objects are responsive. During the analysis we didn't find >> any error in the alert log, index's are vaild. 'sar' shows us very low >> %iowait. I didn't found any information on web as well. >> >> Yes by access, i mean simple 'select' statement. We have resolved it by >> restarting the database. >> >> What do u think.. >> >> On Sat, Jan 23, 2010 at 11:20 PM, Michael Elkin <melkin4u@xxxxxxxxx>wrote: >> >>> What is the exact problem ? When you say "not able to access the table " >>> , do you mean simple select from the view ? >>> >>> Can you give the exact example of the problem ? >>> >>> Michael >>> >>> >>> On Sat, Jan 23, 2010 at 12:23 PM, AMIT VERMA <verma.labs@xxxxxxxxx>wrote: >>> >>>> How should I know what happen at that time? >>>> >>>> >>>> >>>> On Sat, Jan 23, 2010 at 2:50 PM, AMIT VERMA <verma.labs@xxxxxxxxx>wrote: >>>> >>>>> >>>>> hi david, >>>>> >>>>> All grants are given. Eariler we were able to access it however index & >>>>> table are Valid. When there was no solution to resolve it we have rebooted >>>>> the database. And thereafter problem resolves, we again access the table. >>>>> Its Strange! >>>>> >>>>> please advice. >>>>> >>>>> thanks, >>>>> amit v >>>>> >>>>> >>>>> >>>>> On Sat, Jan 23, 2010 at 2:08 PM, David Ballester < >>>>> ballester.david@xxxxxxxxx> wrote: >>>>> >>>>>> >>>>>> >>>>>> 2010/1/23 AMIT VERMA <verma.labs@xxxxxxxxx> >>>>>> >>>>>> All, >>>>>>> >>>>>>> I am sharing my yesterday experience with you, below are the >>>>>>> details: >>>>>>> >>>>>>> * >>>>>>> ISSUE: >>>>>>> * >>>>>>> Not able to access the table. >>>>>>> ** >>>>>>> *DEPLOYMENT:* >>>>>>> In a A schema we have 7 tables x1, x2.... x7 which is further join >>>>>>> by a VIEW y. Other B/C schema access the y to get the records. >>>>>>> >>>>>>> *ROOT CASUSE:* >>>>>>> ** :( not able to locate, no error in the alert log, statistics are >>>>>>> uptodate. Oracle Version is 10g Standard with RHEL update 8. >>>>>>> >>>>>>> >>>>>>> Any Suggestions... >>>>>>> >>>>>> >>>>>> i've one, try to explain better what you can't do :) anyway, are you >>>>>> sure that all grants necessary are put in place? remember that each time >>>>>> that you recreate an object, even with the same name, the grants must be >>>>>> reapplied >>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> Amit Verma >>>>> v.amit84@xxxxxxxxx >>>>> >>>>> >>>>> "Winning takes talent but it takes character to keep winning" >>>>> >>>> >>>> >>>> >>>> -- >>>> Amit Verma >>>> v.amit84@xxxxxxxxx >>>> >>>> >>>> "Winning takes talent but it takes character to keep winning" >>>> >>> >>> >>> >>> -- >>> Best Regards >>> Michael Elkin >>> >> >> >> >> -- >> Amit Verma >> v.amit84@xxxxxxxxx >> >> >> "Winning takes talent but it takes character to keep winning" >> > > > > -- > Best Regards > Michael Elkin > -- Amit Verma v.amit84@xxxxxxxxx "Winning takes talent but it takes character to keep winning"