Hi,
Is this characteristic of a bug or is the Oracle Architecture ?
SQL> desc dba_audit_exists
ERROR:
ORA-24372: invalid object for describe
SQL> select count(*) from dba_audit_exists;
COUNT(*)
--
0
SQL> desc dba_audit_exists
Name Null
Hi guys,
Please help me solved this
SQL> show user
USER is "SYS"
SQL> select owner, object_name, object_type from all_objects where object_name =
'DBA_AUDIT_TRAIL';
OWNER OBJECT_NAMEOBJECT_TYPE
-- -
Denmark,
Sifting through the clues in your email, it is almost dead certain that the
SQL statements in your overnight reports must be tuned. Adding rollback
segments has no effect on reports (usually). Modifying initialization
parameters is unlikely to affect such specific problems also.
To is
You mentioned a number of things you have tried to tune the database, so it just may (probably is) the SQL. Rewriting might be the best solution (depending), but you need your stuff now. If you can't tune the SQL, try tuning the execution. If you can run a trace of the report session, use tkprof
Denmark Weatherburne wrote:
> I know tuning the SQL might be required, however, I don't have much
> experience in this area. The SQL statemements were written by consultants
> who have long left. We do have the source code though.
Ak for your money back. You are right, usually SQL is the reason.
Hi DBA's,
I've been trying to isolate the bottleneck with our Oracle database.
I work as an Oracle DBA for the Government of a developing country (Belize).
Recently, as it is income tax time, the department has to reconcile all
witholdings by the employer with their payment receipt
records. Th
Hello list
We intend to implement OID as replacement for tnsnames (at first).
Pit falls, Real time experience etc...???
Yechiel Adar, Mehish.
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, April 01, 2002 11:34 PM
> And good luck wh
Well, I do not know UNIX but I wanted today to see what
products are installed on one NT server which has:
8.1.6, 8.1.7, 9.0.1 and OEM all installed.
I activated the oracle installer and got an error:
You can not update the registry - Installed aborted
(some thing like this:-)) ).
At least on Cof
I think that you should create an after row
trigger that will activate
a package that will check the values and activate
whatever procedures
you need.
This way you have only one trigger and you control
what to do in whatever
order you need.
Yechiel Adar, Mehish
- Original Message -
Hello Connor.
Tested this on 9.0.1.1.
Works fine when selecting from the same database.
(The only 9 version db we have.).
When trying to access version 8.1.6 db got -1002 (trying to fetch after set
is finished) no matter what array size I set.
Yechiel Adar, Mehish
- Original Message -
To
10 matches
Mail list logo
