Difference between revisions of "Oracle"
From Robin-Wiki
| Line 15: | Line 15: | ||
* [[DB link]] | * [[DB link]] | ||
* [[lob]] | * [[lob]] | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
== Admin == | == Admin == | ||
| Line 44: | Line 34: | ||
* [[Upgrade to Oracle database 11.2.0.3]] | * [[Upgrade to Oracle database 11.2.0.3]] | ||
| + | |||
| + | |||
| + | <!---- Middle side ----> | ||
| + | | style="border:1px solid #cedff2;" bgcolor=#FFFFFF width=33% | | ||
| + | |||
| + | == SQL == | ||
| + | |||
| + | * [[Find SID and SERIAL#]] | ||
| + | * [[Find blocking locks]] | ||
| + | * [[Search column names]] | ||
| + | |||
| + | == PL/SQL == | ||
| + | |||
| + | * [[Search data in columns]] | ||
| + | |||
| + | |||
| + | <!---- Right hand side ----> | ||
| + | | style="border:1px solid #cedff2;" bgcolor=#FFFFFF width=33% | | ||
| + | |||
== OWB 11.2.0.3 == | == OWB 11.2.0.3 == | ||
| Line 58: | Line 67: | ||
* [http://www.jlcomp.demon.co.uk Jonathan Lewis Homepage] | * [http://www.jlcomp.demon.co.uk Jonathan Lewis Homepage] | ||
* [http://jonathanlewis.wordpress.com Jonathan Lewis Scratchpad] | * [http://jonathanlewis.wordpress.com Jonathan Lewis Scratchpad] | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 11:07, 20 April 2012
|
All examples on this page is basically tested on Oracle version 11g BasicsAdminRMANPatch
|
SQLPL/SQL
|
OWB 11.2.0.3Recommended external links |
