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!
Pages: