Re: Performance Problems
- From: "Michael McMullen" <ganstadba@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 23 Mar 2006 12:40:01 -0500
Are the tablespace locally managed? If so, wouldn't the read from
dba_data_files have to read from the datafile itself? I seem to remember
this from an experiment I did once. Locally managed tablespace on a mount,
take the mount away. read from dba_data_files didn't work. Switch to
dictionary managed and the repeat test and the select ran.
Mike
--
//www.freelists.org/webpage/oracle-l
Other related posts:
