|
-
Thanks a lot....
I have one more query... I inserted two records...
SELECT sys.dbms_lob.getlength(text) FROM system.sameer;
gives me 5011 and 5011 bytes for first and second record resp..
When I inserted first record, BYTES in dba_segment where 32768 and when I inserted second record with same size, again it incremented by 32768 bytes. One more extent for allocated to LOB segment.
My question is when both records can fit into one extent easily (5011+5011 = 10022 which is < 32768 ) how come second extent got allocated to lob segment?
Sameer
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
|