Posted by james.vulling on December 21, 2008
To view the current database from the SQLPLUS command line:
SELECT name FROM V$DATABASE;
To view the current process list:
SELECT * FROM V$PROCESS;
For more information on what processes are currently doing, I found this post pretty useful.
I recently had to increase the number of allowed connections to a database, which meant a restart. I did this using:
# sqlplus /nolog
CONNECT / AS sysdba;
SHUTDOWN IMMEDIATE;
STARTUP;
These are pretty basic operations but thought they may be of use to someone out there!
Posted by james.vulling on December 19, 2008
Peter Drucker’s books and essays on management topics have a widespread reputation. I first heard about Drucker listening to the guys on Manager Tools and decided to purchase his book The Effective Executive
to see what he had to say.
Drucker discusses what he perceives to be the definition of an executive and the role that they play within an organisation. Druckers key take-away points are that:
- Effectiveness must be learned
- Record and analyse where your time goes
- Focus your vision on contribution
- Make the strengths of yourself and others productive
- Items with the most impact should be undertaken first