| bio | website | uhesse.wordpress.com |
|---|---|---|
| location | Germany | |
| age | ||
| visits | member for | 1 year, 9 months |
| seen | Nov 4 '11 at 14:22 | |
| stats | profile views | 77 |
Senior Principal Instructor (Oracle University) Oracle Certified Master
|
Sep 16 |
awarded | Yearling |
|
Feb 25 |
awarded | Necromancer |
|
Nov 4 |
revised |
In a two-server dataguard setup, can I store the recovery catalog in the same database? added some stuff |
|
Nov 4 |
answered | In a two-server dataguard setup, can I store the recovery catalog in the same database? |
|
Nov 3 |
comment |
Oracle RAC failover not working correctly The page you linked to has a questionable reputation, to say it mild :-) I refer here to the official documentation - it states clearly that TAF is additionally to be configured: quote "If you configure transparent application failover (TAF) for the connection, then Oracle Database moves the session to a surviving instance when an outage occurs." And gives an example how to do that with srvctl: download.oracle.com/docs/cd/E11882_01/rac.112/e16795/… |
|
Nov 2 |
comment |
Oracle RAC failover not working correctly Well it aint so unless there was some additional configuration done. Like using an application service that got TAF attributes - this would be the modern way to do that instead of specifying the TAF parameters inside of the tnsnames.ora. srvctl -h | grep service should lead you to it :-) |
|
Nov 2 |
answered | Oracle RAC failover not working correctly |
|
Oct 31 |
answered | Oracle 10g - How to prevent one user from hogging all resources? |
|
Oct 28 |
comment |
Eliminate database fragmentation (export, drop and re-import tables) The enable row movement is apart from shrinking only relevant for partitioned tables - you may keep it enabled without concern for ordinary tables. Indexes can be also shrunk if you add "cascade" to the alter table command. Lob segments need to be shrunk explicitly, though. |
|
Oct 27 |
answered | In Oracle, if parallel_max_servers is set to be significantly less than the DOP can the explain plan be sub-optimal? |
|
Oct 27 |
answered | Eliminate database fragmentation (export, drop and re-import tables) |
|
Oct 11 |
comment |
How do I create a database+tablespace+user in Oracle 11gR2? Yes, there is no DBCA with XE. |
|
Oct 10 |
answered | Simplified/automated datafile free disk space reclaim |
|
Oct 5 |
answered | How does Oracle handle composite index lookups? |
|
Oct 4 |
answered | Does an Oracle nvarchar2 take twice as much space as varchar2? |
|
Sep 29 |
answered | How to compare the database of a backup from another environment |
|
Sep 29 |
answered | What features of Oracle make it an attractive choice for small projects? |
|
Sep 29 |
answered | Oracle Backup/Recovery architecture |
|
Sep 27 |
awarded | Necromancer |
|
Sep 25 |
awarded | Quorum |