Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • changing kernel parameter in Oracle Enterpise Linux Linux/Unix
  • Monitor and Trace Unix processes using truss Linux/Unix
  • cur_sql.sql Oracle
  • To seee semaphores and shared memory segments in Solaris Linux/Unix
  • crtgr.sql /* For creating trigger from data dictionary */ Oracle
  • Caching sequence in Memory Oracle
  • OEM-troubleshooting on 20-MAY-08 Oracle
  • Building Our Own Namespaces with “Create Context” Oracle
  • dbms_job.submit example Oracle
  • runsql_once.ksh Linux/Unix
  • Find total file sizes Linux/Unix
  • Establishing trusted relationship between dbmonitor( central monitoring) and monitoring targets. Linux/Unix
  • Good link for LIO in Oracle ( Logical IOs) Oracle
  • Space padding in korn shell Linux/Unix
  • cif crons Linux/Unix

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 (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
  • Some OS level threshold for performance. Linux/Unix
  • restarting network in linux Linux/Unix
  • How to find Unix server conguraiton including Server Model number and underlying disk sub-system ( On Solaris) Linux/Unix
  • fuser to check who is using diretory Linux/Unix
  • to see when crontab is changed. Linux/Unix
  • Best approach for Oracle database patching sequence to latest/required patchset along with CPU/PSU/any-other-one-off patch ID 865255.1 Oracle
  • find_pk.sql /* Find Primary Key */ Oracle
  • Updated LCK.SQL file. Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme