-
Sorry, Urgent because I am supposed to do some basic sizing structures on this statistics, table growth etc. and I could not even start due to this.. Anyway thanks all for your time ..
So just to summarize can I say that I got avg_row_len 0 because there were 0 rows ? ( frankly I wasn't aware of this !)
Thanks..
OCP 8.0, 8i, 9i
-
MH - If you don't understand it, it could mean the the db is ****ed. It might have been urgent.
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
-
I dont understand... so common sense a thread with 11 posts!
If you are given a table with 0 rows how do you calculate the average row length?
Let´s do some mathematics
If there were 10 rows I would simply
sum(row_length)/num_rows
if num_rows is 0 what we get?
infinity
-
Originally posted by DaPi
MH - If you don't understand it, it could mean the the db is ****ed. It might have been urgent.
I disagree, if that is your only guidlinde for a fawked database, your job may be in jeapordy.
MH
I remember when this place was cool.
-
MH - If I don't understand, I worry. I think that has helped me to keep my job!
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
-
You must spend a LOT of time worrying then because I have yet to met anyone that undestands all things available in Oracle. Curios, yes, worry, no.
I will end this verbal tit for tat now and wish you all good holiday cheer.
MH
I remember when this place was cool.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|