4

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.)

3 Answers 3

7
SELECT * FROM V$VERSION;

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

1

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.

0
select * from product_component_version;

will return:

enter image description here

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .