Re: Oracle oledb bug?

First of all just the idea you want to do this in a front end tool is
of course horrible. DDL is a server task, shouldn't be done in a front
end, and this code has nothing to do with proper administration. It is
just a plain utter nightmare, especially as you also expose the system
password which is still set to the default everyone knows

Yes, I knew I was going to regret not posting the disclaimer that this
was just a simple program to replicate our problem and not the actual
production code which is causing the issue...oh wait, I did do that

The actual scenario is as follows:

1.) Large csv files are uploaded through an application to a server
directory.
2.) Background service on server bulk loads the csv file using SQLLDR
into a staging table.
3.) Background service then makes a call to a package that runs
business rules on the bulk data to clean and/or reject it and then
loads it into the proper tables. This is where the problem lies. We've
found that during this load, when the database is fresh (no data so no
stats) and there is a large amount of data, the proper indexes aren't
used in the queries loading child/dependent tables (even with hints)
and the loads take forever. They are used if we gather stats after the
parent table loads. Everything was fine here until someone created a
composite index on one of these parent tables.

So there you have it, we are not using the actual system user for the
background service account, just a created user that has been granted
proper minimal rights to run the package. I guess my workaround for now
is to submit the call to the package as an oracle job.

That said, you should know, on your way to hell, that there are at
least a 1000 different causes for ora-3113 and those causes can only
be diagnosed by means of searching on Metalink, and/or submitting a
service request on this site.

Hence "ambiguous". I've checked the alert log and trace files and found
nothing. I've searched metalink and found nothing. I plan on submitting
a TAR, just wanted to know if someone here could offer something more
helpful than "You n00b, your example program is teh
sux0r!!!!1!111"...not sure what I was thinking

.

Relevant Pages

  • How to distribute MySQL over various machines (or otherwise up its performance)?
    ... of a Win2K server (running MySQL) on which MySQL takes up around 100% of ... current DB by assigning a proper DB scheme and by properly using ... for setting up a more robust and fast DB server (or server ... RAID 0 is not an option, it'll have to be fault tolerant. ...
    (freebsd-questions)
  • Re: CALs installed, but server still limited to 2 concurrent conne
    ... proper 'user rights' for the users to login. ... > application server mode. ... > that the maximum number of connections is set to Unlimited? ...
    (microsoft.public.windows.terminal_services)
  • Re: newbie: what if JavaScript is switched off in a browser?
    ... If you entirely disable the local fastish CPU by disabling javascript, ... OTOH, most nowadays JS applications, which use XHR for content update are extremely inefficient, by creating chunks of markup (all the load on the server side) and delivering those. ... JS enhanced pages have their benefits, but a statement like "I don't see how any proper big portal can offer any good experience for people without JS." ...
    (comp.lang.javascript)
  • Re: newbie: what if JavaScript is switched off in a browser?
    ... has to send the code that the client end runs. ... When using proper authoring, the transferred data of subsequent page ... and only the "raw" page markup needs to be transferred. ... on the server side) and delivering those. ...
    (comp.lang.javascript)
  • Re: Gaussian antenna planar form
    ... the real problem is that art is using a software program that makes proper ... Pretty much delusions of grandeur induced by a modeling program. ... I can make a simple dipole have loads and loads of gain in a ...
    (rec.radio.amateur.antenna)