How can I find my Oracle 10g server version?

Question

I don't have physical access to my Oracle server but I can run some sql command from Toad. Is there a way I can find wich version the server is running, like 10.2.3.1. I know it's 10g but I'd like to know wich patchs and maybe more (memory used, buffers, etc.)

Answer 1

SELECT * FROM V$VERSION;

More here: http://www.adp-gmbh.ch/ora/misc/dynamic_performance_views.html

Answer 2

In addition, to the accepted answer, you can find out the patches that have been applied by querying the registry$history table:

select id,action,comments from registry$history;

This table is normally only visible to the SYS user.