Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • find_open_cur.sql Find open cursorts per session Oracle
  • Follwoing korn shell is used to move files from source folder to destination folder and gzip it in destination folder. mv_iotto.ksh Linux/Unix
  • Linux CPU info. Linux/Unix
  • This is im telling Kishore Oracle
  • crontab syntax Linux/Unix
  • For Search and replace unix command. Linux/Unix
  • findinfo.sql (SQL for getting CPU and Active session info) Oracle
  • Oracle 10g Wait Model Oracle
  • Caching sequence in Memory Oracle
  • PLSQL Table Syntax 1 Oracle
  • How does one overcome the Unix 2 Gig file limit? Linux/Unix
  • How to specify 2 arch location to avoid any kind of DB hanging. Oracle
  • Oracle Internal Good Websites 1 Oracle
  • find_string_in_database.sql Oracle
  • Unix split command to split files Linux/Unix

Category: shell

How to change hostname in Linux

Posted on 09-Apr-2008 By Admin No Comments on How to change hostname in Linux

=> Edit file /etc/sysconfig/network using your favourite editor. => Look for HOSTNAME=xxxxxx => Change the xxxx to the name you wish to set for your computer. (ex: HOSTNAME=techiecorner.com) => Save the file and restart the server.

Linux/Unix, shell

good linux notes

Posted on 09-Apr-2008 By Admin No Comments on good linux notes

http://tldp.org/HOWTO/Partition/intro.html

Linux/Unix, shell

fdisk -l explaination about Primary-Logical-Extended Partitions

Posted on 06-Apr-2008 By Admin No Comments on fdisk -l explaination about Primary-Logical-Extended Partitions

# fdisk -l Disk /dev/hda: 240 heads, 63 sectors, 1940 cylinders Units = cylinders of 15120 * 512 bytes Device Boot Start End Blocks Id System /dev/hda 1 286 2162128+ c Win95 FAT32 (LBA) /dev/hda2 * 288 1940 12496680 5 Extended /dev/hda5 288 289 15088+ 83 Linux /dev/hda6 290 844 4195768+ 83 Linux /dev/hda7 845…

Read More “fdisk -l explaination about Primary-Logical-Extended Partitions” »

Linux/Unix, shell

find the files that are 1 day old.

Posted on 15-Feb-2008 By Admin No Comments on find the files that are 1 day old.

find . -name “*” -type f -mtime -1 -exec ls -rlt {} ;

Linux/Unix, shell

on IBM-AIX for display

Posted on 08-Jan-2008 By Admin No Comments on on IBM-AIX for display

On IBM-AIX, vi was not working properly. Then set the environment variable as following and it started working. ( Thanks Magesh for same). $ export TERM=vt100 $

Linux/Unix, shell

Unix split command to split files

Posted on 28-Dec-2007 By Admin No Comments on Unix split command to split files

split -20 source_filename.lst test1 Above command will split source_filename.lst with every 20 lines. Will create files with 20 lines and with following names. -rw-r–r– 1 oracle dba 41 Dec 28 11:53 test1ag -rw-r–r– 1 oracle dba 2127 Dec 28 11:53 test1af -rw-r–r– 1 oracle dba 2240 Dec 28 11:53 test1ae -rw-r–r– 1 oracle dba 2243…

Read More “Unix split command to split files” »

Linux/Unix, shell

to see when crontab is changed.

Posted on 19-Dec-2007 By Admin No Comments on to see when crontab is changed.

sunflower1/800P>ls -rlt /var/spool/cron/crontabs total 138 -r——– 1 root root 452 Jan 21 2005 lp -rw——- 1 root sys 308 Nov 9 2006 sys -rw——- 1 root sys 317 Aug 20 18:51 adm -rw——- 1 root staff 5605 Oct 9 10:09 bbxuser -rw——- 1 root staff 5126 Oct 9 10:13 bkgr -rw——- 1 root staff 457…

Read More “to see when crontab is changed.” »

Linux/Unix, shell

adding new line after specific pattern using sed

Posted on 09-Nov-2007 By Admin No Comments on adding new line after specific pattern using sed

$cat t1.sql | sed ‘s/ORDER_DETAILS/ This is added newly/g’

Linux/Unix, shell

Search and replace pattern

Posted on 07-Nov-2007 By Admin No Comments on Search and replace pattern

#!/bin/ksh file_name=$1 old_templet=$2 new_templet=$3 # Loop through every file like this for file in file_name do cat $file | sed “s/old_templet/new_templet/g” > $file.new #do a global searce and replace and put the results mv $file.new $file #rename $file.new to original name of file done If you want to replace single pattern with a new pattern…

Read More “Search and replace pattern” »

Linux/Unix, shell

create a folder in multiple places

Posted on 31-Oct-2007 By Admin No Comments on create a folder in multiple places

for i in `df -k | grep EMCdb | awk ‘{print $6}’` do mkdir -p $i/oradata/800P done

Linux/Unix, shell

Posts pagination

Previous 1 … 6 7 8 … 15 Next

Categories

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

Recent Posts

  • 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
  • T-SQL Vs PL/SQL Syntax25-Jul-2025
  • Check SQL Server edition25-Jul-2025

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • backspace in SQL Plus not working then..? Linux/Unix
  • Oracle10g – Using SQLAccess Advisor (DBMS_ADVISOR) with the Automatic Workload Repository Oracle
  • alter database backup controlfile to trace Oracle
  • note id 373303.1 Linux/Unix
  • find_string_in_database.sql Oracle
  • Temporary Tablespsace Temp tablespace behaviour Oracle
  • DB Console Mainenance. Oracle
  • find_pk.sql /* Find Primary Key */ Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme