 | | | Oracle List | | I don 't think but you can analyze if is possible to use "bulk collect " in
your update
( see pl/sql user and reference guide)
----- Original Message -----
From "Lord David " <DLord@(protected)I seem to have spent this week doing some investigation into UTL_FILE
One of the oddities I came across which is sort of documented in metalink note 196939.1 and a tar I raised.
>From 9.2 you can
1. Did you notice a performance degradation ? Did your jobs take longer
to run ?
If not why worry about the "physical writes per transaction " ?
You haven 't shown how many transactions/second yDavid
Here 's an ugly solution using row_number(). I 'm not sure it 's any
better than what you already have.
SQL > select * from mike
COL1 COL2 KEY
---------- ---------- I use "vim ". It has "set syntax oracle " command or my favorite "set syntax perl "
and it isn 't as expensive as UltraEdit32. I have yet to find an editor capable of
supporting regular expressions --- "Khedr Waleed " <Waleed.Khedr@(protected) > wrote
> I found it (but I need root access) using adb -k
> -- > vol_maxio/D
>
> Thanks
>
> Waleed
you 're welcome.
Waleed
> -----Original Mess How can I find the default setting for vxio vol_maxio on Solaris 2.8?
There are many documents that have conflicting info about this. So I 'm
looking for some utility that can report this number.Oracle 8173 on Solaris
MT@(protected) > select distinct name from all_source where owner 'MT ' and
type 'PROCEDURE '
NAME
Dear list
While trying to retrieve some useful memory metrics from statspack data I
discovered
a couple of disconcerting problems with both statspack and v$sysstat.
Here 's an example of queryihi
i am in the process of setting up oracle gateway for communicating between oracle and mysql.
the oracle manual says very clearly that this kind of linking is possible. but it talks about some On 02/19/2004 05 33 54 PM David Sharples wrote
> server with a good cache on it.
Anyhow before we install Oracle
> and our app we
want to disk the disk IO performance - does anyone
> Hi everyone
I just noticed that Oracle have released three new security advisories
covering the database server 9iR1 and 9iR2 and also the application
server 9iR1 9iR2 and earlier. InterestinglOn 02/19/2004 03 22 05 PM "Jesse Rich " wrote
> Has anyone used the Technology-Based Training from Oracle before? Aside
> from being Windohs-only (which I can live with) I 've found a couple of oOn 02/19/2004 03 09 57 PM "Jesse Rich " wrote
>
> NOW maybe I can install 10g tonite... )
Rich these things are best done on St. Valentines Day when both Oracle
and Linux are in love anWolfgang "poll " system call polls an open file for an event like
"there is something to read " or "write will not block " and alike. Polling
is done by spinning so that is why you are burning CPU On 02/19/2004 02 11 04 PM "Koivu Lisa " wrote
> Hi everyone
Hi ! 20
>
> When I start an ftp session to binary send files off to another
> server
> I get the following message
>
> sehttps //www.redhat.com/solutions/industries/developer/
Finally. This seems like what we were looking for.
I was having difficulty getting a $749/yr subscription
justified for a development serverMichael
If this is a long running SQL statement and you start the trace while the
statement
is executing there 's a good chance you won 't see it in a trace file.
Gary Goodman or Cary Millsap wI would have to look at the module (not before next week).
I was surprised too that it was readily available at ActiveState FOR
Windows.
Stefan
-----Urspr?ngliche Nachricht-----
Von Jared As sqlplus can get sql files via http as of 9i I would not
if using HTTP_PROXY had some consequence.
Though I wouldn 't expect an error message on startup.
Jared
Stefan Jahnke <S
Well you can improve parsing by enabling query rewrite and
setting cursor_sharing to FORCE.
On 02/19/2004 11 31 22 AM Thomas Jeff wrote
> > We are experiencing sluggish performance with the AUListers
I 'm using send mail using the JSP according to DOC ID 120994.1 and I keep on getting
ora-600[26599] [1] [124] when I execute the test procedure.
I 've granted permissions loaded and relToad tora.
On 02/19/2004 11 17 14 AM Sue Johnson wrote
> I have the responsibility for a moderate size team which consists of
> experienced SQLPlus users as well as novice users. SQLPlus is
It was suggested that I rewrite the procedure using FORALL and a PL/SQL
table.
My initial attempt at this using in fact 3 pl/sql tables and inserting
every 10000 records yielded a reasonable perAllegedly TOAD only works if kissed by a beautiful princess.
On 02/24/2004 04 14 50 PM oracle-l-bounce@(protected) wrote
> I tried searching the TOAD list archives that
> Jacques recommendeMary there is no such thing as sql_execute. It sounds like a
name of subroutine. Can you browse through your code and
see whether you have something like "sub sql_execute { "? there?
If not look aI 'm considering designs for a system that processes batch data files. We 're thinking of allowing people to upload the data files from a PL/SQL Web application which means that each data file will beJust looking for suggestions / pointers for a NAS box...
Basic requirements are
no more than $15k or so
gigabit ethernet
as redundant as possible (power supplies etc.)
Total RAIDed storagHi Richard
Unfortunately "minimum extent " limitations is ignored when
using ALTER TABLE DEALLOCATE UNUSED KEEP.
A quick example below. Minumum extent size is 320 K but
my table extent is onl |
|
|
