v$filestat will tell you the number of I/Os and the average read/write
time on a particular data file. Don't forget to set timed_statistics=true.
calberto2312_at_hotmail.com (Carlos Alberto) wrote in message news:<72954535.0206030553.85ed69b_at_posting.google.com>...
> Hi,
>
> I run a script to load a table liked this :
>
> insert into a
> select * from b
> where ...
>
> After it run :
>
> Table A has 100 million records
> Table B has 47 million records
>
> The tables have the same structure, and they are on different
> tablespaces. Tablespace which b resides is in a 'large file'
> filesystem, while the other not.
> When I count the number of records of A, it takes about 10 minutes.
> For B, it takes about 15 minutes, although it has half of records.
> Besides it, any access to table B is slower than to A, with the same
> SQL. Can you explain me why? Is there any tool (or v$) to monitor the
> IO/seconds of one datafile/tablespace? I guess it could be a physical
> problem.
>
> Thanks in advanced,
> Carlos
Received on Mon Jun 03 2002 - 13:09:52 CDT
