"Ryan" <rgaffuri_at_cox.net> wrote in message
news:hO4Gb.45332$hf1.10390_at_lakeread06...
> We have a search screen that is used all the time. We are supposed to
> include a count of total records(since we will only be returning 25 at a
> time). I want to get rid of this. Its very costly. I know I can use the
> explain plan for this(i would use a global temp table, to get rid of
locking
> issues), but Im concerned about unnecessary queries on the data dictionary
> causing contention.
>
> any other suggestions? How do you handle search screens of this sort when
> users really want a total count of records found?
> also, how do i turn on autotrace from pl/sql? or something that resembles
> it? I think autotrace is a sqlplus command.
>
> I really want to get these counts out.
>
>
There are no locking issues. You do not need a temp table. This is not SQL
Server. Look at asktom.oracle.com and do a search. Best way is to just
give them 25 at a time and NOT try to count.
Jim
Received on Tue Dec 23 2003 - 21:04:13 CST
