Sounds like you need v$license :

http://otn.oracle.com/docs/products/...ch377.htm#5370