Skip to content

Home
About Me
Toggle search form
Search for:

Day to day MYSQL DBA operations (Compared with Oracle DBA) MYSQL
pvm_rbs1.sql (to collect rbs info from db) Oracle
temp_use.sql diplays usage of temp ts Oracle
find_pk.sql /* Find Primary Key */ Oracle
AWR settings- MMON is not taking snapshot. Oracle
Rollback force for distributed transactions Oracle
Logic to chech # of parameters command line parameters Linux/Unix
Handling LOB data in Oracle Oracle
move_arch_files.ksh Linux/Unix
Error Handling in Proc Oracle
replace alphabets using sed Linux/Unix
good note for shared pool tunnig Oracle
Optimizer_Index init.ora parameter explaination. Oracle
Remove duplicate rows from table Oracle
RMAN : Consistent Backup, Restore and Recovery using RMAN 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_cursor.sql find open cursor basis on username or SID Oracle
tblwopk.sql tablewopk.sql Oracle
How To Limit The Access To The Database So That Only One User Per Schema Are Connected (One Concurrent User Per Schema) Oracle
Oracle Standby Database Library Index from Metalink Oracle
Another Tuning Article for subheap of shared pool Oracle
To find explain plan for a statement that occurred in past. 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

Jai Shree Ram Oracle
Reclaim temp tablespace for oracle 8, 8i Oracle
In Addition to previous note, following grants needed on PERFSTAT user. Oracle
Multiple listeners Oracle
Read CSV file using PySpark Python/PySpark
crontab syntax Linux/Unix
remove archfiles only when it is applied to DR rm_archfiles.sh Linux/Unix
cold backup scripts to copy locally Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme