Tags » Spid

AGGREGATE XML AUDIT FILES BY SPID

$ cd ${AUDIT_DIR}
$ ls | awk -F"_" '{print $3}' | uniq -c | head

OR

$ cd ${AUDIT_DIR}
$ ls | awk -F"_" '{print $3}' | \
  awk '{array1[$1]++;}END {for (i in array1) {print array1[i], i;}}' | \
  sort -nk1 | tail
ORACLE

Find the Oracle session that's using a lot of resources on a Linux system

To find that, I did the following:

$ ps aux | sort -nrk 3,3 | head -n 10
oracle 28986 75.8 1.6 10739264 1602896 ? Rs Jan24 137897:06 ora_q002_DBINST
oracle 23660 63.1 1.2 10730424 1221500 ? 189 more words
SQL

10 Most Important handy system stored Procedures for DBA

10 Most Important handy system stored Procedures for DBA

This blog contains the most important system stored procedures which are supported by SQL Server and are used on a daily basis by DBA. 208 more words

Database Administration

SPID11 - Prince of Transylvania

I will be posting SPIDs (Slashie’s Project Idea Drafts) in the blog, they will be short ideas for games or other projects I may or may not develop into full projects.

136 more words
SPID

SPID10 - Zelda II Top down

I will be posting SPIDs (Slashie’s Project Idea Drafts) in the blog, they will be short ideas for games or other projects I may or may not develop into full projects.

127 more words
SPID