1,045 reputation
28
bio website
location
age
visits member for 2 years, 4 months
seen Apr 3 at 8:02

Apr
29
comment Why we need auxiliary instance in TSPITR
Hypothetically, yes, I guess so. But Oracle doesn't give you possibility to have different undo tablespace for each data tablespace.
Apr
25
comment Why we need auxiliary instance in TSPITR
We're not on the same page. You asked "why?" and I answered "because X". Import (imp, impdp) has nothing to do with undo, and I didn't imply you need to tinker with it. Import has simply nothing to do with your question.
Apr
24
comment Why we need auxiliary instance in TSPITR
By "synchronized" I simply mean "to be from the same point in time" not to have any calculation/action/movement performed.
Dec
4
comment Transaction stays in capture queue
Could you please post answer (as opposed to a comment) and accept it? Self-answers are welcome around here.
Nov
29
comment Installing Oracle 11g XE on Ubuntu 12.04
@HomunculusReticulli kudos goes to you for gathering all the information; given the size of Internet, someone will figure it out sooner or later, if all the necessary input is at hand
Nov
24
comment Upgrading from 10.2g to 11g by incrementals
Good point, but OP should surely thoroughly check the list of unsupported types for logical standby. Otherwise OP would get into great trouble in this scenario.
Nov
22
comment Is it possible to see the (completed) SQL Statements executed by a specific session?
If you want all statements, that's even better. You don't need fine grained auditing then, just the old fashioned (basic) auditing. This is very easy. And this is exactly the tool for the job.
Nov
21
comment How to see list of databases in Oracle?
Uh great, more complication, more job security...
Nov
21
comment How to see list of databases in Oracle?
ALL_USERS? USER_TABLESPACES?
Nov
21
comment Standby controlfile error
What is the path to system01.dbf on your primary, and is it the same as on the standby?
Nov
20
comment Oracle.exe (SHAD) process keeps increasing
...illegally published.
Nov
9
comment Java application unable to access Blob stream in Oracle after upgrade to 11g
Please dig through database-server-side errors. Check alert*.log and the recent *.trc files.
Nov
9
comment Could Oracle ORA-08103 'object no longer exists' error be caused by size of undo_retention parameter?
When at point "4", are you using, either explicitly or implicitly, a cursor that depends on point "1"? The "1" remote query might have allocated a little bit of dummy undo on your db (surprise!), and after "3" commit this undo would likely get overwritten as a result of small UNDO_RETENTION. Just an idea of a possible connection of dblink with UNDO_RETENTION. (Temporary tables are unrelated to this behavior; whether you use them or not, no impact here.)
Nov
5
comment Oracle 11gR2 archive log destinations
Yes with a big BUT... if you don't archive several redo logs, you would arrive at "stuck archiver" situation (no commit possible).
Oct
29
comment How to see list of databases in Oracle?
Note also there is a terminology mismatch between MySQL and Oracle Database. In terms of architecture, Oracle has table->schema->database, and at the same time also table->tablespace->database. MySQL has simply table->database. So maybe you are really searching for Oracle schema list (think: SQL namespaces for tables) or Oracle tablespace list (think: groups of OS files for tables).
Sep
29
comment When dedicated server process model should be used instead of shared process model?
I administer a few fairly large OLTP systems. The owners/customers happily bought enough RAM&CPU so they could use dedicated servers and not be overloaded - but they didn't ask me for advice. If I would sponsor a system with my own money, I'd probably test shared server.
Sep
12
comment How to I interleave logs from two different Oracle tables?
Please do use UNION ALL, otherwise you would risk losing some rows! (as OP rightly suggested)
Jun
22
comment What are the risks of the parameter PRESERVE_COMMIT_ORDER of Oracle's DBMS_LOGSTDBY?
Ups. I didn't know that :)
May
25
comment Can RMAN duplicate be used to “replace” an existing database?
What exactly do you mean by "the manual steps RMAN requires to set up the auxiliary database"?
Apr
10
comment What units used in DBA_TABLESPACE_USAGE_METRICS?
Indeed. Any thoughts regarding undo metrics?