Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Query to Generate aggregate on every 30 mins. Oracle
  • All Hints for Oracle Databases Oracle
  • Removing Ctrl-M from end of line using vi Linux/Unix
  • cache buffer chain latch Oracle
  • mutex in Oracle 10.2.0.2 or Oracle 10g Oracle
  • fdisk -l explaination about Primary-Logical-Extended Partitions Linux/Unix
  • CPU Core related projections AWS
  • currwaitobj.sql SQl_ID and SQL statement you can get from currwaitobj.sql Oracle
  • Directory wise folder wise space usage Linux/Unix
  • TNSNAMES entries details Oracle
  • Export Oracle data and Compress at same time Oracle
  • create trigger syntax Oracle
  • S3 Basic info AWS
  • DETERMINING WHICH INSTANCE OWNS WHICH SHARED MEMORY & SEMAPHORE SEGMENTS Oracle
  • Test Case for Inserting Multiple (2.3 Million rows in 26 Seconds) Oracle

Author: Admin

Implementation of key based authentications

Posted on 07-Oct-2005 By Admin No Comments on Implementation of key based authentications

*******************************************************************************************Step by Step Implementation of key based authentications from Source A to Destination B. ******************************************************************************************* (1) At source A (1-A) Generate a Key ssh-keygen -t dsa Above command creates a public key file called : id_dsa.pub and private key called id_dsa (1-B) Cat id_dsa.pub to the destination B and save as a file called authorized_keys…

Read More “Implementation of key based authentications” »

Linux/Unix, shell

Find Command

Posted on 06-Oct-2005 By Admin No Comments on Find Command

Following command gives, all files that are modified in last 4 days. find /IOTTOARCH/*.arc -mtime -4 -exec ls -rlt {} ; Following command gives, all files that are modified before last 4 days. find /IOTTOARCH/*.arc -mtime +4 -exec ls -rlt {} ;

Linux/Unix, shell

SAN

Posted on 04-Oct-2005 By Admin No Comments on SAN

For Example, Db size : 461 GB. On SAN EMC FC4700

Linux/Unix, shell

OPENING A STANDBY DATABASE IN READ-ONLY MODE

Posted on 30-Sep-2005 By Admin No Comments on OPENING A STANDBY DATABASE IN READ-ONLY MODE

OPENING A STANDBY DATABASE IN READ-ONLY MODE ——————————————— In order to perform queries on a read-only standby database, the database needs to be able to perform on-disk sorting operations. Locally managed temporary tablespaces do not record transactions in the data dictionary. Steps to create a locally managed temporary tablespace 1. Create a temporary tablespace on…

Read More “OPENING A STANDBY DATABASE IN READ-ONLY MODE” »

Oracle, rman-dataguard

Oracle Standby Database Library Index from Metalink

Posted on 30-Sep-2005 By Admin No Comments on Oracle Standby Database Library Index from Metalink

267931.1

Oracle, rman-dataguard

Test Case for Inserting Multiple (2.3 Million rows in 26 Seconds)

Posted on 29-Sep-2005 By Admin No Comments on Test Case for Inserting Multiple (2.3 Million rows in 26 Seconds)

========================= Test case On 29-SEP-2005 ========================= Original Statement: INSERT INTO pvm SELECT * FROM pvm1; Source table : pvm1 has 2.3 million rows. If statement executes normally it will take long time to execute. So i modified following statement and 2.3 Million rows processed in Approx 30 seconds. 10:39:11 CIF@CIF:-> set feedback 1 10:39:11 CIF@CIF:->…

Read More “Test Case for Inserting Multiple (2.3 Million rows in 26 Seconds)” »

Oracle, SQL scripts

Removing Blank lines from file using grep

Posted on 28-Sep-2005 By Admin No Comments on Removing Blank lines from file using grep

grep -v “^$” filename > newfilename

Linux/Unix, shell

Useful Solaris Commands on 28-SEP-2005

Posted on 28-Sep-2005 By Admin No Comments on Useful Solaris Commands on 28-SEP-2005

* To Print System Configuration /usr/sbin/prtconf Above command is useful to view Memory available to this system as following. /usr/sbin/prtconf | grep “Memory size” You can also use “top” command to see total RAM and swap info. * To see Available Processor Info. (Processor Info). psrinfo

Linux/Unix, shell

nfs mount command

Posted on 28-Sep-2005 By Admin No Comments on nfs mount command

mount -F nfs 192.168.6.36:/cdrom/cdrom0 /mnt

Linux/Unix, shell

Oracle 10g Installation/Applying Patches Tips

Posted on 28-Sep-2005 By Admin No Comments on Oracle 10g Installation/Applying Patches Tips

*******Oracle 10g Installation ******* On 27-Sep-2005****** (1) *** Warning During Oracle 10.1.0.2 installation **** Checking security kernel parameters Checking for noexec_user_stack=1; found Not found. Failed

Oracle, SQL scripts

Posts pagination

Previous 1 … 46 47 48 … 58 Next

Categories

  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Django (0)
  • GIT (1)
  • Linux/Unix (149)
  • MYSQL (5)
  • Oracle (397)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (150)
  • SQL scripts (345)
  • SQL Server (6)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • track_autoupgrade_copy_progress.sql01-Apr-2026
  • refre.sql for multitenant01-Apr-2026
  • prepfiles.sh for step by step generating pending statistics files10-Mar-2026
  • tracksqltime.sql05-Mar-2026
  • Complete Git Tutorial for Beginners25-Dec-2025
  • Postgres DB user and OS user.25-Dec-2025
  • 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

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Establishing trusted relationship between dbmonitor( central monitoring) and monitoring targets. Linux/Unix
  • longtx.sql Oracle
  • tblwopk.sql /* Find Tables Without PK */ Oracle
  • metalink all dynamic view reference notes. Oracle
  • Drop tempfiles from database Oracle
  • 556976.1 Oracle Clusterware: Components installed Oracle
  • Adding Datafile on Primary Server and Impact on Standby Server Oracle
  • Passing from Unix to PLSQL using bind variables Linux/Unix

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme