 | | | Oracle List | | Hi
No problem with ES nor AS on 9i here.
Did your LINUX installer read Werner 's italic notes
about leaving a couple thousand extra file handles?
You might re-check the other configuration Not for Linux. Pete where are you?
On 03/22/2004 09 50 22 AM "Jesse Rich " wrote
> At least for HP/UX. Which works for me since I was waiting for it to
> correct a nasty ORA-600/ORA-7445 bug.
If you must have periodic commits the COPY command works very well.
set copycommit 5000 (5000 is as high as you can go iirc)
set long 65000 (if needed)
set arraysize 100 (or whatever)
copy <html >
<br >
I would think that the relationship would be similar to that between the
number of jobs and the number <br >
of job_queue_processes. <br > <br >
If your jobs or queue processes are not due LeRoy
Expect performance penalties of 2x on times for "bulk " inserts 3x-4x
penalty on "conventional " inserts and updates and up to 6x-8x penalty on
deletes. This is an option that shares a loHi
last week I investigate something interesting related to database work.
If your developers are working with form developer/2000 and they are using
blocks
(one block per table procedure or Each latch in the system has an entry in v$latch. For some latches
this is the only entry. For others there are additional entries in
v$latch_children. These latches have a set of children eacWoo hoo! That was the problem. Thanks! (Sometimes late on a Friday I just
can 't see the simple things anymore.)
----- Original Message -----
From "Tim Johnston "
> My last response was sparsMistyping a tnsentry in 10g gives
ORA-12154 TNS could not resolve the connect identifier specified
Hugely improved error message I think. I hope there was at least a 3 hour internal meetingIn addition to the comments that others have made about doing the whole thing in one insert possibly with nologging I 'd wonder about the index hint in the sql that you give and whether it is really The site I 'm working currently uses SunONE (previously called iPlanet) for
their LDAP services. Oracle Net name resolution is currently configured
through tnsnames. This is getting more and more unmThere is also the Rosetta Stone for Unix
http //bhami.com/rosetta.html
-----Original Message-----
From zhu chao [mailto chao_ping@(protected)]
Sent Mon 3/22/2004 4 07 AM
To oracle-l@(protected)
Hi All
OS 2.8 Solaris
We (DBAs) were informed recently that we were moving from NAS to SAN and
we were asked to move oracle apps stack (APPL_TOPs and COMMON_TOPs)
files from /u02 to /u0I know we 're not supposed to guess but this is
Windoze right?
If what I 've read in the thread is correct summary
1) You can get it started and stopped using the GUI
no problem.
2) Others mhi list friends
I have a primary database using partitioned table and a snapshot site
get the data from primary.
Whenever I add/drop partition on the partitioned table the snapshot log
> Something to keep in mind when contemplating a rebuild is that (unless
> you do LOTS of index fast full scans) performance will NOT be
> affected unless
> you can reduce the BLEVEL of the index.
<HEAD >
<META content "MSHTML 5.00.3315.2870 " name GENERATOR > </HEAD >
<BODY >
<DIV >It 's been a rough two weeks so I could certainly be wrong on this one. </DIV >
<DIV > </DIV >
<DIV >Let 's simplifyHi Dan
The problem you are contemplating cannot happen because when you plug in a
set of tablespaces the SCN is advanced if necessary to ensure that it is
higher than that of the source databaHoping someone can point me to a solution.
We are running 9.2.0.3 using Database Edition AC MP3.1
Solaris 8 on Hitachi storage array.
Once every other week veritas misses a heartbeat and
tellThe message returned by Forms was
FRM-40400 Transaction complete 1 records applied and saved
In the Oracle RDBMS "records " do not exist -- the database has "rows "
instead. So we know Hello
We have an OLTP system.
We would like to copy some tables data into an "archive " system.
Some part of data should be the exact copy of the original but some
should be "accumulated ".
In theHP-UX 11.11
Oracle 9.2.0.4 64bit
Been following Note 214834.1 on metalink about setting up HSODB on HP-UX. I
want to access a sqlsvr database from oracle. I 'm making the stub file to
relink the To do a tablespace point in time recovery you have to recover the
tablespace to a clone database and export the necessary data and import it
to the live database. You can 't do recovery to a live dby using a WHERE clause?
If you already have a where clause in your query then append the following
AND rownum < 100
>-----Original Message-----
>From manoj.gurnani@(protected) [mailt
On 03/16/2004 08 33 13 PM Stephen.Lee@(protected) wrote
>
> You know Sports Illustrated magazine figure out how to sell more magazines
> and increase circulation. I see no reason why Oracle boo
If I recall correctly put two of them together like " ".
> The column contains a " (double quote) used to designate inches
> such as 6 " which I think sql loader is choking on.
> Is there a wAre the UTC and GMT dates are same.
Somebody told me that the current difference between UTC and GMT is about 21 seconds.
Thanks
Ashoke
-----Original Message-----
From oracle-l-bounce@(protected)List
Here in the midst of Sarbanes Oxley I 've been pondering methods
that might be used to prevent a system administrator from connecting
to any databases running on that box.
I know that itAshoke -
In answer to the simple question how to find the bytes in a row of a
table the simplest way is to analyze the table then look at AVG_ROW_LEN
column in USER_TABLES view.
Dennis Wi > If you know which logfile to look in the following command should do
> it.
>
> ???????alter system dump logfile
> '/some/logfile ' layer 14 opcode 4
Btw is there a list of redolog layer |
|
|
