3rd Chimp 3rd Chimp
3rd Chimp
3rd Chimp
3rd Chimp

Home

Chimplife
Writing
Stories
Places
Music
Tech
Got Mail
Doom

Pages
BCSC
Tascha
Footy
Fat Club
Squash

Trash
Origins
Ripples
Gimp

Am I Valid

Get Firefox!

Tech Pages

Some technology related info - things I may need to remember for future use. In general this page is probably not very interesting.

Unix Notes


In this section are various notes/examples relating to Unix (primarily AIX).

Filesystems

Performance

Miscellaneous


Oracle Notes


In this section are various notes/examples relating to Oracle

Estimate Rollback Time


You can estimate the time required for a rollback to finish using the following query
and a wall clock.

	select username
	,	sid
	,	status
	,	(select used_ublk from v$transaction
		where addr = v$session.taddr) ublocks
	from	v$session
	where	username = '&user';

Simply run the query and note the ublocks value. Then wait for a period of time
and run the query again. Subtract one from the other and you have a number of
blocks undone in a given period of time. The rest is easy.
	 

 

© Third Chimpanzee Net 2001 - 2005. All persons mentioned on this site are non-ficticious. Lawsuits are futile as funds are lacking.