db_cache hitratio sql and v$db_cache_advice and create table with storage
select
(select value from v$sysstat where name='physical reads') phy ,
(select value from v$sysstat where name='db block gets') get,
(select value from v$sysstat where name='consistent gets') con_get,
(1-((select value from v$sysstat where name='physical reads')/
((select value from v$sysstat where name='db block gets')+(select value from v$sysstat where name='consistent gets')))) hit
from dual
select * from v$db_cache_advice
create table with storage parameter(buffer pool)
create table test(id number(4),name varchar2(50)) storage(buffer_pool keep/recycle)
_db_percent_hot_default (50) The percent of buffers in the hot region
_db_aging_touch_time (3) Seconds that must pass to increment touch count again
_db_aging_hot_criteria (2) Threshold to move a buffer to the MRU end of LRU chain
_db_aging_stay_count (0) Touch count reset to this when moved to MRU end
_db_aging_cool_count (1) Touch count reset to this when moved to LRU end
獲取隱藏引數sql:
SELECT x.ksppinm NAME, y.ksppstvl VALUE, x.ksppdesc describ
FROM SYS.x$ksppi x, SYS.x$ksppcv y
WHERE x.inst_id = USERENV ('Instance')
AND y.inst_id = USERENV ('Instance')
AND x.indx = y.indx
AND x.ksppinm LIKE '%&par%';
(select value from v$sysstat where name='physical reads') phy ,
(select value from v$sysstat where name='db block gets') get,
(select value from v$sysstat where name='consistent gets') con_get,
(1-((select value from v$sysstat where name='physical reads')/
((select value from v$sysstat where name='db block gets')+(select value from v$sysstat where name='consistent gets')))) hit
from dual
select * from v$db_cache_advice
create table with storage parameter(buffer pool)
create table test(id number(4),name varchar2(50)) storage(buffer_pool keep/recycle)
_db_percent_hot_default (50) The percent of buffers in the hot region
_db_aging_touch_time (3) Seconds that must pass to increment touch count again
_db_aging_hot_criteria (2) Threshold to move a buffer to the MRU end of LRU chain
_db_aging_stay_count (0) Touch count reset to this when moved to MRU end
_db_aging_cool_count (1) Touch count reset to this when moved to LRU end
獲取隱藏引數sql:
SELECT x.ksppinm NAME, y.ksppstvl VALUE, x.ksppdesc describ
FROM SYS.x$ksppi x, SYS.x$ksppcv y
WHERE x.inst_id = USERENV ('Instance')
AND y.inst_id = USERENV ('Instance')
AND x.indx = y.indx
AND x.ksppinm LIKE '%&par%';
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24237320/viewspace-731706/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- create table之storage選項initial和其它
- oracle中用Create Table建立表時,Storage中引數的含義!Oracle
- T-SQL的CREATE TABLE語法(下)SQL
- T-SQL的CREATE TABLE語法(上)SQL
- v$db_cache_advice學習
- How to Quickly Create a Copy of a Table using Transact-SQLUISQL
- Azure 基礎:Table storage
- MYSQL TABLE CHANGE STORAGE ENGINEMySql
- create table of mysql databaseMySqlDatabase
- create a partition table using a exsit table
- Oracle Create Table as SelectOracle
- Azure Storage 系列(五)通過Azure.Cosmos.Table 類庫在.Net 上使用 Table Storage
- create table if not exists Waiting for table metadata lockAI
- MySQL5.6 create table原理分析MySql
- sqlserver不能直接create table as select ......SQLServer
- create table進階學習(一)
- create table進階學習(三)
- create table進階學習(四)
- SQL__CREATESQL
- create table進階學習(二)_dba_free_temp_space_v$tempseg_usage_v$sort_segment
- MySQL的create table as 與 like區別MySql
- VBA從Excel中生成Oracle create tableExcelOracle
- create table進階學習系列(八)
- create table進階學習系列(五)
- create table進階學習系列(七)
- create table進階學習系列(九)
- CREATE TABLE AS SELECT(CAST)(二)-ConceptAST
- 【SQL】14 UNION 操作符、SELECT INTO 語句、INSERT INTO SELECT 語句、CREATE DATABASE 語句、CREATE TABLE 語句SQLDatabase
- Truncate table時不管使用drop storage或reuse storage都會講HWM重新設定
- use azure data studio to create external table for oracleOracle
- v$shared_pool_advice,v$db_cache_advice,v$pga_target_advice 建議器的使用
- Azure 基礎:自定義 Table storage 查詢條件
- 自定義 Azure Table storage 查詢過濾條件
- create table進階學習(二)_全域性臨時表_global temporary table
- oracle 19c 無法create table解決Oracle
- dual表與create table語句的關係
- CREATE TABLE AS SELECT(CAST)(一)-ORA-1652AST
- NOARCHIVE模式CREATE TABLE不記錄日誌呀Hive模式