Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
Oracle 10g Mview Refresh Performance Isses

Oracle 10g Mview Refresh Performance Isses

2005-03-10       - By Michael Fontana
Reply:     1     2  

BTW -

Here are our bug references for these issues:

Bug 4074710 10.1.0.3.0 RDBMS 10.1.0.3.0 PI/DISTRIB PRODID-5 PORTID-23
ORA-7445 (See ORA-7445.ora-code.com)
Abstract: ORA-7445 (See ORA-7445.ora-code.com) [DDFNET7RESTORE()+320] DURING REFRESH OF INLINE MVIEW
Severity: 2,Severe Loss of Service Fixed In Ver: 10.2.0

eos (end of section)
.
POTENTIAL SOLUTION(S)
======================
If the master table is remote, set event 10336 as a workaround for Bug
3278020.

If the master table is local, you seem to be hitting bug 4074710, which is
fixed
in 10.2. We have a backport for this bug for Solaris 64-bit. It is available
from Metalink->Patches:

Patch 4074710
Description ORA-07445 (See ORA-07445.ora-code.com) [DDFNET7RESTORE()+320] DURING REFRESH OF INLINE MVIEW
Product RDBMS Server
Release Oracle 10.1.0.3
Platform or Language
Last Updated 20-FEB-2005
Size 25K (26580 bytes)

eos (end of section)
@(protected)

-- --Original Message-- --
From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)]
On Behalf Of Michael Fontana
Sent: Thursday, March 10, 2005 10:21 AM
To: oracle-l@(protected)
Subject: Oracle 10g Mview Refresh Performance Isses



We are currently testing Oracle 10g performance and functionality, and have
run into severe performance degredation issues in performing fast refreshes
of materialized views.  In some cases, the refreshes fail with ORA-07445 (See ORA-07445.ora-code.com)
errors.  In opening at least two TARS with Oracle, their analysts have given
us optional parameters that did not work, have pointed us to patchsets that
are not yet available on our platform, and finally gave us a customized
patchset.  In light of these issues, we have decided we will NOT be
migrating this particular application to Oracle 10g in production for some
time to come.

Has anyone else run into such issues?  We have noted that a typical fast
database refresh, even when it does work, takes at least 50% longer compared
to a typical Oracle 9i implementation.  

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

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