row length

[pramathesh]

Dear Friends,

I need of u'r to find out the min and maximum lenght of a row in byte.
next; One of my database is not able shutdown normally. what i will do to shut it dwon normally ?


Thaning u in advance
pramathesh

Well friends, i really apreciate the answers. Thank u all . But let me know one thing , does oracle store the number data as similar to charecter data ? Oracle says, to calculate the size of a number field , one should use the following rule,

floor(length(col)/2)+2.
how far it is correct ?

Note :- i wanted this information to fine tune then block utilization parameters . The database is having a high row chaining and i wannted to find out a simpler method to find out the min and max row length.

However i have not yet tried the formula's , i will let u all know the result , tomrrow.


Regards
pramathesh

[Edited by pramathesh on 03-05-2001 at 10:22 AM]

[garry]

select count(column)+count(column) from table
will give u the bytes of a row.
about database could you please specify alittle more.
like what's your proble?

[jeyaseelan]

Pramth,If i understand your question correctly,Please try this one to find out the min/max lenth of a row


select max(vsize(col1)+vsize(col2)...vsize(coln)),min(vsize(col1)+vsize(col2)..vsize(coln) from <table>



Regarding Shutdown Normal,Quarry is correct.

But still u can try out this one.

Since u had tried shutdown normal,oracle will try to shutdown the system,due some errors(????) it is not able to complete the shutdown.Now,You can start the database with startup force.and do proper shutdown.

[jeyaseelan]

Pramth,If i understand your question correctly,Please try this one to find out the min/max lenth of a row


select max(vsize(col1)+vsize(col2)...vsize(coln)),min(vsize(col1)+vsize(col2)..vsize(coln) from <table>



Regarding Shutdown Normal,Quarry is correct.

But still u can try out this one.

Since u had tried shutdown normal,oracle will try to shutdown the system,due some errors(????) it is not able to complete the shutdown.Now,You can start the database with startup force.and do proper shutdown.

M.Jeyaseelan
Larsen&Toubro Limited
Hyderabad

[hrishy]

the query given by jayseelan is the right one as the other one merely giives you the row count .in order to shutdown oracle use this command shutdown immediateat svrmgr prompt

hth

[sambavan]

Does any one see an funcky, thread display tree format on this thread?

----

jayaseelan---|
|----jayaseelan|----------
|
garry-------

Is it ny system or it is global :confused:

Sam

[Edited by sambavan on 03-05-2001 at 09:46 AM]

[Dave_A]

I guess it must be global - I can see posts indented as well.