 | | | Oracle List | | Hi all
we are running OracleAS Web Cache 9.0.4.0 standalone on a RHEL ES 3 server with Macromedia Coldfusion.
This morning Webmaster made me notice a strange problem when someone is surfing the sit While everyone is correct that you need to solve the deadlock
issue you may not be able to solve that immediately (because app code
needs to be changed). A problem that accompanies deadlocks is thMichael
The sqlplus command COLUMN (or COL) by itself will show all of the
column definitions for the session. I 've edited the output to get rid of
extraneous definitions.
SQL > col
COLUMN droptWe had a logical production db at 10R1. After a few months we reverted back to physical standby exactly because of failing DML w/o appearent reason. It was typical that DML would fail for a highly upd > Subject Please disregard my previous email - simple spool does the trick.
> Regards rm
I read it just now so disregard mine too )
Dimitre
--
http //www.freelists.org/webpage/oracle-l
Hello everyone
I would like to inform y 'all that we have launched a carnival of the
vanities for the DBA world. We are hosting the first one but we would love
to call for volunteers to
1) submit aHi All
I am trying to find the "number of minutes " between "sysdate " and "flush_stamp ".
I have the following query which works but would like to find out if anyone has
more elegant way of doing th--
Regards
Ranko Mosic
Contract Senior Oracle DBA
B. Eng Oracle 10g 9i Certified Database Professional
Phone 416-450-2785
email mosicr@(protected)
http //ca.geocities.com/mosicr@(protected)/Contra > I need to be able to see commands executed on the sceen - they are not
> echoed now
Shell or sqlplus commands?
For shell use
#!/bin/ksh -v (to print shell input lines as they are read or -x if Hi
I have been in contact with Oracle Support about an ORA-00600 internal
error code arguments [12263] and they have declared it a bug in
Oracle 10g and passed it over to Development so I expTo be really sure I would modify "what " for this job i.e.
BEGIN insert into job_log(message job_date) values( 'start ' sysdate)
manhatten_com.poll_label insert into job_log(message job_date)
valYou could break up the exp into multiple exports by schema or table
list - and then run each of those to its own compressed file. This also
gives you the additional benefit of allowing you to run muHi everyone
We have a remote package with a variable in the spec in Server B. At the
beginning of a package of Server A we set this variable later we call
remotely a procedure on the server B usingHello all
I am trying to capture timed statistics (session logical reads) for a large
set of SQL statements. The script I wrote opens two SQL*Plus sessions one
to run the queries and one to collec The consistent split freezes the IOs so that its impossible for
a write to go to a disk that hasn 't split yet. However to the
database this still looks like a shutdown abort or a server crash.
> > > >
> > > > We will be introducing DB2 UDB into our shop in the near
> > >future. I am
> > > > looking for some information to become familiar with it.
> > > >
> > > > - Who are the respected individuals withI had the same thing with null values and function-based indexes. Oracle does not like it.
Oracle 10.1.0.5 on AIX 5.2 -
I have a user with a default temp tablespace of temp1 but when they execute some sql I have noticed that the tablespace
reported in the tablespace column of v$sort_usaMichael
Looking for the corruption can be useful and yes do dump block #2960
bearing in mind that block size is displayed in
V$ARCHIVED_LOG.BLOCK_SIZE and it is not DB_BLOCK_SIZE.
Most importHi all
As I understand it EM Database Control (against one database) comes with our Enterprise Edition database license. Does this mean we can access all pages in the EM Database Control with > The datafile is offline for many years already and we did not have
> problems before.
May be the access plan has changed.
Regards
Dimitre
--
http //www.freelists.org/webpage/oracle-l
Hello
I did some googling and could not come out with much. It seems to be indicating lot of COBOL could be involved. Has any of you worked on converting application systems / data from Tandem to OraI 've had good experiences in two cases (9.2.0.6 on AIX 5.2 & 10.2.0.2 on
AIX 5.3) using jfs2 with cio but I haven 't compared it to jfs so
couldn 't really say it was better.
-----Original Message--This error is nearly but not quite always caused by the archivelog
destination running out of space. You say that you checked disk space (I
assume you mean on e \). Another possible cause is that thBack to the basics.
I need any information on how CBO calculates [predicate] selectivity
which is more precise than in the Note 68992.1
This note states that "c1 > bind1 Default of 5% " >Every time I have a performance related call from the SIebel app support guys I test their SQL in both RBO and CBO. So far in every single case I was able to come up with a CBO plan that outperformHi
1) Double byte supports Japanese and Chinese and Korean Characters so of
you have to support entry in one of those then you will need double byte
single byte is basically for everything else
2) To
First of all - 10r2 does not support rule hints does it?
Next my understanding is that the biggest flaw in this CBO thing is the false believe that CBO is not RULE based.
Kind of "collect accura |
|
|
