miércoles, 10 de octubre de 2012

Buscar bloqueos en BD oracle

Como saber si tiene alguna query  que este bloquenado la BD? aqui esta la forma de saberlo.

select object_name, session_id,oracle_username, a.* from v$locked_object a, dba_objects b where a.object_id = b.object_id

1 comentario:

Anónimo dijo...

[url=http://fdaapproved.co.uk/products/lysexl.htm][img]http://onlinemedistore.com/4.jpg[/img][/url]
pharmacy workflow best practices http://fdaapproved.co.uk/products/retin-a-0-05-.htm online pharmacy adderl [url=http://fdaapproved.co.uk/products/cialis.htm]hague pharmacy norfolk virginia[/url]
picture nova southeastern university college of pharmacy http://fdaapproved.co.uk/products/entocort.htm midwest benefit pharmacy [url=http://fdaapproved.co.uk/products/serophene.htm]serophene[/url]
hopewill pharmacy http://fdaapproved.co.uk/products/sublingual-viagra.htm cheapest ambian us pharmacy [url=http://fdaapproved.co.uk/products/claritin.htm]niagara falls pharmacy cialis[/url]
pharmacy benefit management fraud http://fdaapproved.co.uk/categories/anti-herpes.htm pharmacy hershey pa [url=http://fdaapproved.co.uk/products/aciclovir.htm]aciclovir[/url]