Hey Jared... Maybe another example for your external tables article? Tim Wolfson Larry - lwolfs wrote: >This is off the mark a little bit, but: > > I had a system that was getting killed by users doing Select >count(*) all the time. >When I asked them what they needed the information for they admitted to only >needing approximate values for the row counts. > Since we did full exports everyday I offered them an alternative of >executing a UNIX script that would display what had been exported the last >few weeks. This database only kept one export file on disk, but we had >quite a few logs. > > They'd run the command and get back something like the list below >only I included the correct date information for each line. > And they were very happy because it was a hell of a lot faster for >the larger tables and I was happy because they stopped clobbering the buffer >pool. > > Larry > >MSI_STATS_LOG 11813 rows exported >MSI_STATS_LOG 12202 rows exported >MSI_STATS_LOG 12573 rows exported >MSI_STATS_LOG 12927 rows exported > > >PS you can also generate the report without generating the dmp file. > > -- To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe To search the archives - //www.freelists.org/archives/oracle-l/