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;
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
tjay
View my complete profile
No comments:
Post a Comment