I need to log some updates and I would like to do it using a trigger which
inserts a line to a logtable. I need to know which application (sqlplus,
java, toad etc) was used to make the update. I've studied sys_context but
didn't find that information. Toad's Session Browser shows ...

I'am using Oralce 9i utl_smtp package to send html mails and facing an
issue.
My smtp configuration is as follows:
utl_smtp.write_data(connection, 'MIME-Version: 1.0' || cCRLF);

I need some help.
Shell script counter. i need to add condition to check if counter is
more than 10 and longer than 3 hours? it runs every 5 mins. it only
check count and send email right now.

I am trying to duplicate a production database - version 10.2. 0.1.0.-
in a different server and I started the instance with nomount. Then I
connected to rman :
RMAN> connect target /

Version information:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
We have a materialized view that takes approximately 3 hours to build
without an index. Once we've put an index on a few of the columns it

Gibt es eigentlich eine Möglichkeit, das"Hauptmenü" anzupassen? Ich würde
gerne z.B. das MAPS Icon gegen den Wecker tauschen, da ich die Maps nicht
benutze,
Ich habe nichts in der Doku direkt etwas gefunden.

I would like to create a physical standby with Oracle 10g.
2 servers with the same the same structure.
I have read a lot of documentation but I'm always confused about some
points.

Oracle Connect Newsletter
To view this click on the following link or copy paste below link on
the browser.
http://tinyurl.com/oracle-connect-october09

Been having a problem with posting, have emailed him twice with two different
email addresses, no reply, nothing.
Is he OK?  Probably still in the US from the OOW?

I installed the Oracle Client 10.2.0.1.0 on a new machine with Windows
XP.
SQLPLUS and TNSPING are working fine; however, there there is a
problem with EXP:

  I'm using /* no_cpu_costing */ hint in my select statements while
generating the explain plan. Is it a good idea to use it while
analyzing the Explain Plan output? Please suggest.
--

Last night, I upgraded my CentOS from 5.3 --> 5.4. Of course, there is no
upgrade for unixODBC, but there is a ton of other upgrades. Result:
[mgogala@medo work]$ isql ora10 scott tiger
+---------------------------------------+

Hope I can explain this properly:
I'm hoping this can be done in just 1 long SQL statement.  We have
several queries that gather counts from different tables.  Each takes
a while and since they are part of the same app, the screen takes a

I have just configured a catalog for RMAN in another instance.
I realized some backups before creating the catalog. The synchronization has
been realized after the creation.
Now, I use the catalog. But I'm suprise by the fact :

This is good.  My client uses the following query below.  The tables
referenced do not have any indexes, at least right now.  But all the
date fields are in the WHERE, which means at least 3 maybe 4 indexes
on the tables.  This may not matter since this is really only updated