Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • AWR settings- MMON is not taking snapshot. Oracle
  • How to choose Driver table in SQL statement Oracle
  • good linux notes Linux/Unix
  • get_ratio.sql get the ratio of users from v$session and this uses CASE-WHEN-THEN clause Oracle
  • Privilege to describe the table. Oracle
  • Insert cause enqueue locks Oracle
  • How to collect CPU usage on Linux using Shell script Linux/Unix
  • Updated LCK.SQL file. Oracle
  • get_vmstat.ksh for Solaris Oracle
  • Flowers Resize datafiles Oracle
  • compile_inv.sql Oracle
  • Optimizer SORT Operations Oracle
  • Mutating Table Error while using database trigger Oracle
  • Clean up Oracle
  • RMAN : Consistent Backup, Restore and Recovery using RMAN Oracle

Category: Oracle

How To Resolve Stranded DBA_2PC_PENDING Entries ID 401302.1 (Very Good prooven)

Posted on 11-Nov-2010 By Admin No Comments on How To Resolve Stranded DBA_2PC_PENDING Entries ID 401302.1 (Very Good prooven)

Ref ID: How To Resolve Stranded DBA_2PC_PENDING Entries [ID 401302.1] Issue: We had network outage and there were some distributed transactions with dblinks hangs. Causing issue when trying to update some rows of the base table. Problem Discription: ==================== As a result of a failed commit of a distributed transaction, some entries canbe left in…

Read More “How To Resolve Stranded DBA_2PC_PENDING Entries ID 401302.1 (Very Good prooven)” »

Oracle, SQL scripts

Oracle Recommended Patches — Oracle Database ID 756671.1

Posted on 20-Oct-2010 By Admin No Comments on Oracle Recommended Patches — Oracle Database ID 756671.1

Oracle Recommended Patches — Oracle Database Target Configurations Patch Availability Current Recommended Patches 11.2.0.2 Current Recommended Patches 11.2.0.1 Current Recommended Patches 11.1.0.7 Current Recommended Patches 11.1.0.6 Current Recommended Patches 10.2.0.5 Current Recommended Patches 10.2.0.4 Current Recommended Patches 10.2.0.3 Current Recommended Patches Conflict Resolution On Request Known Issues References Beginning with release 10.2.0.3, Oracle releases Recommended…

Read More “Oracle Recommended Patches — Oracle Database ID 756671.1” »

Oracle, SQL scripts

Is It Recommended To Apply Patch Bundles When PSU Is Available? -ID 743554.1

Posted on 20-Oct-2010 By Admin No Comments on Is It Recommended To Apply Patch Bundles When PSU Is Available? -ID 743554.1

Applies to: Oracle Server – Enterprise Edition – Version: 10.2.0.4 to 11.2.0.1 – Release: 10.2 to 11.2 Information in this document applies to any platform. Oracle Server Enterprise Edition – Version: 10.2.0.4 to 11.2.0.1 Goal 1.Do you still need to apply Patch Bundles for a certain patchset level when Patch Set Update (PSU) for that…

Read More “Is It Recommended To Apply Patch Bundles When PSU Is Available? -ID 743554.1” »

Oracle, SQL scripts

Consolidated Reference List Of Notes For Migration / Upgrade Service Requests -ID 762540.1

Posted on 20-Oct-2010 By Admin No Comments on Consolidated Reference List Of Notes For Migration / Upgrade Service Requests -ID 762540.1

Applies to: Oracle Server – Enterprise Edition – Version: 8.1.7.4 to 11.2.0.2 – Release: 8.1.7 to 11.2 Oracle Server – Standard Edition – Version: 8.1.7.4 to 11.2.0.2 [Release: 8.1.7 to 11.2] Information in this document applies to any platform. Oracle Server Enterprise Edition – Version: 8.1.7.4 to 11.2.0.2 Purpose The purpose of this document is…

Read More “Consolidated Reference List Of Notes For Migration / Upgrade Service Requests -ID 762540.1” »

Oracle, SQL scripts

Best approach for Oracle database patching sequence to latest/required patchset along with CPU/PSU/any-other-one-off patch ID 865255.1

Posted on 20-Oct-2010 By Admin No Comments on Best approach for Oracle database patching sequence to latest/required patchset along with CPU/PSU/any-other-one-off patch ID 865255.1

Applies to: Oracle Server – Enterprise Edition – Version: 10.2.0.1 to 11.1.0.7 Information in this document applies to any platform. Goal This article helps to plan oracle database patching sequence to the latest/required patchset version with in the same release (ex: 10.2.0.1 to 10.2.0.4) along with CPU/PSU/One-off-patch installations. Solution Basically there are two entities in…

Read More “Best approach for Oracle database patching sequence to latest/required patchset along with CPU/PSU/any-other-one-off patch ID 865255.1” »

Oracle, SQL scripts

Oracle Support Metalink ID 161818.1

Posted on 20-Oct-2010 By Admin No Comments on Oracle Support Metalink ID 161818.1

Oracle Database (RDBMS) Releases Support Status Summary [ID 161818.1] Oracle Database (RDBMS) Releases Support Status Summary Information here was last updated on 14-Sep-2010 This note shows the current main Oracle Database releases along with information about the support status of each release and its Patch Sets. To see the main support alerts and Patch Set…

Read More “Oracle Support Metalink ID 161818.1” »

Oracle, SQL scripts

AWR license

Posted on 12-Oct-201022-May-2023 By Admin No Comments on AWR license

ref: http://blog.tanelpoder.com/2009/05/06/free-dba_hist-awr-views-in-11g/ When you access Oracle AWR (and other licensed features/tables/views) then these do show up in DBA_FEATURE_USAGE_STATISTICS. Exporting the contents is the same as accessing these with your SQL. All data dictionary views beginning with the prefix DBA_HIST_ are part of this pack, along with their underlying tables.The only exception are the views: DBA_HIST_SNAPSHOT,…

Read More “AWR license” »

Oracle, SQL scripts

Oracle Material from OTN

Posted on 08-Sep-2010 By Admin No Comments on Oracle Material from OTN

Oracle Learning Library ======================= http://apex.oracle.com/pls/apex/f?p=9830:41:0::NO Getting Started with Oracle SQL Developer ========================================= http://st-curriculum.oracle.com/obe/db/11g/r2/prod/appdev/sqldev/sqldev_mngdb/sqldev_mngdb_otn.htm Using Source Code Control in Oracle SQL Developer ================================================= http://st-curriculum.oracle.com/obe/db/11g/r2/prod/appdev/sqldev/srccodexmlext/srccode_otn.ht

Oracle, SQL scripts

column level grant syntax

Posted on 22-Jul-2010 By Admin No Comments on column level grant syntax

grant update (colum1, col2) on owner.table_name to other_user/role;

Oracle, SQL scripts

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

Posts pagination

Previous 1 2 3 4 … 39 Next

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (388)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (337)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024
  • Reading config file from other folder inside class24-Sep-2024
  • Python class import from different folders22-Sep-2024
  • Transfer SQL Profiles from One database to other database.05-Sep-2024
  • Load testing on Oracle 19C RAC with HammerDB18-Jan-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • scripts to take listener.log backup Linux/Unix
  • Debugging Shell FIles Linux/Unix
  • get_vmstat_solaris Oracle
  • Python class import from different folders Python/PySpark
  • DBMS_PROFILER for tuning PLSQL programs. Oracle
  • get_aix_vmstat.ksh Oracle
  • GSQ.sql Oracle
  • remove archfiles only when it is applied to DR rm_archfiles.sh Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme