oracle12cocp-1-创新互联
To implement Automatic Memory Management (AMM), you set the following parameters:
创新互联建站主营柳北网站建设的网络公司,主营网站建设方案,成都app软件开发公司,柳北h5小程序开发搭建,柳北网站营销推广欢迎柳北等地区企业咨询When you try to start the database instance with these parameter settings, you receive the following error message:
SQL > startup
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information.
Identify the reason the instance failed to start.
A. The PGA_AGGREGATE_TARGET parameter is set to zero.
B. The STATISTICS_LEVEL parameter is set to BASIC.
C. Both the SGA_TARGET and MEMORY_TARGET parameters are set.
D. The SGA_MAX_SIZE and SGA_TARGET parameter values are not equal.
STATISTICS_LEVEL
Property | Description |
---|---|
Parameter type | String |
Syntax | STATISTICS_LEVEL = { ALL | TYPICAL | BASIC } |
Default value | TYPICAL |
Modifiable | ALTER SESSION , ALTER SYSTEM |
STATISTICS_LEVEL
specifies the level of collection for database and operating system statistics. The Oracle Database collects these statistics for a variety of purposes, including making self-management decisions.
Setting the STATISTICS_LEVEL
parameter to BASIC
disables the collection of many of the important statistics required by Oracle Database features and functionality, including:
Automatic Workload Repository (AWR) Snapshots
Automatic Database Diagnostic Monitor (ADDM)
All server-generated alerts
Automatic SGA Memory Management
Automatic optimizer statistics collection
Object level statistics
End to End Application Tracing (
V$CLIENT_STATS
)Database time distribution statistics (
V$SESS_TIME_MODEL
andV$SYS_TIME_MODEL
)Service level statistics
Buffer cache advisory
MTTR advisory
Shared pool sizing advisory
Segment level statistics
PGA Target advisory
Timed statistics
Monitoring of statistics
When the STATISTICS_LEVEL
parameter is modified by ALTER SYSTEM
, all advisories or statistics are dynamically turned on or off, depending on the new value of STATISTICS_LEVEL
. When modified by ALTER SESSION
, the following advisories or statistics are turned on or off in the local session only. Their system-wide state is not changed:
Timed statistics
Timed OS statistics
Plan execution statistics
另外有需要云服务器可以了解下创新互联scvps.cn,海内外云服务器15元起步,三天无理由+7*72小时售后在线,公司持有idc许可证,提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案,具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势,专为企业上云打造定制,能够满足用户丰富、多元化的应用场景需求。
文章标题:oracle12cocp-1-创新互联
文章起源:http://myzitong.com/article/phees.html