358 reputation
17
bio website ofork.blogspot.com
location Perth, Australia
age 36
visits member for 3 years, 3 months
seen Nov 18 '11 at 8:03

Oracle DBA


Apr
21
awarded  Nice Question
Apr
8
awarded  Yearling
Feb
9
asked forensically deleting/updating data
Aug
24
awarded  Scholar
Aug
24
comment oracle failsafe - how to start instance in nomount
Cheers, step two was the all important bit I was missing.
Aug
24
accepted oracle failsafe - how to start instance in nomount
Aug
24
awarded  Student
Aug
24
asked oracle failsafe - how to start instance in nomount
Aug
15
comment How do you increase MySQL performance using current server resources?
I'm not a mysql expert, but 3 seconds to examine 500 rows seems very excessive, whats the IO like on your system?
Aug
8
awarded  Critic
Aug
7
comment What all are the recoverable points of failure in an Oracle database?
Unless you are running 11g rac, then killing pmon or smon will take down your instance. 11g rac apparently has a new service to restart these if they die, however I have not used it personally.
Aug
7
answered What all are the recoverable points of failure in an Oracle database?
Aug
3
comment Wise to use trigger to update another table?
In this case it may be the only viable option, that doesn't make it wise. The wise thing to do would be to push back on the application developer and get them to correctly insert into both tables.
Aug
2
answered Why in Oracle 11gR2 I can't drop the materialized view with the same user that created it?
Aug
2
comment Why in Oracle 11gR2 I can't drop the materialized view with the same user that created it?
Do you have a support contract? there is some 10g bugs which cause what you are seeing, perhaps they are stil around. I tried to replicate against 11gR2 but was unable to. Perhaps provide a complete script from initial table and MV which others can try to replicate.
Aug
1
awarded  Teacher
Aug
1
answered Wise to use trigger to update another table?
May
8
comment What features of Oracle make it an attractive choice for small projects?
@stan the dba From what I've read of the clustering options for SQL Server, they are not really comparable to RAC at all, most of them being fail over solutions, not true scale out solutions like rac.
May
8
awarded  Supporter
Apr
8
awarded  Autobiographer