Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SELECT table.currval FROM dual faster way to do this???
Is there a better way to do:
SELECT pdmlogseq.currval FROM dual
Seems like a lot of disk reads for a simple query?
First load time: 1999-06-15/11:42:07
Buffer gets: 3565 ratio 6 Disk reads: 2102 ratio 3 Rows delivered 26857 ratio 42 Executions 641 Parses 92 Memory 18569 Sorts 0 Invalidations 0
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Tue Jun 15 1999 - 06:33:04 CDT