Re: COM+ / IIS / and Oracle 8i on Win2k

pal..
u haven't specifically mentioned the where the problem occurs...if it is slow response time for a query or something, then probably u could *effectively* tune the SQL statements in the stored procedures u r calling with effective results....check or indexes, resource hungry joins etc......also of consequence is the technique ur using to bridge between ur COM components and the database.....

i personally feel there is something wrong there...in ur connectivity....as oracle databases are faster than SQL databases... i suggest u ask ur oracle expert to look into the oracle procedures......also check out the tablespaces and the rollback segments, datafiles etc for resource contention.....oracle though a vastly better database needs some tuning to kick out its stuff...

ciao
venkat

"JG" <seniag75_at_SPAMSUX.yahoo.com> wrote in message news:kwOp6.3669$Ac5.700105_at_e3500-chi1.usenetserver.com...
> Hello:
>
> We have built a web application where ASP pages call VB COM+ components,
> that in turn make stored procedure calls to an Oracle 8i (8.1.6) server.
> The ASP and COM+ components reside on one server, and the database is on
> another. Some of the components are transactional, and some are not.
>
> We originally built the application on SQL Server 7 and it screamed.
 After
> porting to Oracle, it is slow as a dog. Sometimes the pages will timeout
> waiting to get something back from the DB. This happens with both routine
> recordset requests as well as simple CRUD transactions. Nothing
 complicated
> or fancy. The app will run very slow for a few minutes, as if the server
 is
> trying to do a bunch of things at once, then it will speed up for a few
> minutes. This cycle repeats itself over and over again, though the app
 runs
> slowly more often than it does quickly.
>
> I admittedly know very little about Oracle performance tuning, but am
 trying
> to learn as much as I can. Has anyone been down this road before with IIS
> and COM+ and Oracle that could provide some pointers? I am specifically
> looking for settings that I might want to change in my Oracle config
 files,
> etc.
>
> I'm happy to provide any information you would like, and would be most
> grateful for any assistance.
>
> Kind Regards,
>
> JG
>
>
>
Received on Sat Mar 10 2001 - 05:52:55 CST