Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • This is im telling Kishore Oracle
  • The most important Tuning Notes Oracle
  • Oracle Standby Database Library Index from Metalink Oracle
  • Gather Stats manually using DBMS_STATS after disabling DBMS_SCHEDULER jobs as previous entry Oracle
  • Jai Shree Ram Linux/Unix
  • How to hide author name in WordPress BLOG PHP/MYSQL/Wordpress
  • Difference between SYNC and AFFIRM Oracle
  • ipcs -l Linux/Unix
  • ENQ: KO – FAST OBJECT CHECKPOINT tips Oracle
  • find_longsql.sql Oracle
  • to see when crontab is changed. Linux/Unix
  • database trigger failing Oracle
  • How To Resolve Stranded DBA_2PC_PENDING Entries ID 401302.1 (Very Good prooven) Oracle
  • 276434.1 Modifying the VIP or VIP Hostname of a 10g or 11g Oracle Clusterware Node Oracle
  • Proc Compilation 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
  • ORA-00064: object is too large to allocate on this O/S during startup Oracle
  • changing kernel parameter in Oracle Enterpise Linux Linux/Unix
  • PLSQL Table Syntax 1 Oracle
  • DBMS_UTILITY.ANALYZE_SCHEMA Oracle
  • Reading config file from other folder inside class Python/PySpark
  • Rename Tablespace Oracle
  • Alter procedure auditing Oracle
  • Distributed Transaction Troubleshooting. Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme