软件
軟件
연건
SOFT WARE
2013年
11期
131-132
,共2页
数据库%信息技术%SQL语句
數據庫%信息技術%SQL語句
수거고%신식기술%SQL어구
Database%information technology%SQL statement
当前,随着信息技术成熟与发展,ORACLE数据库系统结构日益复杂,虽从一定程度完善、提高其使用性能,并扩展了其使用范围,但仍然存在诸多不稳定因素。本文结合ORACLE系统结构,从OFA自由结构、回滚段、运行机制、硬件以及OS等周边环境多方面对数据优化进行阐述,并制定出相应优化策略。
噹前,隨著信息技術成熟與髮展,ORACLE數據庫繫統結構日益複雜,雖從一定程度完善、提高其使用性能,併擴展瞭其使用範圍,但仍然存在諸多不穩定因素。本文結閤ORACLE繫統結構,從OFA自由結構、迴滾段、運行機製、硬件以及OS等週邊環境多方麵對數據優化進行闡述,併製定齣相應優化策略。
당전,수착신식기술성숙여발전,ORACLE수거고계통결구일익복잡,수종일정정도완선、제고기사용성능,병확전료기사용범위,단잉연존재제다불은정인소。본문결합ORACLE계통결구,종OFA자유결구、회곤단、운행궤제、경건이급OS등주변배경다방면대수거우화진행천술,병제정출상응우화책략。
At present, along with the information technology development, ORACLE database system structure is becoming more and more complex, thoughimproving, from a certain degree to improve service performance, and expand its scope of application, but there are still many unstable factors. In this paper, combined with the ORACLE system structure, from the aspects ofOFA free structure, rollback segment, operational mechanism, hardware and OS environment to carry on the elaboration to data optimization, and formulate the corresponding optimization strategy.