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

Philippe
  • 191
  • 2
  • 6

3 Answers3

7
SELECT * FROM V$VERSION;

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

weeheavy
  • 4,039
  • 1
  • 27
  • 41
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.

DCookie
  • 2,098
  • 17
  • 18
0
select * from product_component_version;

will return:

enter image description here

Franck Dernoncourt
  • 940
  • 1
  • 12
  • 28