Re: Serious Issue in oracle

Sounds like a deadlock situation. No errors in the alert log? ...Before you bounced the DB? Can you recreate the problem now that it's gone? Maybe Gremlins.... they like to cause havoc... :) Lyall

-----Original Message-----
From: AMIT VERMA <verma.labs_at_gmail.com> To: Howard Latham <howard.latham_at_gmail.com> Cc: David Ballester <ballester.david_at_gmail.com>; oracle-l_at_freelists.org Sent: Sun, Jan 24, 2010 2:21 pm
Subject: Re: Serious Issue in oracle

Hello Howard,  

Yes you are right, please advice I will share the information with you. However I didn't found this issue on web :)  

ISSUE: One table contains millions of records with the insertion of 5,000 to 10,000 per second. The table was become non - responsive or hung, we had run the select statement only. There is no error in the alert log & no information avilable on the web. Thus we have restarted the db: The last method & we have found the table become responsive.  

There were no change eariler we are able to get the data, when the incident it becomes non responsive after rebooting everything fines. The issue hidden sliently :)  

Thanks,
Amit V

On Sun, Jan 24, 2010 at 11:48 PM, Howard Latham <howard.latham_at_gmail.com> wrote:

theres a million and one possibilities. You could cause this by running a script that drops a synonym but the restart wouldnt fix it. There's really far to little information here.

On 23/01/2010, 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"
>

--
Howard A. Latham




-- 
Amit Verma
v.amit84_at_skype.com


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


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