Checking memory usage with vmstat

My sys admin doesn't have top available for us so I've had to get used to using vmstat to check memory usage on Unix. It's definitely less user friendly than top, but you can find you need from it.

Here's some sample output from vmstat:

kthr          memory     page   disk faults   cpu
r b w swap    free re mf pi po fr de sr m0 m1 m3 m1 in sy cs us sy id
0 0 0 6344224 925064 90 1188 68 0 0 0 0 0 0 0 0 693 6219 2155 13 2 85
0 0 0 6344416 924360 94 753 880 0 0 0 0 0 0 0 0 526 4779 1575 5 1 93
0 0 0 6348552 928080 94 1223 147 0 0 0 0 0 0 0 0 706 8063 2139 19 2 79

The swap column shows the amount of available swap space. The free column is the amount of memory available from the free list (physical memory). Both are listed in kilobytes.

Comments

Post a Comment

Popular posts from this blog

Auditing user logon and logoff in Oracle

To track when a user logs on or off Oracle, enable auditing and audit CONNECT in your database.  Then you can query DBA_AUDIT_TRAIL to find logon and logoff info. alter session SET NLS_DATE_FORMAT = 'DD-MM-YYYY HH24:MI:SS'; select username, action,action_name,timestamp,logoff_time from dba_audit_trail where action_name = 'LOGON' and username = '&user'; Here are some more helpful links: http://itechshare.blogspot.com/2010/06/oracle-how-to-track-logon-logout-in.html http://itechshare.blogspot.com/2010/06/oracle-why-dbaaudittrail-shows-more.html
Read more

RMAN Restore vs. Recovery - what's the difference?

RESTORE is used to restore the datafiles from a backup. You can restore up to the time of the backup or a point before using SET UNTIL . You would lose any changes made to the database after the backup by performing only a RESTORE. RECOVER is used to roll the database forward after a RESTORE by applying the redo logs. In essence, RECOVER = RESTORE + redo logs. The following example assumes you have lost your control files and datafiles, but still have your redo logs. $ rman target / nocatalog RMAN> startup nomount; RMAN> restore controlfile from '/oback/controlfile'; RMAN> alter database mount; RMAN> restore database; RMAN> recover database; RMAN> alter database open resetlogs;
Read more