Question
On the flash/SSD disks of my SAN, I prefer to put
Tables
Indexes
Tables and indexes
Redolog
The SAN manages this for me
I don't have flash/ssd disks
No idea or not applicable
Answer and see the results
DBA Top 10
1 M. Cadot 82850
2 A. Kavsek 42200
3 J. Schnackenberg 39200
4 T. Boles 34650
5 B. Vroman 32500
6 P. Wisse 26400
7 H. Shahi 17000
8 J. PĂ©ran 12450
9 K. Subramaniam 12300
10 M. Hidayathullah ... 11700
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Apr 07, 2015
(recommended update: build 1462)
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered47365
Total active users29893
Act. users last 24h33
Act. users last hour0
Hits last week1051
Hits last month4560
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, 08:39
Hi, Gather row+block+file+segment info then get...... Vinnie G Jan 07, 2008, 09:45
Thanks dragondb. Omar.... Omar Faruque Jan 07, 2008, 10:05
Hello Omar, more information, explanations, exa...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Bruno Vroman Jan 07, 2008, 11:13
Hi Bruno: Tnx 4 ur suggestion. I'll go through ...... Omar Faruque Jan 07, 2008, 12:08
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, 13:59
One addition to the above response. Extended ROWID...... Amar Kumar Padhi Jan 07, 2008, 14:08
SYSDATE is not a pseudo-column it is a function E...... Michel Cadot Jan 07, 2008, 14:13
Hi Michael, thanks for the correction. >SYSDAT...... Amar Kumar Padhi Jan 07, 2008, 16:51

Follow up by mail Click here


Subject: How is ROWID generated?
Author: Omar Faruque, Bangladesh
Date: Jan 07, 2008, 08:39, 2762 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, 09:45, 2762 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, 10:05, 2762 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, 11:13, 2762 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, 12:08, 2762 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, 13:59, 2762 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, 14:08, 2762 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, 14:13, 2762 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, 16:51, 2762 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