Home » RDBMS Server » Performance Tuning » Error In Analyzing Table (Ora-03114 & ORA-00603)
Error In Analyzing Table (Ora-03114 & ORA-00603) [message #153303] Sat, 31 December 2005 00:18 Go to next message
weekend79
Messages: 198
Registered: April 2005
Location: Islamabad
Senior Member

Hi

While analyzing a huge table from “Analyze Table Table_Name compute statistics;” I got following errors after long query processing.

When execute from network access:
ORA-03114 Not connected to Oracle

When execute from database host machine:
ORA-00603 Oracle server session terminated by fatal error.

Please advise how to analyze?

Wishes
Jawad

Report message to a moderator

Re: Error In Analyzing Table (Ora-03114 & ORA-00603) [message #153353 is a reply to message #153303] Sat, 31 December 2005 23:11 Go to previous message
waseem_aijaz
Messages: 16
Registered: December 2005
Location: Kingdom of Saudi Arabia
Junior Member
Your first step is to check why the Oracle Session wass terminated ? Check your alert_SID.log file for this.

Report message to a moderator

Previous Topic: help calculating freelist groups
Next Topic: Turn Logging on, on Index
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 03:39:48 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.