My Oracle Profile
OCP finally.
Information on Oracle
What I remember from the Oracle trainning...Oracle Database is made up of Schema(s), which contains Tablespace(s), which contains Table(s), which are stored on Datafile(s). Datafile(s) are made up of database Block(s), which can be multiples of filesystem blocks. Don't remember where Partition(s) fits in.
Installation
Control, Init files
Redo logs
Log / trace files
Database
Instance
Tablespace
Datafile
Table
SQLTuning
User management
Usage checking
Oracle statistics
Import & Export
Backup & Restore
Flashback
Rman, cloning
Standby database on standard edition
Applying CPU patch
Express Edition
OracleSQL
OracleSQLPlus
OracleRAC
OracleAWR
10g specific
Oracle 10g Enterprise ManagerOracle ASM
Database Suspend
Exam stuff
My Exam NotesSQLplus with history!
Install rlwrap http://freshmeat.net/projects/rlwrapalias sqlplus='/usr/bin/rlwrap -m ${ORACLE_HOME}/bin/sqlplus'There you go, you can now use the arrow key to access the historic commands, like in bash.
Show running SID in sqlplus
select instance from v$thread;
crs_stat deprecated
Use these.[grid@rac01 ~]$ $GRID_HOME/bin/crsctl stat res -t [grid@rac01 ~]$ srvctl status database -d pocdb
