Re: Some doubts)
break out the concepts manual and start reading. joe [EMAIL PROTECTED] 08/08/01 10:25PM Hello gurus,I need some help here. I am trying to get some understanding of the following:- (Pardon my stupidity, if you can call this)1. What are chained rows?2. What is index/table partitioning?3. In case of getting a table fragmentation report, what does the following have a physical meaning:-pct_free ?pct_used?it says Rows = 130750,?but my actual table has got more no. rows than that, how did that happen, even though I just ANALYSED the table, I did a Estinate statistics though, does it matter, not a compute statistics.block_alloc?block hwm?MB alloc?MB hwm?%hwm bytes used?TIArajaGet 250 color business cards for FREE!http://businesscards.lycos.com/vp/fastpath/-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Viraj Luthra INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: Some doubts)
hi,
1.row chaining: see oracle8i concepts page 4-10.
2. partition: physically partition a table into several small tables, and logically
they are one table.
see detailed difinition at: oracle8i concepts 11-2.
- Original Message -
From: Viraj Luthra [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 09, 2001 10:25 AM
Subject: Some doubts)
Hello gurus,
I need some help here. I am trying to get some understanding of the following:-
(Pardon my stupidity, if you can call this)
1. What are chained rows?
2. What is index/table partitioning?
3. In case of getting a table fragmentation report, what does the following have a
physical meaning:-
pct_free ?
pct_used?
it says Rows = 130750,?
but my actual table has got more no. rows than that, how did that happen, even
though I just ANALYSED the table, I did a Estinate statistics though, does it matter,
not a compute statistics.
block_alloc?
block hwm?
MB alloc?
MB hwm?
%hwm bytes used?
TIA
raja
Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Viraj Luthra
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
æ¬zǶ¨}ø©ND ±@Bm§ÿðÃ
+iöªrºØhÈZ¢§DMÈZ¢§Éòj(rV
+r5ëp¢¹z»âqëçÎwó9ÔPó9ßÎtçT8'è®xæåÂ'µêçzÖqë,üÆ¢)à.+-±:Ã*.®Ç¥}úèØb²f¢)à+-±éÝjq
+ j)fzËëh.+-êî}«\Ü¢ièµá $ì¥éex(|¸¬´k«¹©Ý{azg¬±¨ àØw%¹×)Þríj)â
+I@ND º+¶§jg¨~f¢)à+-Ê°j{m¡·«zj/y×ë¢f(ºf²j[(±éݶ³Ü¢i×è®az¸§~æjبX¤z˱Êân)à
Re: Some doubts)
Hello, I read Oracle concepts, and came to know most of the questions (chap 10 and chap 25 and chap 11. Good one thank God I know some thing, it used to drive me nuts what the heck they are. Any way gurus some questions are still unanswered:- 1. it says Rows = 130750,? but my actual table has got more no. rows than that, how did that happen, even though I just ANALYSED the table, I did a Estinate statistics though, does it matter, not a compute statistics. 2. terms like block_alloc? block hwm? MB alloc? MB hwm? Please help. thanks. raja -- On Wed, 08 Aug 2001 18:25:24 Viraj Luthra wrote: Hello gurus, I need some help here. I am trying to get some understanding of the following:- (Pardon my stupidity, if you can call this) 1. What are chained rows? 2. What is index/table partitioning? 3. In case of getting a table fragmentation report, what does the following have a physical meaning:- pct_free ? pct_used? it says Rows = 130750,? but my actual table has got more no. rows than that, how did that happen, even though I just ANALYSED the table, I did a Estinate statistics though, does it matter, not a compute statistics. block_alloc? block hwm? MB alloc? MB hwm? %hwm bytes used? TIA raja Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
