Difference: OracleBasics (7 vs. 8)

Revision 824 Jun 2003 - TobyCabot

Line: 1 to 1

META TOPICPARENT	name="DatabaseTips"

The Oracle graphical console is called oemapp. You'll most likely want to run oemapp dbastudio, make sure that X is working first.

Line: 24 to 24

In sqlplus, set timing on gives elapsed time for sql commands.

Added:

>
>

Rollback Segments

Rollback segments don't come online automatically unless you hack Oracle's startup config files: http://www.jlcomp.demon.co.uk/faq/rbk_online.html:

rollback_segments = (r01, r02, r03, r04)

In-doubt xactions

If you end up with "in-doubt transactions" then you could be in a world of hurt since I've seen cases where they locked tables and hung around for days. You can't always force commits or rollbacks in OEM, so here's a recipe for getting rid of them when they happen (props to Kurt Stam):

View topic | History: r8 < r7 < r6 < r5 | More topic actions...