RE: Few Questions.
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 15 Dec 2004 10:14:58 -0500
Ansers, of a sort, intermixed with questions.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Vinod Gopinath BMMI
IS
Sent: Wednesday, December 15, 2004 8:38 AM
To: oracle-l@xxxxxxxxxxxxx
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
