Question
Are you using Oracle Streams?
Yes, actively in production
Yes, for test or less important systems
No, but we use GoldenGate
No
No idea or not applicable
Answer and see the results
DBA Top 10
1 M. Cadot 97800
2 B. Vroman 44000
3 A. Kavsek 39600
4 T. Boles 37500
5 P. Wisse 27100
6 Y. Naguib 23500
7 A. Khan 16550
8 J. PĂ©ran 16300
9 A. Hudspith 15600
10 F. Pachot 14750
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 54 now available

Feb 04, 2014
(recommended update: build 1403)
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered46924
Total active users29469
Act. users last 24h29
Act. users last hour1
Hits last week2143
Hits last month7969
Go up

How is ROWID generated?
Next thread: tracking application user
Prev thread: maximum session exceded

Message Score Author Date
Hi All: I ain't a DBA bt I wanna know how is RO...... Omar Faruque Jan 07, 2008
Hi, Gather row+block+file+segment info then get...... Vinnie G Jan 07, 2008
Thanks dragondb. Omar.... Omar Faruque Jan 07, 2008
Hello Omar, more information, explanations, exa...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Bruno Vroman Jan 07, 2008
Hi Bruno: Tnx 4 ur suggestion. I'll go through ...... Omar Faruque Jan 07, 2008
Hi Omar, here are some more facts from my side:- ...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Amar Kumar Padhi Jan 07, 2008
One addition to the above response. Extended ROWID...... Amar Kumar Padhi Jan 07, 2008
SYSDATE is not a pseudo-column it is a function E...... Michel Cadot Jan 07, 2008
Hi Michael, thanks for the correction. >SYSDAT...... Amar Kumar Padhi Jan 07, 2008

Follow up by mail Click here


Subject: How is ROWID generated?
Author: Omar Faruque, Bangladesh
Date: Jan 07, 2008, 2398 days ago
Message: Hi All:

I ain't a DBA bt I wanna know how is ROWID generated?

Please help me.

Omar.
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: How is ROWID generated?
Author: Vinnie G, China
Date: Jan 07, 2008, 2398 days ago
Message: Hi,

Gather row+block+file+segment info then get rowid ;
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: How is ROWID generated?
Author: Omar Faruque, Bangladesh
Date: Jan 07, 2008, 2398 days ago
Message: Thanks dragondb.

Omar.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: How is ROWID generated?
Author: Bruno Vroman, Belgium
Date: Jan 07, 2008, 2398 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Hello Omar,

more information, explanations, examples in Oracle documentation...
The ROWID depends on the Oracle version that you use, but for example here are two entries listed when searching for ROWID in Oracle 10g documentation;

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/pseudocolumns008.htm#sthref828

http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/datatype.htm#sthref3894

Even if you are not a DBA, I suggest you to have a look at the Oracle Documentation (start with "Concepts"); you will for sure find a lot of very interesting things!

Good reading,

Bruno Vroman.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: How is ROWID generated?
Author: Omar Faruque, Bangladesh
Date: Jan 07, 2008, 2398 days ago
Message: Hi Bruno:

Tnx 4 ur suggestion. I'll go through d doc. Actually I'm a developer & now trying 2 learn administrative parts.

Omar.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: How is ROWID generated?
Author: Amar Kumar Padhi, United Arab Emirates
Date: Jan 07, 2008, 2397 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Hi Omar,
here are some more facts from my side:-
- ROWID is a pseudo column, just like SYSDATE.

- It denotes the exact position on the disk where the required data is lying.

- It is not stored with the table but if the table has index it would be stored for data satisfying the indexed column(s).

- Data access by ROWID is the fasted mechanism of data retrieval. As this is stored in indexes, they improve SQL performance as the exact position on disk is available for reading (well yes, it also depends on how the indexes are being used and if the execution plan is optimal!).

- The actual format of ROWID is <Object number-relative file number-Block number-Row number>, this is represented in a ROWID as OOOOOOFFFBBBBBBRRR (numbers 6,3,6,3). This is the Extended ROWID format that is visible in 9i and above version.

- The ROWID format mentioned above changes for a BigFile tablespace, introduced in 10g. The format becomes <Object number-encoded Block number-Row number>, this is represented as OOOOOO-LLLLLLLLL-RRR (numbers 6,9,3).

Thanks!
amar
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: How is ROWID generated?
Author: Amar Kumar Padhi, United Arab Emirates
Date: Jan 07, 2008, 2397 days ago
Message: One addition to the above response. Extended ROWID is available from Oracle 8i. The ROWID format prior to this version is know as Restricted ROWID now.

Thanks!
amar
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: How is ROWID generated?
Author: Michel Cadot, France
Date: Jan 07, 2008, 2397 days ago
Message: SYSDATE is not a pseudo-column it is a function
Extended ROWID was available since 8.0 not 8i or 9i.
In OOOOOOFFFBBBBBBRRR and OOOOOO-LLLLLLLLL-RRR each element is not number in the sense of decimal number it is a 64-base number.

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: How is ROWID generated?
Author: Amar Kumar Padhi, United Arab Emirates
Date: Jan 07, 2008, 2397 days ago
Message: Hi Michael,
thanks for the correction.

>SYSDATE is not a pseudo-column it is a function
Yes you are right, I actually meant to say "ROWNUM" in the first place.

> Extended ROWID was available since 8.0 not 8i or 9i.
I personally did not remember this, thanks anyway.

> In OOOOOOFFFBBBBBBRRR and OOOOOO-LLLLLLLLL-RRR each element is not number in the sense of decimal number it is a 64-base number.
I never said it is decimal number, but it will be Fyi for the original poster.

Omar, you can further select the rowid on a table and check on its format.


Thanks!
amar
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here