Skip to content

Home
About Me
Toggle search form
Search for:

Check_recovery.sh program to run sqlplus and return its values remotely. Linux/Unix
Rownum with Order by Oracle
Trace a SQL session from another session using ORADEBUG Oracle
scripts to take listener.log backup Linux/Unix
Good notes for shared pool Oracle
create a folder in multiple places Linux/Unix
SCRIPT TO LIST RECURSIVE DEPENDENCY BETWEEN OBJECTS UTLDTREE.sql Oracle
Nice notes on wait events Oracle
findx.sql /* Find Indexes on specified USER.TABLE_NAME */ Oracle
Unix split command to split files Linux/Unix
How to find the real execution plan and binds used in that explain plan in Oracle 10g?? Oracle
Korn Shell Arithmatic Linux/Unix
Best approach for Oracle database patching sequence to latest/required patchset along with CPU/PSU/any-other-one-off patch ID 865255.1 Oracle
Optimizer SORT Operations Oracle
How to Decide upto what level you can decrement your datafile size. ( Shrink Datafile) 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

Pending Transaction Neighbors Script Oracle
How To Resolve Stranded DBA_2PC_PENDING Entries ID 401302.1 (Very Good prooven) Oracle
Find average Row Length and other table size calculation. metalink notes Oracle
Find which sessions is accessing object that prevent your session to have exclusive locks in Oracle Oracle
V$CONTROLFILE_RECORD_SECTION reference notes. Oracle
Privileges Required to Create Procedures and Functions that uses objects from other schema. 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 (393)
PHP/MYSQL/Wordpress (10)
POSTGRESQL (0)
Power-BI (0)
Python/PySpark (7)
RAC (17)
rman-dataguard (26)
shell (149)
SQL scripts (342)
SQL Server (6)
Uncategorized (0)
Videos (0)

Recent Posts

Trace a SQL session from another session using ORADEBUG30-Sep-2025
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

Archives

2025
2024
2023
2010
2009
2008
2007
2006
2005

process id based files and processes Linux/Unix
upload.html PHP/MYSQL/Wordpress
Proc Compilation Oracle
Wait.sql Oracle
Disbaling DBA_SCHEDULER_JOBS Oracle
How to set Processes Parameter Oracle
Implementing Listener Security Oracle
10g oem configuration Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme