Skip to content

Home
About Me
Toggle search form
Search for:

Some useful Unix Commands Linux/Unix
metalink all dynamic view reference notes. Oracle
Changing unix system clock when Oracle database is running. Oracle
how to find VIP from ifconfig Linux/Unix
DBMS_UTILITY PACKAGE Oracle
ORA-00064: object is too large to allocate on this O/S during startup Oracle
db_status.sql Oracle
longtx.sql Oracle
Passing from Unix to PLSQL using bind variables Linux/Unix
Renaming the column name Oracle
How To Transfer Passwords Between Databases (ref note: 199582.1) Oracle
SAN Linux/Unix
eplan.sql Oracle
Implementation of key based authentications Linux/Unix
Remove duplicate rows from table 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

ORA-4031 issue and solution on 09-MAY-2008 Oracle
RMAN : Consistent Backup, Restore and Recovery using RMAN Oracle
Finding locked objects Oracle
How To Resolve Stranded DBA_2PC_PENDING Entries ID 401302.1 (Very Good prooven) Oracle
longtx.sql Oracle
Exadata Basics 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)
Linux/Unix (149)
MYSQL (5)
Oracle (392)
PHP/MYSQL/Wordpress (10)
POSTGRESQL (0)
Power-BI (0)
Python/PySpark (7)
RAC (17)
rman-dataguard (26)
shell (149)
SQL scripts (341)
SQL Server (6)
Uncategorized (0)
Videos (0)

Recent Posts

SQL Server Vs Oracle Architecture difference25-Jul-2025
SQL Server: How to see historical transactions25-Jul-2025
SQL Server: How to see current transactions or requests25-Jul-2025
T-SQL Vs PL/SQL Syntax25-Jul-2025
Check SQL Server edition25-Jul-2025
Checking SQL Server Version25-Jul-2025
Oracle vs MYSQL Architecture differences (For DBAs)24-Jul-2025
V$INSTANCE of Oracle in MYSQL24-Jul-2025
Day to day MYSQL DBA operations (Compared with Oracle DBA)24-Jul-2025
MYSQL and Oracle Comparison for Oracle DBA24-Jul-2025

Archives

2025
2024
2023
2010
2009
2008
2007
2006
2005

create a folder in multiple places Linux/Unix
Find execution plan from dba_hist_sql_plan for a specific SQL_ID and PLAN_HASH_VALUE fplan.sql Oracle
Running select from V$ views from remote server Linux/Unix
remove archfiles only when it is applied to DR rm_archfiles.sh Linux/Unix
Renaming Global Name GLOBAL_NAME Oracle
To see mem usage and CPU usage system wide. Linux/Unix
rm_backup_arch_file.ksh Linux/Unix
Find Stale DR Physical Standby Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme