Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

2135

积分

502

好友

184

主题
1#
发表于 2012-5-7 23:21:28 | 查看: 2926| 回复: 0
FEW CLOSE ENCOUNTERS WITH REAL WORLD PERFORMANCE ISSUES

Introduction
This paper is to explore few interesting performance issues I have personally encountered and
resolved. This paper is primarily designed to show even these uncommon performance issues can be
resolved using common scientific techniques. This presentation introduces various approaches to the
performance analysis useful in resolving these performance issues.
1. High Kernel Mode CPU usage
Background:
There are many application instances each servicing a disjoint group of users. As per the design, any
application instance can be shutdown with no user impact and traffic will be automatically rerouted
to surviving instances (almost similar to RAC, implemented at application level).
Application design is such that one instance of the application is serving a disjoint set of users and
every application instance has a front-end application database. Users connect to these application
instances and most of the working set of data is contained within that application database.
Application instance, application database and the storage is considered one module. This module
can be instantiated to any UNIX server quickly, in case of, hardware failures.
It is a brilliant design eliminating site-wide failure. Also, it is very easy to move the users also from
one application instance, say #1, to another application instance, say #2, if needed. This satisfies near
100% uptime requirements of the application.
There is also central repository database, mostly used for authentication and static data. Figure 1
illustrates this application design.



Riyaj_Few_Close_encounters_with_real_world_perf_issues_doc.pdf (456.82 KB, 下载次数: 0, 售价: 10 金钱)
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/zh-hans/emergency-services

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638  QQ: 47079569   
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-5-19 06:19 , Processed in 0.049870 second(s), 25 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569