Performance question

To ALL,

    I believe I've asked this question before of the list, but got no answers so I'll ask once again since it's getting to become a real problem.

    We purchased a package from Etrade to manage the companies employee stock options. The package is called Equity Edge. The original, version 2.3, ran with Microsoft Access & though I hate to admit it it ran very well, just it was a single user system which did not make the finance folks happy. Anyway, Etrade upgraded it to version 3.x which ran using an Oracle backend. Not too bad, three tablespaces of about 100MB each. Problem is that reports and other things went from running in minutes to hours. So, we get another upgrade to 4.0 and things get a little better. Stuff that ran in 9+ hours now takes 6 hours. The sql in the background is pretty UGLY and I'm absolutely convinced that the problems are of Etrade's making.

    So the questions:

1. Is anyone out there supporting/using this package?
2. How long does your nightly utilitity run?

PS: It would be great if you could share the number of employees your supporting
(ballpark only, like plus/minus 100) and the average number of option plans.

Reply offline please, since this could get sensitive.

Thanks in advance. My finance folks will be greatful as we need all of the ammo we can get.

Dick Goulet

And I thought PeopleSoft was bad!!!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).