my question is above, i want find another tools which can analysis redo
log or archive log file. does anyone know?

When I try to start dbconcole from a command shell, I get the
following.
D:\oracle\ora10g\BIN>set oracle_sid=foo
D:\oracle\ora10g\BIN>emctl start dbconsole

Status of    Status of     Datafiles Response
Online Logs
1. Available    Current        If the online logs contain
                              redo necessary for recovery, then

I have a problem when I try to install oracle 9.i on a windows server 2003.
When I launch universal installer, I've got the message :
"error in writing to directory c:\......."
oracle can't write to the temporary directory of the user however a

I'm really interested in the XML Publisher product mentioned here:
http://www.oracle.com/technology/products/applications/publishing/index.html
I can't seem to find where to download an eval copy of it, though. I don't
see it listed in Oracle's download page, and I'm not sure what ...

We are migrating our 817 system to a 9i and curent are running the two
in parallel.  817 is use rule  and 9i is cost.  A particular query is
running significantly slower in the 9i than in the 817.
Tables are the same with same indexes.  Statistics are current in 9i

Anyone heard of this new feature in 10g: "Cost Based Transformation".
Its basically new functionality which enables the optimizer to cost
transformation operations like subquery unnesting and predicate pushing
etc.

I've installed the Oracle 8 (Server) for Windows NT on Windows XP Pro
and I get an information that the Strtdb80.exe encountered a problem
and will be closed.
Is there any patch or anything else that would let me use the Oracle

One of our database experiences heavy waits on 'log file sync'.
Top waits from V$SYSTEM_EVENT are given below. 'Log file sync'
exceeds 'db file sequential read' and 'db file scattered read'.
Metalink Note 223117.1 says that they key to understanding

I want to create a temporary table within a stored procedure so I decided to
do it using a dynamic query:
[CODE]create or replace procedure p1
as

I have some auto-generated trigger code that works just fine in Oracle
v.9.2.0, but in another database that is v.8.1.7 this line will not compile
if both v1 and v2 are of type VARCHAR2:
v1:=TO_CHAR(v2);

This exception appears somme times in my application.
It raises a Java exception in my program.
For a deadlock there must be two 'process' ( db connection ) involved.
One of these is easily identified because it raises the exception.

The performance of the below view is very bad.
I created below view to get the data from 2 different tables and there
is a column which is not part of any table
named "UPDATED",Which will be used along with other columns for

The PSOUG has been receiving, on a regular basis several weeks, emails
fraudulently made to look as though they were sent by Pete Finnigan and
that appear to come from plsql@petefinnigan.com.
Each and every one contains a virus ... and not one is legitimately from

Im making an access app that uses Oracle9i as its database
and just recently im starting to get these ora-04068 errors.
the error itself is always about one particular package in the database
that i've made. Now the common cause for this type of error from