Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Library cahe Latches and internal explaination Oracle
  • Gathering statistics with DBMS_STATS Oracle
  • Best approach for Oracle database patching sequence to latest/required patchset along with CPU/PSU/any-other-one-off patch ID 865255.1 Oracle
  • How to change hostname in Linux Linux/Unix
  • Renaming Global Name GLOBAL_NAME Oracle
  • newupload.html PHP/MYSQL/Wordpress
  • send attachment from unix-shell script Linux/Unix
  • Jai Shree Ram Oracle
  • My Test Case On 21-OCT-2005 Oracle
  • Implementing Listener Security Oracle
  • proper cpu stats Linux/Unix
  • Optimizer_Index init.ora parameter explaination. Oracle
  • Changing default shell Linux/Unix
  • _B_TREE_BITMAP_PLANS issue during 8.1.7 to 9.2.0.8 upgrade Oracle
  • DBMS_Shared_pool pinning triggers Oracle

Year: 2010

Committing distributed transaction using commit force

Posted on 22-Jan-2010 By Admin No Comments on Committing distributed transaction using commit force

Committing Using Only the Transaction ID The following SQL statement commits an in-doubt transaction: COMMIT FORCE ‘transaction_id’; The variable transaction_id is the identifier of the transaction as specified in either the LOCAL_TRAN_ID or GLOBAL_TRAN_ID columns of the DBA_2PC_PENDING data dictionary view. For example, assume that you query DBA_2PC_PENDING and determine that LOCAL_TRAN_ID for a distributed…

Read More “Committing distributed transaction using commit force” »

Oracle, SQL scripts

Rollback force for distributed transactions

Posted on 22-Jan-2010 By Admin No Comments on Rollback force for distributed transactions

FORCE Clause Specify FORCE to manually roll back an in-doubt distributed transaction. The transaction is identified by the text containing its local or global transaction ID. To find the IDs of such transactions, query the data dictionary view DBA_2PC_PENDING. A ROLLBACK statement with a FORCE clause rolls back only the specified transaction. Such a statement…

Read More “Rollback force for distributed transactions” »

Oracle, SQL scripts

How to find password change date for user

Posted on 13-Jan-2010 By Admin No Comments on How to find password change date for user

Check user$ table for same.

Oracle, SQL scripts

Sending email with file attachment.

Posted on 07-Jan-2010 By Admin No Comments on Sending email with file attachment.

Single File Attachemnt: ======================= cat test.dat|uuencode test.dat|mailx -s “subject” mailid Multiple file Attachment: ========================= (uuencode INPUTFILE $FILE_STRING.out ;uuencode INPUTFILE $FILE_STRING.err )|mailx -s “SUBJECT” $EMAIL_ID (uuencode INPUTFILE check_dr_notok.log ;uuencode INPUTFILE check_dr_ok.log )|mailx -s “Test multuple attachment” pmehta@1800flowers.com (uuencode check_dr_notok.log check_dr_notok.log ;uuencode check_dr_ok.log check_dr_notok.log)|mailx -s “Test multuple attachment” pmehta@1800flowers.com

Linux/Unix, shell

Kernel Parameters for Solaris

Posted on 05-Jan-2010 By Admin No Comments on Kernel Parameters for Solaris

* pre Solaris 10 * ——————- To view the current values of these parameters, enter the following commands: # grep noexec_user_stack /etc/system # /usr/sbin/sysdef | grep SEM # /usr/sbin/sysdef | grep SHM * Post Solaris 10 * =================== In Solaris 10, you are not required to make changes to the /etc/system file to implement the…

Read More “Kernel Parameters for Solaris” »

Linux/Unix, shell

Posts pagination

Previous 1 … 5 6

Categories

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

Recent Posts

  • load SPM baseline from cursor cache05-Jun-2025
  • Drop all SPM baselines for SQL handle05-Jun-2025
  • Load SPM baseline from AWR05-Jun-2025
  • Drop specific SQL plan baseline – spm05-Jun-2025
  • 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

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Very clear article about oracle dataguard Oracle
  • cp_filesystem.sql Oracle
  • fkwoindex.sql /* Find FK without Index */ Oracle
  • Best approach for Oracle database patching sequence to latest/required patchset along with CPU/PSU/any-other-one-off patch ID 865255.1 Oracle
  • This is im telling Kishore Oracle
  • checking redhat linux version Linux/Unix
  • Read CSV file using PySpark Python/PySpark
  • Processes Parameter decision Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme