Object in hot file

[Guerra, Abraham J]

Title: RE: Unix - scheduling

 Hello Gurus,

 

Does anybody have a script to locate objects/segments within a file?  I have a tablespace that spreads into several files, but there is one of this files that is hot.  I would like to know which objects reside in this file.  The Oracle version is HP 8.1.7-64.

 

All help will be welcome.

 

Thanks.

 

Abraham J. Guerra
Senior Oracle DBA
American Family Insurance
(608) 242-4100 x32026