Skip to content

Home
About Me
Toggle search form
Search for:

Test Case for Inserting Multiple (2.3 Million rows in 26 Seconds) Oracle
Multiple listeners Oracle
FRA Information. Oracle
fkwoind.sql fkwoindex.sql Oracle
Histogram Overview Oracle
Creating never expiring DB user accounts in Oracle Oracle
Changing default shell Linux/Unix
rm_backup_arch_file.ksh Linux/Unix
TRUNCATE Privs Oracle
Process Map for CPU and Memory for OS processes Linux/Unix
oracle 10g on linux Linux/Unix
Export Oracle data and Compress at same time Oracle
Find Time Consuming SQL Statements in Oracle 10g Oracle
dbms_job.submit example Oracle
Zip and unzip with tar 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

Mutating Table Error while using database trigger Oracle
How To Resolve Stranded DBA_2PC_PENDING Entries ID 401302.1 (Very Good prooven) Oracle
SQL_PROFILE – I explaination Oracle
Drop all SPM baselines for SQL handle Oracle
Implementing Listener Security Oracle
Settting up get_vmstat.sh for colletinf CPU Usage. 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 (400)
PHP/MYSQL/Wordpress (10)
POSTGRESQL (1)
Power-BI (0)
Python/PySpark (7)
RAC (18)
rman-dataguard (26)
shell (150)
SQL scripts (348)
SQL Server (6)
Uncategorized (3)
Videos (0)

Recent Posts

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
Creating a Container Database using dbaascli08-Apr-2026
track_autoupgrade_copy_progress.sql01-Apr-2026
refre.sql for multitenant01-Apr-2026
prepfiles.sh for step by step generating pending statistics files10-Mar-2026
tracksqltime.sql05-Mar-2026

Archives

2026
2025
2024
2023
2010
2009
2008
2007
2006
2005

Rollback force for distributed transactions Oracle
fkwoindex.sql /* Find FK without Index */ Oracle
OEM-troubleshooting on 20-MAY-08 Oracle
oracle tips… from http://www.bijoos.com/oracle/douknow.htm Oracle
currwaitobj.sql SQl_ID and SQL statement you can get from currwaitobj.sql Oracle
Search and Replace vi editor command. Linux/Unix
Caching sequence in Memory Oracle
kill all processes from specific user in solaris. Linux/Unix

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme