Oracle People,
Do you trust ADDM?
I am a novice AWR user.
I am looking at an AWR report.  I am uncomfortable with the amount

Enjoy complete book online FREE: Oracle SQL in 10 Minutes
http://www.takveen.com/art_comp_ora_sql_ch1_p1.html

I've been assigned to support a legacy app that we have that's coded
in VB4 (16bit) that connects to an Oracle db via ODBC.  Everything is
fine in the production environment, my problem is in the test db
environment that I'm trying to setup.

I'm having an issue granting the REFERENCES permission to a user.
User A owns the table.
User B already has privileges to select, insert, etc. from the table.
I want user B to be able to create a table (in their schema) that

 I want to get the -real- cost and plan of an sql statement, not
estimated I can use:
(1) Explain Plan and DBMS_XPLAN from sqlplus, I gather this isn't the
real plan?

I just got to this area, so hope someone can help me with the
following issue, I will really appreciate it.
I want to query a column that is not part of the GROUP BY clause:
SELECT c.country_id,

Our application has a certain table that stores binary data as 'long
raw'. We want to change it over to BLOB, so we can use a field that
Oracle recommends, etc. We want to keep the data in a table/column
with the same name, so we don't have to change our application.

Oracle 10.2.0.3, Windows 2003 Server
Below is the scenario.  I'm confused about roles and permissions when using
more than just a local database.  Is the question at the end of the scenario
correct?

I am on Windows 2000 using Oracle 9.2.0.6.
Only way I know to find whether an outline is being used is to look at
dba_outlines
which has a column called USED and a column TIMESTMAP:

Is there any body out there who has an interest in Open Source and
MySQL?
If so - my mobile technology client are looking to hire such a person
with mature DBA skills to work from their London (UK) HQ.

10.2.0.1.0 / Windows XP Pro SP2
I am getting an error in opening an ADO connection to Oracle 10g using
the above client. Here is the message:
Microsoft Data Link Error:

I'm debating about using either Logical dataguard or one way streams
replication for a database which  needs heavy reporting. DB size is
about 100GB and does about 100K transactions everyday (Not many
updates, mainly inserts/deletes and selects). I have set up dataguard

10gR2/Solaris 8
In my application, I have concurrent sessions running process x and need to
write log....
what do you think of writeappending log lines to a CLOB field  ?

Hello all, I have what I thought was a PHP problem but I think it is
an Oracle setup and configuration problem with PHP. I know this is an
Oracle group but I have had no luck in the PHP groups and Mladen
Gogala is Oracle and PHP so I am trying to get help posting here. I

Vennela Technologies Pvt. Ltd. is a Leader in ERP Training and
Projects in India Vennela Technologies has been in Training from last
4 years. Vennela trained more than 4000 users in Oracle Applications
till date.