skip to main | skip to sidebar

ORACLE DOCS

Tuesday, 8 July 2008

Block number of the row

dbms_rowid.rowid_block_number(rowid)

it simply returns the block number that the rowid points to.

select id, dbms_rowid.rowid_block_number(rowid) from t;
Posted by tjay at 11:58

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ▼  2008 (33)
    • ▼  July (33)
      • loading objects into shared pool
      • sga components used,free
      • log sequence number
      • statspack
      • sql_trace
      • schedules
      • job scripts
      • flashback scripts
      • PARALLELISM rman
      • Block number of the row
      • recovery question
      • blocks that reside in the buffer_cache
      • Hit Ratios
      • archivelog destination
      • DBWR and LGWR
      • database buffer cache, library cache
      • changing global_name
      • append and parallel hints, nologging
      • snapshot too old
      • enterprise manager
      • shrink_me
      • number of rows per block
      • shrink,alter table move,deallocate unused
      • corrupt blocks
      • droping all user_objects
      • redo scripts
      • rman scripts
      • tablespace usage
      • temp tablespace scripts
      • undo_retention
      • Some useful unix commands
      • Changing username
      • Rman scenerios

About Me

My photo
tjay
View my complete profile