Skip to content

Home
About Me
Toggle search form
Search for:

sql_plan9i.sql Oracle
Monitor and Trace Unix processes using truss Linux/Unix
Find which sessions is accessing object that prevent your session to have exclusive locks in Oracle Oracle
Reading parameter file and printing Linux/Unix
find_open_cur.sql Find open cursorts per session Oracle
Jai Shree Ram Oracle
Virtual Indexes in Oracle Oracle
How to calculate PROCESSES parameter Oracle
create PLAN_TABLE command. Oracle
find_arc.sql Oracle
Best approach for Oracle database patching sequence to latest/required patchset along with CPU/PSU/any-other-one-off patch ID 865255.1 Oracle
751131.1 New Article Error 2819 While Requesting a Systemstate Dump Oracle
Very clear article about oracle dataguard Oracle
SQL Server: How to see current transactions or requests SQL Server
Temporary tablespace explaination Oracle

How to see which patches are applied.

Posted on 09-Jul-2010 By Admin No Comments on How to see which patches are applied.

There are 2 ways.

1) opatch lsinventory

2) select * from sys.registry$history;

Oracle, SQL scripts

Post navigation

Previous Post: Space padding in korn shell

Next Post: column level grant syntax

Related Posts

V$ROLLSTAT status is Full Oracle
TNSNAMES entries details Oracle
When error comes for temporary tablespace with version <= 9i Oracle
v$event_name Oracle
RMAN : Consistent Backup, Restore and Recovery using RMAN Oracle
Convert multiple rows to single column Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Comment *

Name *

Email *

Website

Save my name, email, and website in this browser for the next time I comment.

Categories

Ansible (0)
AWS (2)
Azure (1)
Django (0)
GIT (1)
Linux/Unix (149)
MYSQL (5)
Oracle (403)
PHP/MYSQL/Wordpress (10)
POSTGRESQL (1)
Power-BI (0)
Python/PySpark (7)
RAC (18)
rman-dataguard (26)
shell (150)
SQL scripts (350)
SQL Server (6)
Uncategorized (5)
Videos (0)

Recent Posts

Key Management in Oracle: The Core Issue: Missing Master Key12-May-2026
SAT Mathematics 10 questions and answer at the end.30-Apr-2026
top 10 AI news today30-Apr-2026
runon_allpdbs_show_conname.sh23-Apr-2026
runon_allcdbs_find_pdbs.sql23-Apr-2026
Running PDB on single node in RAC09-Apr-2026
find_arc.sql09-Apr-2026
pvm_pre_change.sql08-Apr-2026
find_encr_wallet.sql08-Apr-2026
find_pdbs.sql08-Apr-2026

Archives

2026
2025
2024
2023
2010
2009
2008
2007
2006
2005

Postgres DB user and OS user. POSTGRESQL
purge_trc.sh Linux/Unix
Global Unique Identifier Generation in Oracle 9.2 SYS_GUID() Oracle
Find long Running Transaction Linux/Unix
initUOCIOTTO.ora Oracle
Jai Shree Ram Oracle
FRA Information. Oracle
PLSQL Table Syntax 2 Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme