16M意思就是db_16k_cache_size的大小是16M。存在于内存当中，是SGA的一部分。可以有其他设置，但是不能超过sga_max_size-当前的SGA大小。db_2k_cache_size 同理。这里面涉及到了Oracle的体系结构一些底层的东西。 建议你看看Oracle concepts。 里面都有相关的说明。
SQL> SQL> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL> startup;ORACLE instance started.Total System Global Area 5.1310E+10 bytes Fixed Size 2240344 bytes Variable Size 3.1407E+10 bytes Database Buffers 1.9864E+10 bytes Redo Buffers 36098048 bytes Data...
Using parameter settings in server-side spfile /opt/oracle/app/oracle/product/11gR2/db/dbs/spfilepm4h.ora System parameters with non-default values: processes = 3000 sessions = 4544 resource_limit = TRUE sga_max_size = 48G shared_pool_size = 2G sga_target = 0 memory_target = 48G memory_...
清除SGA共享池中的全部数据 终止一个会话 其语法如下: Alter system Set paraname=value |{enable|disable} restricted session |flush shared_pool |switch logfile |archive log archive_log_clause |kill session ‘integer1,integer2’ 例:清除SGA共享池 Alter system flush shared_pool; 例:设置共享服务器进程...
Dynamic: ALTER SYSTEM Range of values n = 2, 4, 8, 16, 32 DB_nK_CACHE_SIZE specifies the size of the cache for the nK buffers. You can set this parameter only when DB_BLOCK_SIZE has a value other than nK. For example, if DB_BLOCK_SIZE=4096, it is illegal to specify the...
ALTER SYSTEM SET UNDO_TABLESPACE =new_tablespace_nameSCOPE = MEMORY; You only need to issue this statement once. If theUNDO_TABLESPACEparameter is set to the new tablespace name in the pfile or spfile, then the parameter will be set correctly when the instance is next restarted. ...
ALTER SYSTEM SET undo_tablespace=UNDOTBS02; 三、建立临时表空间 CREATE TEMPORARY TABLESPACE temp_data TEMPFILE '/oracle/oradata/db/TEMP_DATA.dbf' SIZE 50M 四、改变表空间状态 1.使表空间脱机 ALTER TABLESPACE game OFFLINE; 如果是意外删除了数据文件,则必须带有RECOVER选项 ...
altersystem|sessionsetevents ‘[eventnumber|immediate]trace name eventname[forever][, level levelnumber]: …….’ 通过:符号,可以连续设置多个事件,也可以通过连续使用alter session set events来设置多个事件。 格式说明: eventnumber指触发dump的事件号,事件号可以是Oracle错误号(出现相应错误时跟踪指定的事件)...
ALTER SYSTEM SET parallel_max_servers=96 SCOPE=both * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-00060: deadlock detected while waiting for resource SQL> From the trace file of ORA-60, self deadlock happened when update pdb_spfile$ recusively. ...
SQL> EXECUTE DBMS_LOGSTDBY.APPLY_SET('MAX_SGA', 1024); PL/SQL procedure successfully completed 1. 2. Because theMAX_SGAis specified in megabytes (MB), increasing the memory to 1 GB is specified as 1024 (MB) in the example. Start SQL Apply: ...