Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • How to specify 2 arch location to avoid any kind of DB hanging. Oracle
  • DBMS_Shared_pool pinning triggers Oracle
  • sess1.sql Oracle
  • v$event_name Oracle
  • changing kernel parameter in Oracle Enterpise Linux Linux/Unix
  • Oracle Data Direct to TAPE Oracle
  • rm_backup_arch_file.ksh Linux/Unix
  • currwait.sql Oracle
  • TABLE SIZING WITH DB_BLOCK ARCHITECTURE Reference : Metalink note : 10640.1 Oracle
  • Vivek’s egrep commands to trace problem. (on linux x86-64) Linux/Unix
  • Removing Blank lines from file using grep Linux/Unix
  • tblwopk.sql tablewopk.sql Oracle
  • cur_sql.sql Oracle
  • UTL_FILE test program Oracle
  • mutex in Oracle 10.2.0.2 or Oracle 10g Oracle

To see mem usage and CPU usage system wide.

Posted on 31-Aug-2005 By Admin No Comments on To see mem usage and CPU usage system wide.

Use

$ top

last pid: 17552; load averages: 0.04, 0.03, 0.04 15:16:01

93 processes: 88 sleeping, 2 zombie, 3 on cpu

CPU states: % idle, % user, % kernel, % iowait, % swap

Memory: 8192M real, 3841M free, 2867M swap in use, 5629M swap free

PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND

17551 oracle 1 22 0 3320K 2792K cpu/0 0:00 0.45% ls

17552 oracle 1 8 0 1864K 1256K cpu/1 0:00 0.27% top

17550 oracle 1 42 0 7408K 2248K cpu/3 0:00 0.06% sshd

17548 root 1 28 0 5864K 2248K sleep 0:00 0.06% sshd

12667 oracle 1 58 0 1124M 1051M sleep 0:07 0.03% oracle

12651 oracle 1 38 0 1125M 1061M sleep 0:02 0.02% oracle

12649 oracle 14 58 0 1128M 1053M sleep 0:06 0.02% oracle

11590 oracle 11 58 0 855M 780M sleep 0:04 0.02% oracle

361 root 13 20 0 7088K 6480K sleep 27:08 0.01% picld

11830 oracle 11 58 0 854M 780M sleep 0:03 0.01% oracle

22488 oracle 6 48 0 22M 9384K sleep 6:52 0.00% tnslsnr

13488 root 1 48 0 3168K 1624K sleep 4:22 0.00% sshd

1 root 1 58 0 880K 360K sleep 1:56 0.00% init

404 root 20 58 0 35M 21M sleep 0:37 0.00% vxsvc

24 root 1 58 0 9840K 8320K sleep 0:36 0.00% vxconfigd

Linux/Unix, shell

Post navigation

Previous Post: How to know Number of CPUs on Sun Box
Next Post: To seee semaphores and shared memory segments in Solaris

Related Posts

  • to see when crontab is changed. Linux/Unix
  • move_arch_files.ksh Linux/Unix
  • Changing default shell Linux/Unix
  • create a folder in multiple places Linux/Unix
  • Process Map for CPU and Memory for OS processes Linux/Unix
  • Adding addidional hard drive and attach it to a linux box. Linux/Unix

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (392)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • load SPM baseline from cursor cache05-Jun-2025
  • Drop all SPM baselines for SQL handle05-Jun-2025
  • Load SPM baseline from AWR05-Jun-2025
  • Drop specific SQL plan baseline – spm05-Jun-2025
  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • How to choose Driver table in SQL statement Oracle
  • How To Transfer Passwords Between Databases (ref note: 199582.1) Oracle
  • database trigger failing Oracle
  • Locally Managed Tablespace and Dictionary managed tablespace (LMT-DMT) Oracle
  • pvmehta.com SQL scripts
    Find which sessions is accessing object that prevent your session to have exclusive locks in Oracle Oracle
  • How To Resolve Stranded DBA_2PC_PENDING Entries ID 401302.1 (Very Good prooven) Oracle
  • find_open_cur.sql Find open cursorts per session Oracle
  • Specify the Rollback segment to use in Transaction Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme