{{parent page="Database"}}

===My Oracle Profile===
OCP finally.
{{image url="images/OCP_ODb10gAdmin_clr.gif"}}

=== 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.

[[OracleInstall Installation]]
[[OracleConfigfiles Control, Init files]]
[[OracleRedo Redo logs]]
[[OracleLogFile Log / trace files]]
[[OracleDatabase Database]]
[[OracleInstance Instance]]
[[OracleTablespaces Tablespace]]
[[OracleDatafile Datafile]]
[[OracleTable Table]]
[[OracleSQLTuning SQLTuning]]
[[OracleUsers User management]]
[[OracleUsage Usage checking]]
[[OracleStatistics Oracle statistics]]
[[OracleImportExport Import & Export]]
[[OracleBackup Backup & Restore]]
[[OracleFlashback Flashback]]
[[OracleRman Rman, cloning]]
[[OracleStandby Standby database on standard edition]]
[[OracleCPUPatch Applying CPU patch]]
[[OracleExpress Express Edition]]
[[OracleSQL OracleSQL]]
[[OracleSQLPlus OracleSQLPlus]]
[[OracleRAC OracleRAC]]
[[OracleAWR OracleAWR]]
-----

===10g specific===
[[Oracle10gEm Oracle 10g Enterprise Manager]]
[[Oracle10gASM Oracle ASM]]
[[OracleSuspend Database Suspend]]

===Exam stuff===
[[OracleMyExamNotes My Exam Notes]]

=== SQLplus with history!===
Install rlwrap http://freshmeat.net/projects/rlwrap

%%
alias 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
%%