When i query a table by using the spss client , the query runs deadly
slow:
SELECT t0.arac_id c0, t0.kaynak_arac_kod c1, t0.marka_id c2,
t0.model_id c3,

Oracle 9.2.0.4 EE on HP-UX 11.11
I have rewritten a query to use the new 9i JOIN syntax and the
optimizer has now chosen a different plan.  This has caused the
execution time to double.  In order to improve the performance of the

i have the following problem:
i must fully audit (except select-statements) all users with dba role
(sys,system,admin (my admin user;-))
so i can produce every day a list like:

I have many stored procedures written by another person that performs only
ONE select statement using an input parameter.
Do you think it is better to implement them as dynamic sql in application
source rather than calling them using stored procedures? I concern

     I need to do a SELECT of a field in a table ORACLE, the problem is
that I only must take last the 4 caracters of that field. Can somebody say
to me that function I use? I don't find documentation that puts it.
     A greeting

Oracle 9.2.0.4 EE on HP-UX 11i
I have a question relating to HP-UX file I/O:
As far as I am aware HP-UX is capable of Direct I/O (i.e. bypassing the
Unix buffer cache) when using VXFS and the following mount parameter:

When running a select statement i am getting the following error
ORA-01114: IO error writing block to file %s (block # %s). The query is
pretty complex.
If some one tell me the cause of this query it would be better.

I'm very new to Oracle and have learned a bunch in the last eight
months.  However being a babe in such a vast field, there is soooo much
to learn and experience.  I have been given a project to validate
numeric and character data columns.  In addition to those tasks, I have

Can someone please explain why ORA-01722 occurs in the following sql
near s.C42=115504? s.C42 is a number in the database. Many thanks!
Fri Jul 15 19:36:28 2005 DBD::Oracle::st execute failed: ORA-01722:
invalid number (DBD ERROR: error possibly near <*>

I want to install Oracle E-Business suite on my LAPTOP, which has the
following configuration
p4 - 1.7ghz,
512 mb ram,

While I was testing the RMAN backup to disk on 10g, backup job is
waiting forever /hung with the wait event "ksfd: async disk IO".
spfile parameter for ASYNC were set.
disk_async_io=TRUE

Im starting to just get into oracle text, and I seem to be getting a
error when i index my table...
SQL> create index idxmytable
 2  on mytable(doc2search)

We have a veritas cluster set up and 2 oracle 9i database(on solaris)
forming the cluster. Now one of the instances (of database1)has failed
over from one node(the usual node,say node1) to another(say node2).
Also on the node to which it has failedover(id node2) , there is an

I am running a competition in conjunction with Osborne McGraw to
giveaway 1 of 3 copies of the Oracle 10g Database DBA Handbook.
Comp ends 5th September.
UK only please.

Oracle 9.2.0.5
Assuming I have only one connection as SYS:
select username, sid, serial#, logon_time, to_timestamp(logon_time)
from v$session