Reputation
4,704
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
9 23
Newest
 Yearling
Impact
~430k people reached

May
11
answered Oracle database not open and ORA-00600 error
Apr
14
revised How can I unload Oracle database tables into a csv files?
added sqlcl as easiest option
Feb
25
answered What to do when archive logs are lost/corrupted that are not backed up
Feb
18
awarded  Yearling
Feb
11
revised sqlldr running slow after indexes created
detailed about partitioning and exchange loading
Feb
11
answered sqlldr running slow after indexes created
Jan
30
awarded  Enlightened
Jan
30
awarded  Nice Answer
Jan
27
comment What are the Oracle Dataguard Implications of Migrating to a PDB?
yes, linking notes .... fixed it. The procedure should be tested any way but the ASM/FS should be transparent in this situation.
Jan
27
revised What are the Oracle Dataguard Implications of Migrating to a PDB?
fixed link to note
Jan
26
comment Oracle 11g connect overhead
I have seen this happen on a windows system. Maybe this is better on Unix. On Windows the app came close to a standstill when the listener.log reached 2GB. Connection times went up to minutes.
Jan
26
revised Oracle 11g connect overhead
added a little about the locking and added RWPT video link about connection pooling
Jan
26
answered Oracle 11g connect overhead
Jan
26
answered What are the Oracle Dataguard Implications of Migrating to a PDB?
Jan
23
comment What are the Oracle Dataguard Implications of Migrating to a PDB?
You mean you have a 12c non PDB database and want to plug that into a container database? Or: you are asking about upgrading an 11g configuration to 12c with plugin? With 12c the container has the DG config so a database that plugs in is protected by that right away.
Jan
21
comment Not receiving archivelogs from production to remote side
ok, but can you also reach the remote listener port? 'telnet remotehost listenerport' Is the remote listener running? How is the alias remotedr defined?
Jan
21
comment Not receiving archivelogs from production to remote side
can you telnet from the primary site to the remote listener port? I don't think so:ORA-12170: TNS:Connect timeout occurred PING[ARC3]: Heartbeat failed to connect to standby 'remotedr'. Error is 12170. My guess: a firewall is blocking you.
Jan
20
comment Not receiving archivelogs from production to remote side
Well, without alertlog errors I need a magic bowl. Get the alertlog, read and weap. Verly likely it has a pointer to the problem.
Jan
20
comment Not receiving archivelogs from production to remote side
What is written in the primary alertlog for the remote archive destinations? How do you ship (logwriter or arch) sync/async, what configuration (max performance/ max protection)? async with arch, 1500KM is no problem with even worse connections.
Jan
6
comment Oracle nologging impact for REDO Generation
yes, good comment, thanks but append has a way of working which makes this only usable in a for all pl/sql construction. Don't do this with single row inserts; it is intended for bulk operations.