y****w 发帖数: 3747 | 1 大家说说看?
我刚说是最怕开发那边又搞出个大数据的data fix,几百G,又要改表结构啥的,技术上
不难但nnd的占太多off hours. | s**********o 发帖数: 14359 | 2 领导逞能弄了大规模的DENORMALIZED NIGHT JOBS,因为移动数据量大,频频出错或者
LOAD不上,晚上不得肃静,还好我及时逃走了。LOL | h********i 发帖数: 32 | 3 这些data fix,DENORMALIZED 不是ETL,data govermance作的么?
怎么要dba作了? | y****w 发帖数: 3747 | 4 small temple.
【在 h********i 的大作中提到】 : 这些data fix,DENORMALIZED 不是ETL,data govermance作的么? : 怎么要dba作了?
| s**********o 发帖数: 14359 | 5 小公司DBA啥都要干的,不过也好,学习了锻炼了。NORMALIZED一般是用来存储数据的
,用的时候要JOIN 3,4个TABLES,非常慢,DENORMALIZED了WEB快多了,数据库发展的
那么快,多数BUSINESS RULE都可以在数据库SIDE实现,而且PERFORMANCE也可以控制。 | y****9 发帖数: 144 | 6 Establish a good relationship with a developer, who is knowlegeable about
Oracle database and application domain and design logic, he or she is
willing to share knowlege and being honest with DBA.
The most stressful time being a production DBA is troubleshooting production
performance problem in a limited time with many eyes watching on you. Many
time it turns out to be application problem, having a cooperative dev team
is essential to get the job done.
Working over time/ in off hours/ with extra hours - that is DBA life, not
really a difficult thing.
fyi, I am doing nothing else but being a production DBA in my current job.
【在 y****w 的大作中提到】 : 大家说说看? : 我刚说是最怕开发那边又搞出个大数据的data fix,几百G,又要改表结构啥的,技术上 : 不难但nnd的占太多off hours.
|
|