How well does the query run in sqlplus? Are you using bind variables? Have
you analyzed the table. What version od the database? What is the explain
plan?
Jim
"Percival Boqais" <pb_at_microsoft.com> wrote in message
news:MEts8.6055$DQ6.1211196544_at_newssvr15.news.prodigy.com...
> Trying to figure out a problem. I am a programmer, trying to help the
DBA.
> We have IIS 4, ASP code talking to a VB DLL. The VB DLL then runs queries
> against an Oracle database and brings back the data to the ASP page via
pipe
> delimited strings.
>
> We have one particular query which is actually using a view repeated
times,
> in the DLL. In other words, it brings back a list of Projects from the
DB,
> then calls the view to determine the Tasks (sub-level) and ETC on each
task.
> The view accesses about eight or nine tables. The table with the most
> records by far has roughly 70,000 records. The rest of the tables have
less
> than 2,000 records.
>
> Recently, this view started running very slowly. I don't know what went
on
> at the database side of things, but it's slow. I ruled ouf the web
server,
> as I accessed the DLL directly via a VB sandbox, it was slow there too.
The
> view consists of joins. Granted, on the 70,000 record table, there aren't
> indexes where they should be, but it's always been like that, even before
> things slowed down. As of last Thursday, the view which used to be fairly
> snappy, is now slow.
>
> I would say every week, 2-3,000 records are added to the 70,000 record
> table. I'm just wondering if there is some sort of limit that's been hit,
> or quota reached (tablespace?). I don't know as I'm not a DBA. Does
anyone
> else know why this would slow down? Sorry for the lack of details.
>
> ~ PB
>
>
Received on Tue Apr 09 2002 - 07:19:14 CDT
