Re: Serious Issue in oracle

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_at_gmail.com> 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_at_gmail.com> wrote:
>
>> How should I know what happen at that time?
>>
>>
>>
>> On Sat, Jan 23, 2010 at 2:50 PM, AMIT VERMA <verma.labs_at_gmail.com> 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_at_gmail.com> wrote:
>>>
>>>>
>>>>
>>>> 2010/1/23 AMIT VERMA <verma.labs_at_gmail.com>
>>>>
>>>> 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_at_skype.com
>>>
>>>
>>> "Winning takes talent but it takes character to keep winning"
>>>
>>
>>
>>
>> --
>> Amit Verma
>> v.amit84_at_skype.com
>>
>>
>> "Winning takes talent but it takes character to keep winning"
>>
>
>
>
> --
> Best Regards
> Michael Elkin
>

-- 
Amit Verma
v.amit84_at_skype.com


"Winning takes talent but it takes character to keep winning"

--
http://www.freelists.org/webpage/oracle-l