Monday, September 17, 2012

To find if the database is patched with CPU or PSU

Pls run the below query to find which cpu psu patch applied on the database ,



col ACTION format a15
col NAMESPACE format a15
col version format a10
col COMMENTS format a42
col BUNDLE_SERIES format a20
col action_time format a30
select * from sys.registry$history;




For PSU:

opatch lsinventory -bugs_fixed | grep -i 'DATABASE PSU'

FOR CPU:

Issue the following select to list which CPU is implemented into each database:

set linesize 90
set pagesize 100
select substr(action_time,1,30) action_time,
substr(id,1,8) id,
substr(action,1,10) action,
substr(version,1,8) version,
substr(comments,1,20) comments
from registry$history;



No comments:

Post a Comment

How to Trouble shoot Logfile_sync wait event

   First  Identify and break down LGWR wait events. Query wait events for LGWR. In this instance LGWR sid is 3 (and usually it is). select s...