1,004 reputation
54
bio website uhesse.wordpress.com
location Germany
age
visits member for 3 years, 1 month
seen Nov 4 '11 at 14:22

Senior Principal Instructor (Oracle University) Oracle Certified Master


Sep
24
awarded  Autobiographer
Sep
16
awarded  Yearling
Sep
16
awarded  Yearling
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?