FYI...
Oracle extended the desupport date for 8i by a year, end of error correction
support is now 31-dec-2004.
They posted that end of ECS for 9i Rel 2 will be 31-dec-2005, I am doubtful
about that, only 1 year lag time between two terminal releases?
Patrice.
--
Please see the official ORACLE-
do they mean the ora -03113 end of file communication error(number may be off)? Alot
of stuff causes that error.
that is a very vague response on their part.
>
> From: DENNIS WILLIAMS <[EMAIL PROTECTED]>
> Date: 2003/10/08 Wed PM 11:34:24 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL
Walid
TRUNCATE
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, October 09, 2003 3:29 AM
To: Multiple recipients of list ORACLE-L
Hi List ,
Can you help me please ,
What are the database parameters that i have to incre
I don't use snapshots, but have used EMC BCV's in the past and now use
IBM's Flashcopy for backups. I backup 1TB db in ~20 mins using
Flashcopy. Then I take it off to tape, i.e. filesystems monted on a TSM
Backup server, hence no resources needed from the production server :).
hth,
Gene>>>
Hi
Can You please give an example on using bund varables ..
THANKS
- Original Message -
> the striped array. However, this does not improve access time. If you
> have your tables and indexes on the same striped array, necessarily the
> two I/O's have to be done sequentially, incurring two times access time
> at a minimum. However, if you separate t
Hi ,
In Oracle Apps why concurrent manager and report
server
should be in database tier when other
application servers
are in application tier.?
Thx
Connor, you're the best!
On 2003.10.08 21:09, Connor McDonald wrote:
Cary, you're intention is good, but you need to take
the more effective (Dirty Harry) approach:
Customer: "It's Slow"
Me: What is?
Customer: The application. Make it fast.
Me: Maybe I can make it fast, maybe I can't. You've
got
At the risk of being dragged off and strung up (and keeping it brief as I am
very busy), I really thought it was quite good. Maybe it is the "change is
as good as a rest" syndrome.
Quite intuitive and fairly easy to get dramatic performance gains by
parameter tweaking and runstats (equiv. of analy
Hi,
What is volume of ur table, and 4 records that u want to delete is what
% of total records.
One thing that u can try is introduce index hint in delete statement. The
optimal solution can be find out only if know exact statement and volume of
tables and indexes.
Also can u check the size o
Peter, i would be interested in that.
can you mail it to me ?
Dias Costa
Robson, Peter wrote:
Yes, exactly Stephane -
Non-printable characters like this are a proper pest in our environment, to
the extent that I have exception reports running every night looking for
them (cannot trust the user
Peter, i would be interested in that.
can u mail it to me ?
Jp.
09-10-2003 18:29:33, "Robson, Peter" <[EMAIL PROTECTED]> wrote:
>I have a small PL/SQL piece of code used to detect these things, if anyone
>wants it.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Pre
Yes, exactly Stephane -
Non-printable characters like this are a proper pest in our environment, to
the extent that I have exception reports running every night looking for
them (cannot trust the users...).
I have a small PL/SQL piece of code used to detect these things, if anyone
wants it.
pete
Isn't this true when the query is a parallel query, i.e. when you're
doing a parallel index range scan using a partitioned index? In such
case, reading the index is the producer operation, and using the rowid
to retrieve the row from the table is the consumer operation, and the
data flow shoul
Hans,
Your statement is true except in the case of a fast full-index scan.
But that's not my point. What I'm trying to say is:
1. In scenarios where response time is important, for example when you
want to obtain the first n rows of a query result as quickly as
possible, then access time may
Steve,
If you are patient, I guess that something like
where dump(problem_column) like '%%'
should more or less answer your question.
HTH
SF
>- --- Original Message --- -
>From: "Steve Main" <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L
><[EMAIL PROTECTED]
use bind variable
-Original Message-
Sent: 09 October 2003 16:29
To: Multiple recipients of list ORACLE-L
Hi List ,
Can you help me please ,
What are the database parameters that i have to increase or modify in
order to increase the speed of my ddl
statments ,i have a statment tha
Hi List ,
Can you help me please ,
What are the database parameters that i have to increase or modify in
order to increase the speed of my ddl
statments ,i have a statment that delete a table with 4 record but it
takes about nine hours to accomplish !!!
Is their any parameters on the
101 - 118 of 118 matches
Mail list logo