Re: LOB segment space usage

On Aug 18, 12:11 am, Maxim Demenko <mdeme...@xxxxxxxxx> wrote:
andreik schrieb:

On Aug 17, 5:29 pm, Maxim Demenko <mdeme...@xxxxxxxxx> wrote:
andreik schrieb:

I can hardly explain your results, because my tests can't confirm them
SQL> SET SERVEROUTPUT ON
SQL> SELECT * FROM V$VERSION
2 /

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for Linux: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production

SQL> SELECT VALUE
2 FROM NLS_DATABASE_PARAMETERS
3 WHERE PARAMETER = 'NLS_CHARACTERSET'
4 /

VALUE
-----------------------------------------------------------------------------------------------------------------------------
AL32UTF8

You have UTF and your database charset that's why your LOBs have 2
bytes per character even in CLOBS. And I have a simple single-char
character set in my database so my clobs were not supposed to be 2
byted.

Anyway, the 60K overhead per block was the answer to my question.

But thanks for your help! Tanel's document is a real good one. Helped
me a lot.

-- Andrei

.

Relevant Pages

  • RE: help with emergency--sql server 2000 sp4
    ... I told my myself, I need to take a look at my testing database, I suddenly I ... some my production program gives invalid object error messge. ... We have two database instances on our server. ... Your ASP program failed to execute DML operations on your SQL Server after ...
    (microsoft.public.sqlserver.odbc)
  • Re: Restoring data
    ... 'Since you can't restore SQL2K db to 7,0, you won't have a starting point ... Tibor Karaszi, SQL Server MVP ... > database. ... >>> addresses between the existing production server and the ...
    (microsoft.public.sqlserver.setup)
  • Strings in UTF8 Database
    ... the only difference is that the first database is a UTF8 database and ... PL/SQL Release 10.2.0.2.0 - Production ... SQL> -- How long is a 40 charecter string? ...
    (comp.databases.oracle.server)
  • Re: Restoring data
    ... Can I apply SQL 2000 tranaction logs to the original ... database. ... >> addresses between the existing production server and the ...
    (microsoft.public.sqlserver.setup)
  • Re: Bug when dividing an INTERVAL
    ... SQL> ed ... SQL> set serveroutput on ... PL/SQL Release 10.2.0.1.0 - Production ... Ah, thanks Mark. ...
    (comp.databases.oracle.misc)