Skip to content

Home
About Me
Toggle search form
Search for:

Check Oracle installed products using one command Oracle
Good Link from metalink 1 Oracle
Useful Solaris Commands on 28-SEP-2005 Linux/Unix
Passing from Unix to PLSQL using bind variables Linux/Unix
Key Management in Oracle: The Core Issue: Missing Master Key Oracle
276434.1 Modifying the VIP or VIP Hostname of a 10g or 11g Oracle Clusterware Node Oracle
OPENING A STANDBY DATABASE IN READ-ONLY MODE Oracle
TOP-N Sql to find Nth max or Top N rows Oracle
Oracle vs MYSQL Architecture differences (For DBAs) MYSQL
How To Resolve Stranded DBA_2PC_PENDING Entries ID 401302.1 (Very Good prooven) Oracle
Good Doc 28-JUN-2006 Oracle
V$transaction notes for finding XID composition. Oracle
tuning commmand for cpu, ip and memory stats Linux/Unix
How to Modify the statistics collection by MMON for AWR repository Oracle
ipcs -l Linux/Unix

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

Changing Instance Name ( No DB_NAME) Oracle
Check Oracle installed products using one command Oracle
Wait time tuning research Oracle
SYSOPER Mystery Oracle
exp syntax in oracle 10g Oracle
column level grant syntax 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

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

Recent Posts

Tutornet.US — Source of excellent learning14-Oct-2026
OCI Infrastructure Patching14-Oct-2026
Free API credits for AI models14-Oct-2026
AMC1020-Sep-2026
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.sh23-Apr-2026
Running PDB on single node in RAC09-Apr-2026

Archives

2026
2025
2024
2023
2010
2009
2008
2007
2006
2005

prepfiles.sh for step by step generating pending statistics files Oracle
perf_today.sql Oracle
Oracle Support Metalink ID 161818.1 Oracle
Generating XML from SQLPLUS Oracle
Oracle 11g Environment Setup Oracle
usnsql.sql Displays information about UNDO segments with sql statements Oracle
pvm_metric.sql for gathering report from vmstat tables Oracle
find_idle_cpu.sql Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme