Location:
Search - oracle SGA
Search list
Description: Oracle 在启动的时候指定SGA使用多少虚拟内存,并且在运行时允许实例通过调整buffer cache, shared pool, large pool和PGA的大小动态的调整SGA。-Oracle boot time designated SGA amount of virtual memory, and at runtime allowing example by adjusting the buffer cache, shared pool, large pool and the size of the PGA dynamic adjustment of SGA.
Platform: |
Size: 8401 |
Author: 叶子 |
Hits:
Description: Oracle 在启动的时候指定SGA使用多少虚拟内存,并且在运行时允许实例通过调整buffer cache, shared pool, large pool和PGA的大小动态的调整SGA。-Oracle boot time designated SGA amount of virtual memory, and at runtime allowing example by adjusting the buffer cache, shared pool, large pool and the size of the PGA dynamic adjustment of SGA.
Platform: |
Size: 8192 |
Author: 叶子 |
Hits:
Description: 关于Oracle的性能调整,一般包括两个方面,一是指Oracle数据库本身的调整,比如SGA、PGA的优化设置,二是连接Oracle的应用程序以及SQL语句的优化。做好这两个方面的优化,就可以使一套完整的Oracle应用系统处于良好的运行状态。
本 文主要是把一些Oracle Tuning的文章作了一个简单的总结,力求以实际可操作为目的,配合讲解部分理论知识,使大部分具有一般Oracle知识的使用者能够对Oracle Tuning有所了解,并且能够根据实际情况对某些参数进行调整。关于更加详细的知识,请参见本文结束部分所提及的推荐书籍,同时由于该话题内容太多且复 杂,本文必定有失之偏颇甚至错误的地方,请不吝赐教,并共同进步。 -no
Platform: |
Size: 18432 |
Author: leizhang |
Hits:
Description: Oracle数据库性能调优,包括了对SHARED POOL、SGA的调优,也包括了SQL语句调优,是一本好书。-Oracle database performance tuning, including the SHARED POOL, SGA tuning in, but also tuning the SQL statement is a good book.
Platform: |
Size: 10584064 |
Author: 管小黑 |
Hits:
Description: hared Pool是Oracle SGA设置中最复杂也是最重要的一部分内容,Oracle通过Shared Pool来实现SQL共享、减少代码硬解析等,从而提高数据库的性能。在某些版本中,如果设置不当,Shared Pool可能会极大地影响数据库的正常运行-hared Pool Oracle SGA setting is the most complex and most important part, Oracle SQL through the Shared Pool to achieve shared, reducing the code hard to resolve, so as to improve database performance. In some versions, if set properly, Shared Pool may greatly affect the normal operation of the database
Platform: |
Size: 216064 |
Author: sky13and23 |
Hits:
Description: Oracle Database 10g - Automatic SGA Memory Management
Platform: |
Size: 282624 |
Author: haicp |
Hits:
Description: oracle内存结构:主要介绍SGA、PGA与UGA的功能与作用,及其它们的联系-oracle memory structure: describes the function and role of the SGA, PGA and UGA, and their contact
Platform: |
Size: 11264 |
Author: guomeihua |
Hits:
Description: 监控oracle数据库性能,监控SGA、sql,命中率等信息-Monitor oracle performance and resource utilization
Platform: |
Size: 26624 |
Author: ccidcstc |
Hits: