1,186 reputation
28
bio website
location
age
visits member for 2 years, 8 months
seen 12 hours ago

Sep
24
comment Installing Oracle 11gR2 on Oracle Linux 6 - error possibly related to database (unique) name
What is the result of ping "$ORACLE_HOSTNAME" command?
Sep
11
comment “ORA-03113: end-of-file on communication channel” on startup
Search (grep) all the alert logs between the last successful startup and the current unsuccessful startup and search for ALTER SYSTEM SET in all this time span. Maybe someone changed some instance parameter in a non-standard way.
Sep
7
comment Where can I find some guidance on index strategies?
Just a note to readers: MS SQL "bookmark lookup" is equivalent to Oracle's "ACCESS BY ROWID". See stackoverflow.com/a/820731/122727
Aug
31
comment How to -create- performance issues? - oracle
Please re-phrase in a way that would make it possible to have one self-contained answer for this question. I think you should begin with "Are there any reliable statistics about the most common causes of performance problems among Oracle database users?"
Aug
29
comment Oracle merge query vs correlated update
Usually CTAS is the way to go with such scenario.
Aug
26
comment How to disable flashback query logging for a specific table (Oracle)?
@a_horse_with_no_name We are not on the same page. I completely agree that temp generates undo. But why would temp-related undo be turned into flashback logs? It would be a waste of FRA space.
Aug
25
comment How to disable flashback query logging for a specific table (Oracle)?
@a_horse_with_no_name Are you sure-sure? Officially, "RMAN never flashes back data for temporary tablespaces", so I assumed it does not turn this undo into flashback files.
Aug
22
comment Which version of Oracle supports Streams
PE is not free so contact your favorite Oracle salesperson :-)
Aug
20
comment most effective architecture to apply mulitple functions
19 days and not a single upvote for such a well researched question of a general nature. Proud to give the first one then.
Jul
27
comment How to disable flashback query logging for a specific table (Oracle)?
Make it a temporary table, perhaps?
Jul
24
comment DBMS_SCHEDULER event schedule jobs not executed when triggered almost at the same time
Hmm "not reliable". Isn't it possible to have a plain and simple stored procedure (not a job) that is notified on each enqueue? I never tested this, so I cannot vouch, but I would say it is a traditional way and would be reliable (that is, it wouldn't silently dequeue events).
Jun
11
comment BLOBs storage in a dedicated table
I suggest to change the title - "STORAGE IN ROW" is a specific clause in Oracle, which impacts internal structures, not related to OP's user-visible table. dba.stackexchange.com/questions/8770/…
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...