network profile
| bio | website | ofork.blogspot.com |
|---|---|---|
| location | Perth, Australia | |
| age | 35 | |
| visits | member for | 2 years, 1 month |
| seen | Nov 18 '11 at 8:03 | |
| stats | profile views | 5 |
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 |
