Skip to content

Home
About Me
Toggle search form
Search for:

How to find where datafile is created dbf_info.sql Oracle
copying/removing directory with all its subdirectory Linux/Unix
cif crons Linux/Unix
scp with ssh2 Linux/Unix
dbms_job.submit example Oracle
scripts to take listener.log backup Linux/Unix
Gathering statistics with DBMS_STATS Oracle
Temporary Tablespsace Temp tablespace behaviour Oracle
RAC 11g with vmware Oracle
Renaming Oracle Instance Name Oracle
find_pk.sql /* Find Primary Key */ Oracle
track_autoupgrade_copy_progress.sql Oracle
column level grant syntax Oracle
create user with unlimited quota Oracle
findobj.sql 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

sid_wise_sql.sql Further explaination Oracle
New OFA for 11g Oracle
Goog notes on X$ tables Oracle
Library cahe Latches and internal explaination Oracle
ORA-00064: object is too large to allocate on this O/S during startup Oracle
Oracle Internal Good Websites 1 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 (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 (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.sh23-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

True Session Wait Activity in Oracle 10g Verygood Oracle
Changing unix system clock when Oracle database is running. Oracle
find_err.sql for finding errors from dba_errors. Oracle
CTAS with LONG Column for 7.x and 8 and 8i Oracle
sql_plan9i.sql Oracle
switchlogfile.sh Linux/Unix
Adding or Dropping Online Redo Log Files When Physical Standby in place Oracle
Facts about SCN and Rollback Segment Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme