Database Administration (MOSC)

MOSC Banner

block number mismatch with db block size

edited Feb 19, 2016 4:12AM in Database Administration (MOSC) 6 commentsAnswered

Hi,

This is block size of my database

SQL> sho parameter db_block_size

NAME                                 TYPE

------------------------------------ ---------------------------------

VALUE

------------------------------

db_block_size                        integer

8192

SQL>

I have create table like

CREATE TABLE row_mig_chain_demo (

  x int PRIMARY KEY,

  a CHAR(1000),

  b CHAR(1000),

  c CHAR(1000),

  d CHAR(1000),

  e CHAR(1000),

f CHAR(1000),

  g CHAR(1000),

  h CHAR(1000),

  i CHAR(1000));

inserted values to this

  1  begin

  2  for i in 20..100

  3  loop

  4  insert into row_mig_chain_demo(x) values(i);

  5  commit;

  6  end loop;

  7* end;

SQL> /

When I see block no. of all rows this shows same block no.?

SQL> select count(DBMS_ROWID.ROWID_BLOCK_NUMBER(rowid)),DBMS_ROWID.ROWID_BLOCK_NUMBER(rowid) from row_mig_chain_demo group by DBMS_ROWID.ROWID_BLOCK_NUMBER(rowid);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center