Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • How To Limit The Access To The Database So That Only One User Per Schema Are Connected (One Concurrent User Per Schema) Oracle
  • rm_backup_arch_file.ksh Linux/Unix
  • Sending email with file attachment. Linux/Unix
  • Check_recovery.sh program to run sqlplus and return its values remotely. Linux/Unix
  • Pending Transaction Neighbors Script Oracle
  • DETERMINING WHICH INSTANCE OWNS WHICH SHARED MEMORY & SEMAPHORE SEGMENTS Oracle
  • Set Role explaination. Oracle
  • logminer and my_lbu Oracle
  • xargs use Linux/Unix
  • Processes parameter and its dependencies on OS kernel parameters Linux/Unix
  • Export With Query Another Example. Oracle
  • Checking SQL Server Version SQL Server
  • runsql_once.ksh Linux/Unix
  • Virtual Indexes in Oracle Oracle
  • Giving Grant on v$DATABASE Oracle

Category: shell

Removing first line

Posted on 13-Jan-2006 By Admin No Comments on Removing first line

ssh webdbprod23 “df -k /db6/oradata/WEBP18F” | awk ‘{print $4}’ | sed ‘1d’ 1d for deleting first 1 line. 2d for deleting first 2 lines ans so on.

Linux/Unix, shell

To see only files and/or folders using LS command

Posted on 20-Dec-2005 By Admin No Comments on To see only files and/or folders using LS command

To see only files use follwoing command. ls -l | grep -v “^d” To see only folders use follwoing command. ls -l | grep “^d”

Linux/Unix, shell

Process Map for CPU and Memory for OS processes

Posted on 20-Dec-2005 By Admin No Comments on Process Map for CPU and Memory for OS processes

Remember : 2 commands to see OS stats. (1) TOP : This command will provide following information. SIZE column display Memory allocated to this process. RES column display Actually allocated memory for the process. tuningdb21->AWRTEST@(/db1/home/oracle/paresh)top load averages: 0.17, 0.15, 0.14 10:51:36 120 processes: 119 sleeping, 1 on cpu CPU states: % idle, % user, %…

Read More “Process Map for CPU and Memory for OS processes” »

Linux/Unix, shell

get_vmstat.ksh

Posted on 23-Nov-2005 By Admin No Comments on get_vmstat.ksh

select a.measured_date, a.total_users, a.active_users, b.user_cpu, b.system_cpu, b.idle_cpu, b.wait_cpu from stats$totalusers a, stats$vmstat2 b where a.measured_date = b.start_date and to_char(measured_date,’DD-MON-YY’)=’22-NOV-05′ and to_char(measured_date,’HH24′) > ’14’ and to_char(measured_date,’HH24′) < '19' order by measured_date desc Script that populates stats$vmstat2 table is dbblkabva01:/export/home/oracle/oraprocs/get_vmstat2.ksh ——– vmstats.ksh ————- #!/bin/ksh # First, we must set the environment . . . . ORACLE_SID=BLINKT export...

Read More “get_vmstat.ksh” »

Linux/Unix, shell

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

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

Posts pagination

Previous 1 … 11 12 13 … 15 Next

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
  • newupload.html PHP/MYSQL/Wordpress
  • OPENING A STANDBY DATABASE IN READ-ONLY MODE Oracle
  • Looping for remote servers and find its database from oratab file. Linux/Unix
  • How to calculate PROCESSES parameter Oracle
  • import-export with multiple files Oracle
  • TRUNCATE Privs Oracle
  • chk_space_SID.ksh Linux/Unix
  • ORA-1841 Error Connecting to Upgraded Database After Set PASSWORD_LIFE_TIME Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme