1,310 reputation
211
bio website
location
age
visits member for 2 years, 11 months
seen 17 hours ago

Jan
9
comment Finding why an Oracle listener got automatically restarted
Please provide the output of crs_stat -t. The command can be run as root and usually resides in CRS_HOME/bin or GI_HOME/bin.
Dec
6
comment Oracle 11g database structural change doesn't autobackup controlfile/spfile
@Ivan Both NBU and TSM work when executed from RMAN script. In fact, you cannot execute them in any other way, which kind-of sucks.
Oct
4
comment Recover oracle 10g database from old data files
If you, at some point in the past, have had copied all the relevant files while the database was shutdown, it surely wouldn't complain about resetlogs. Since it does complain, either you didn't restore all the relevant files, or the files are corrupted. My first guess is that the files were copied while modified, hence they are inconsistent, hence you have no backup to restore.
Sep
30
comment recover oracle db from datafile
What about redo files?
Sep
29
comment How can I execute a PL/SQL procedure for Oracle via JDBC?
EXEC (EXECUTE) is a SQL*Plus native command (just like SHUTDOWN, HELP, SET, etc.), and not a part of SQL itself.
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.