Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Absolute file number and relative file number Oracle
  • On solaris 10, “S” link is not part of $ORACLE_HOME/bin/oracle as default. ( For 9.2.0.8) Oracle
  • Adding Datafile on Primary Server and Impact on Standby Server Oracle
  • Establishing trusted relationship between dbmonitor( central monitoring) and monitoring targets. Linux/Unix
  • Oracle Material from OTN Oracle
  • handling filenname with space Linux/Unix
  • shr1.sql for MTS or Shared server configuration Oracle
  • good note for shared pool tunnig Oracle
  • How do I get Oracle to automatically start when my server boots up? Oracle
  • get_vmstat_solaris Oracle
  • find_cons.sql Oracle
  • For Search and replace unix command. Linux/Unix
  • To see how much time or progress of long transaction Oracle
  • send email from unix mailx with attachment. Linux/Unix
  • create trigger syntax Oracle

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)
  • Linux/Unix (149)
  • MYSQL (5)
  • Oracle (392)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (0)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • SQL Server (6)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • 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
  • MYSQL and Oracle Comparison for Oracle DBA24-Jul-2025

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • How to analyze statspack or AWR report. Oracle
  • How to find the real execution plan and binds used in that explain plan in Oracle 10g?? Oracle
  • Oracle 10g Wait Model Oracle
  • v$backup.status information Oracle
  • Oracle Statspack survival Guide Oracle
  • Settting up get_vmstat.sh for colletinf CPU Usage. Oracle
  • Checking SQL Server Version SQL Server
  • tblwopk.sql tablewopk.sql Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme