Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • shr1.sql for MTS or Shared server configuration Oracle
  • handling filenname with space Linux/Unix
  • runsql_once.ksh Linux/Unix
  • sqlnet.ora paramters Oracle
  • .profile Linux/Unix
  • SQL Server Vs Oracle Architecture difference SQL Server
  • scripts to take listener.log backup Linux/Unix
  • Getting started with notebook Python/PySpark
  • How to find who is using which Rollback segment and how many rows or blocks in that rollback segments, Oracle
  • longtx.sql Oracle
  • How to sort list of files on basis of their sizes. Linux/Unix
  • Jai Shree Ram Oracle
  • For Perl DBI installation and testing program PHP/MYSQL/Wordpress
  • block_ident.sql Oracle
  • note id 373303.1 Linux/Unix

Category: Linux/Unix

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

Small sample shell program

Posted on 31-Oct-2007 By Admin No Comments on Small sample shell program

for i in `df -k | grep EMCdb | awk ‘{print $6}’` do echo “Veeera said $i” 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 (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 (3)
  • Videos (0)

Recent Posts

  • Hello08-Apr-2026
  • Hello07-Apr-2026
  • Test107-Apr-2026
  • 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

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • cold backup scripts to copy locally Linux/Unix
  • Generating XML from SQLPLUS Oracle
  • GSQ.sql Oracle
  • temp_use.sql diplays usage of temp ts Oracle
  • TABLE SIZING WITH DB_BLOCK ARCHITECTURE Reference : Metalink note : 10640.1 Oracle
  • sqlnet.ora paramters Oracle
  • move_arch_files.ksh Linux/Unix
  • pvmehta.com SQL scripts
    Find which sessions is accessing object that prevent your session to have exclusive locks in Oracle Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme