greasemonkey should have scripts for gmail inline HTML editor

select spid from v$process where addr=(select distinct paddr from v$session natural join v$mystat)

select distinct spid from v$process natural join (select paddr addr from v$session natural join v$mystat)

both works to tell the server process id, but i love the 2nd, for natural join is cool:)
so the plan below is for the 2nd version, which has the same cost as 1st version.
and i noticed the sort merge join :)

Id	_Operation	Name	Rows	Bytes	Cost (%CPU)	Time
0	_SELECT STATEMENT		1	185	1 (100)	00:00:01
1	__HASH UNIQUE		1	185	1 (100)	00:00:01
2	___NESTED LOOPS		1	185	0 (0)	00:00:01
3	____NESTED LOOPS		1	172	0 (0)	00:00:01
4	_____MERGE JOIN CARTESIAN		1	103	0 (0)	00:00:01
* 5	______FIXED TABLE FULL	X$KSUMYSTA	1	65	0 (0)	00:00:01
6	_______FIXED TABLE FULL	X$KSUSGIF	100	1300	0 (0)	00:00:01
7	______BUFFER SORT		1	38	0 (0)	00:00:01
* 8	_______FIXED TABLE FULL	X$KSUPR	1	38	0 (0)	00:00:01
* 9	_____FIXED TABLE FIXED INDEX	X$KSUSE (ind:1)	1	69	0 (0)	00:00:01
* 10	____FIXED TABLE FIXED INDEX	X$KSLED (ind:2)	1	13	0 (0)	00:00:01