Oracle Adventures

  • Home
  • About
  • Privacy Policy
  • About
  • Privacy Policy

Tag Archives: find process

Home / Posts Tagged: find process

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

To find that, I did the following: [oracle@dbserver marius]$ 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 ? Rs Feb12 97718:28 ora_q003_DBINST oracle 8360 15.7 6.0 10734592 5970484 ? Ss May28 377:34 oracleDBINST (LOCAL=NO) oracle 2264…

Read More

30/05/2017mardaffSQL, Tuningfind process, gv$process, session, spid
ora-base.com
Cleantalk Pixel