The Unix top command is designed to help users determine which processes are running and which applications are using more memory or processing power than they should be. The top command is very easy to use but you shoul[...]
10g RAC for Administrators hxxp://rapidshare.com/files/61294558/10gRACforAdministratorsR2_Vol1_pwd_-_racr2.pdf hxxp://rapidshare.com/files/61295444/10gRACforAdministratorsR2_Vol2_pwd_-_racr2.pdf Password: racr2 [...]
This is the second in a series of courses, aimed at preparing the user for Oracle Certification Exam # 1Z0-031. This course will teach Oracle database administration fundamentals; installing Oracle, creating databases, m[...]
1Z0-001 Introduction to Oracle: SQL and PL/SQL 130 Questions 2/24/2009 1Z0-007 Introduction to Oracle9i: SQL 203 Questions 2/10/2009 1Z0-020 Oracle8i: New Features for Administrators 83 Questions 10/31/2008 1Z0-023 Archi[...]
1Z0-042 Oracle Database 10g: Administration I 1Z0-043 Oracle Database 10g: Administration II 1Z0-052 Oracle Database 11g: Administration I 1Z0-255 Hyperion Essbase 7.1.2 Cnsultant 1Z0-108 Oracle WebLogic Server 10g Syste[...]
It covers only 10g and 11g technologies and they are mainly powerpoint slides and e-books on PL/SQL, development and database administration : D17171GC20 – 10g Develop Applications Using HTML Db 2nd Edition http://[...]
When an Oracle Instance is started, the characteristics of the Instance are established by parameters specified within the initialization parameter file. These initialization parameters are either stored in a PFILE or S[...]
Finds all files over 20,000KB (roughly 20MB) in size and presents their names and size in a human readable format: find / -type f -size +20000k -exec ls -lh {} \; 2>/dev/null|awk '{print $NF ": " $5}'|sort -nrk 2,2 f[...]
Sessions can be killed from within oracle using the ALTER SYSTEM KILL SESSION syntax. First identify the offending session as follows: SELECT s.sid, s.serial#, s.osuser, s.program FROM v$session s[...]
You can check for top memory consuming processes by issuing the following commands: we use the following ps commands in order to check for performance probelms 1) Displaying top CPU_consuming processes: ps aux | head -1[...]
This page is an introduction to my blog, which is dedicated to Oracle data base performance management.
I found over the years sharing knowledge to be an invaluable tool in assisting me in my various consulting assignments. Spending most of my time in capacity planning, tuning, application sizing and performance management, I thought it might be [...]
dba Ask TEM Dba
(0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5)