RE: Few Questions.

Ansers, of a sort, intermixed with questions.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Vinod Gopinath BMMI IS
Sent: Wednesday, December 15, 2004 8:38 AM To: oracle-l_at_freelists.org
Subject: Few Questions.

Gurus,
1. How does one know that there is a tablepspace fragemntion and once detected how do we remove that.

Tablespace fragmentation is a problem that was common under dictionary management of tablespaces. The use of locally managed tablespaces with uniform extents eliminates this problem. See the DBA Administration chapter on tablespace management for more details such as the actual definition.

2. What are chained rows?

Oracle unlike some of its competitors does not limit the length of a row to being less than the database block size. But this is only one of the two situations where rows are counted as being chained in the dba_tables.chained_cnt statistic and there is nothing you can or should do about it. I think you want to see the Concepts manual chapter on the relationship between Segments, Extents, and Blocks as I think the answer is there. If not the DBA manual has a chapter on object space management, look there next.

3. While doing an export what does compress = y and consistent = y means?

See the Utilities Manual. Each imp/exp parameter is explained there.

4. What does analyze tablespace with % does?

The only place I am aware that the "%" symbol is used in with the SQL LIKE operator. The analyze command applies to tables and indexes. The only way you analyze a tablespace is manually by reviewing its contents, parameters, growth patterns, etc.... In relation to the LIKE operator the "%" is a wild card. See the SQL manual list of relational operators.

5. Why is the purpose of repository in OEM?

To make the product more complex, and to help sell more disk. The alternate view is that it does what any repository does: holds metadata and history data.  

Would appreciate an answer on these.

What is this a school assignment? I have given you hints where to find your answers.  

TIA
Vinod.  

--
http://www.freelists.org/webpage/oracle-l