Re: Serious Issue in oracle

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"

Other related posts: