# grep PageTables /proc/meminfo
PageTables:      1244880 kB

$ grep Huge /proc/meminfo
AnonHugePages:         0 kB
HugePages_Total:       0
HugePages_Free:        0
HugePages_Rsvd:        0
HugePages_Surp:        0
Hugepagesize:       2048 kB

#!/bin/bash
#
# hugepages_setting.sh
#
# Linux bash script to compute values for the
# recommended HugePages/HugeTLB configuration
#
# Note: This script does calculation for all shared memory
# segments available when the script is run, no matter it
# is an Oracle RDBMS shared memory segment or not.
# Check for the kernel version
KERN=`uname -r | awk -F. '{ printf("%d.%d\n",$1,$2); }'`
# Find out the HugePage size
HPG_SZ=`grep Hugepagesize /proc/meminfo | awk {'print $2'}`
# Start from 1 pages to be on the safe side and guarantee 1 free HugePage
NUM_PG=1
# Cumulative number of pages required to handle the running shared memory segments
for SEG_BYTES in `ipcs -m | awk {'print $5'} | grep "[0-9][0-9]*"`
do
   MIN_PG=`echo "$SEG_BYTES/($HPG_SZ*1024)" | bc -q`
   if [ $MIN_PG -gt 0 ]; then
      NUM_PG=`echo "$NUM_PG+$MIN_PG+1" | bc -q`
   fi
done
# Finish with results
case $KERN in
   '2.4') HUGETLB_POOL=`echo "$NUM_PG*$HPG_SZ/1024" | bc -q`;
          echo "Recommended setting: vm.hugetlb_pool = $HUGETLB_POOL" ;;
   '2.6' | '3.8' | '3.10' | '4.1' | '4.14' ) echo "Recommended setting: vm.nr_hugepages = $NUM_PG" ;;
    *) echo "Unrecognized kernel version $KERN. Exiting." ;;
esac
# End

$ chmod u+x hugepages_setting.sh

$ ./hugepages_setting.sh 
Recommended setting: vm.nr_hugepages = 305

vm.nr_hugepages=306

# sysctl -p

$ grep Huge /proc/meminfo
AnonHugePages:         0 kB
HugePages_Total:     306
HugePages_Free:      306
HugePages_Rsvd:        0
HugePages_Surp:        0
Hugepagesize:       2048 kB

* soft memlock 626688
* hard memlock 626688

SQL> show parameter target
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target                   integer     0
db_flashback_retention_target        integer     1440
fast_start_io_target                 integer     0
fast_start_mttr_target               integer     0
memory_max_target                    big integer 0
memory_target                        big integer 0
parallel_servers_target              integer     16
pga_aggregate_target                 big integer 200M
sga_target                           big integer 600M

$ grep Huge /proc/meminfo
AnonHugePages:         0 kB
HugePages_Total:     306
HugePages_Free:       98
HugePages_Rsvd:       93
HugePages_Surp:        0
Hugepagesize:       2048 kB

****************** Large Pages Information *****************
 
Total Shared Global Region in Large Pages = 602 MB (100%)
 
Large Pages used by this instance: 301 (602 MB)
Large Pages unused system wide = 5 (10 MB) (alloc incr 4096 KB)
Large Pages configured system wide = 306 (612 MB)
Large Page size = 2048 KB
***********************************************************

ALTER SYSTEM SET use_large_pages=only SCOPE=SPFILE;
SHUTDOWN IMMEDIATE;
STARTUP;

****************** Large Pages Information *****************
Parameter use_large_pages = ONLY
 
Total Shared Global Region in Large Pages = 602 MB (100%)
 
Large Pages used by this instance: 301 (602 MB)
Large Pages unused system wide = 5 (10 MB) (alloc incr 4096 KB)
Large Pages configured system wide = 306 (612 MB)
Large Page size = 2048 KB
***********************************************************

SQL> STARTUP
ORA-27137: unable to allocate large pages to create a shared memory segment
Linux-x86_64 Error: 12: Cannot allocate memory
SQL> 

****************** Large Pages Information *****************
Parameter use_large_pages = ONLY
 
Large Pages unused system wide = 0 (0 KB) (alloc incr 4096 KB)
Large Pages configured system wide = 0 (0 KB)
Large Page size = 2048 KB
 
ERROR:
  Failed to allocate shared global region with large pages, unix errno = 12.
  Aborting Instance startup.
  ORA-27137: unable to allocate Large Pages to create a shared memory segment
 
ACTION:
  Total Shared Global Region size is 608 MB. Increase the number of
  unused large pages to atleast 304 (608 MB) to allocate 100% Shared Global
  Region with Large Pages.
***********************************************************

#!/bin/bash
 
# Oracle大頁內(nèi)存性能測試 - 結(jié)果分析腳本
 
# 檢查參數(shù)
if [ -z "$1" ] || [ -z "$2" ]; then
    echo "用法: $0 <非大頁測試結(jié)果目錄> <大頁測試結(jié)果目錄>"
    exit 1
fi
 
# 定義常量
NON_HUGEPAGES_DIR=$1
HUGEPAGES_DIR=$2
ANALYSIS_DIR="$HOME/hugepages_analysis_$(date +%Y%m%d_%H%M%S)"
RESULT_FILE="$ANALYSIS_DIR/comparison_results.txt"
 
# 創(chuàng)建分析目錄
mkdir -p $ANALYSIS_DIR
 
# 記錄結(jié)果函數(shù)
record_result() {
    echo "$1" >> $RESULT_FILE
    echo "$1"
}
 
# 分析測試結(jié)果
analyze_test_results() {
    local test_type=$1
    local non_hugepages_files=$(find $NON_HUGEPAGES_DIR -name "${test_type}*.txt" | sort)
    local hugepages_files=$(find $HUGEPAGES_DIR -name "${test_type}*.txt" | sort)
    
    record_result "=== 測試類型: $test_type ==="
    record_result ""
    
    local non_hugepages_total_time=0
    local non_hugepages_count=0
    local hugepages_total_time=0
    local hugepages_count=0
    
    # 計(jì)算非大頁測試的平均時(shí)間
    record_result "非大頁測試結(jié)果:"
    for file in $non_hugepages_files; do
        # 提取real時(shí)間
        real_time=$(grep "real" "$file" | tail -1 | awk '{print $2}')
        # 轉(zhuǎn)換為秒
        minutes=$(echo $real_time | cut -d'm' -f1)
        seconds=$(echo $real_time | cut -d'm' -f2 | cut -d's' -f1)
        total_seconds=$(echo "scale=2; $minutes * 60 + $seconds" | bc)
        
        record_result "  文件: $(basename $file), 執(zhí)行時(shí)間: ${total_seconds}秒"
        non_hugepages_total_time=$(echo "scale=2; $non_hugepages_total_time + $total_seconds" | bc)
        ((non_hugepages_count++))
    done
    
    if [ $non_hugepages_count -gt 0 ]; then
        non_hugepages_avg_time=$(echo "scale=2; $non_hugepages_total_time / $non_hugepages_count" | bc)
        record_result "  平均執(zhí)行時(shí)間: ${non_hugepages_avg_time}秒"
    else
        record_result "  未找到非大頁測試結(jié)果"
        non_hugepages_avg_time=0
    fi
    
    record_result ""
    
    # 計(jì)算大頁測試的平均時(shí)間
    record_result "大頁測試結(jié)果:"
    for file in $hugepages_files; do
        # 提取real時(shí)間
        real_time=$(grep "real" "$file" | tail -1 | awk '{print $2}')
        # 轉(zhuǎn)換為秒
        minutes=$(echo $real_time | cut -d'm' -f1)
        seconds=$(echo $real_time | cut -d'm' -f2 | cut -d's' -f1)
        total_seconds=$(echo "scale=2; $minutes * 60 + $seconds" | bc)
        
        record_result "  文件: $(basename $file), 執(zhí)行時(shí)間: ${total_seconds}秒"
        hugepages_total_time=$(echo "scale=2; $hugepages_total_time + $total_seconds" | bc)
        ((hugepages_count++))
    done
    
    if [ $hugepages_count -gt 0 ]; then
        hugepages_avg_time=$(echo "scale=2; $hugepages_total_time / $hugepages_count" | bc)
        record_result "  平均執(zhí)行時(shí)間: ${hugepages_avg_time}秒"
    else
        record_result "  未找到大頁測試結(jié)果"
        hugepages_avg_time=0
    fi
    
    record_result ""
    
    # 計(jì)算性能提升百分比
    if [ $non_hugepages_avg_time -gt 0 ] && [ $hugepages_avg_time -gt 0 ]; then
        improvement=$(echo "scale=2; (1 - $hugepages_avg_time / $non_hugepages_avg_time) * 100" | bc)
        record_result "性能提升: ${improvement}%"
    else
        record_result "無法計(jì)算性能提升百分比"
    fi
    
    record_result "========================================"
    record_result ""
}
 
# 主函數(shù)
record_result "Oracle大頁內(nèi)存性能測試對比分析"
record_result "測試日期: $(date)"
record_result "非大頁測試結(jié)果目錄: $NON_HUGEPAGES_DIR"
record_result "大頁測試結(jié)果目錄: $HUGEPAGES_DIR"
record_result "----------------------------------------"
record_result ""
 
# 分析各項(xiàng)測試結(jié)果
analyze_test_results "full_table_scan"
analyze_test_results "index_scan"
analyze_test_results "dml_operations"
 
# 生成圖表數(shù)據(jù)
if [ -f "$RESULT_FILE" ]; then
    # 提取性能提升數(shù)據(jù)
    grep "性能提升" "$RESULT_FILE" > "$ANALYSIS_DIR/improvement_data.txt"
    
    # 創(chuàng)建簡單的性能對比圖表
    cat > "$ANALYSIS_DIR/performance_comparison_chart.csv" <<EOF
測試類型,非大頁平均時(shí)間(秒),大頁平均時(shí)間(秒),性能提升(%)
全表掃描,$(grep "全表掃描" "$RESULT_FILE" | awk '{print $5}'),$(grep "全表掃描" "$RESULT_FILE" | awk '{print $12}'),$(grep "全表掃描" "$RESULT_FILE" | awk '{print $15}')
索引掃描,$(grep "索引掃描" "$RESULT_FILE" | awk '{print $5}'),$(grep "索引掃描" "$RESULT_FILE" | awk '{print $12}'),$(grep "索引掃描" "$RESULT_FILE" | awk '{print $15}')
DML操作,$(grep "DML操作" "$RESULT_FILE" | awk '{print $5}'),$(grep "DML操作" "$RESULT_FILE" | awk '{print $12}'),$(grep "DML操作" "$RESULT_FILE" | awk '{print $15}')
EOF
    
    record_result "分析完成，結(jié)果保存在: $RESULT_FILE"
    record_result "圖表數(shù)據(jù)保存在: $ANALYSIS_DIR/performance_comparison_chart.csv"
fi    

#!/bin/bash
 
# Oracle大頁內(nèi)存性能測試 - 測試執(zhí)行腳本
 
# 檢查是否為oracle用戶
if [ "$(id -un)" != "oracle" ]; then
    echo "請使用oracle用戶執(zhí)行此腳本"
    exit 1
fi
 
# 定義常量
ORACLE_SID="TESTDB"
ORACLE_HOME="/u01/app/oracle/product/19.3.0/dbhome_1"
TEST_USER="testuser"
TEST_PASS="testuser"
TEST_RUNS=5
TEST_RESULTS_DIR="$HOME/hugepages_test_results"
LOG_FILE="$TEST_RESULTS_DIR/performance_test_$(date +%Y%m%d_%H%M%S).log"
 
# 創(chuàng)建結(jié)果目錄
mkdir -p $TEST_RESULTS_DIR
 
# 記錄日志函數(shù)
log() {
    echo "$(date '+%Y-%m-%d %H:%M:%S') - $1" | tee -a $LOG_FILE
}
 
# 函數(shù)：執(zhí)行SQL測試
run_sql_test() {
    local test_name=$1
    local sql_statement=$2
    local test_file="$TEST_RESULTS_DIR/${test_name}_$(date +%Y%m%d_%H%M%S).txt"
    
    log "開始測試: $test_name"
    
    for ((i=1; i<=$TEST_RUNS; i++)); do
        log "  測試運(yùn)行 #$i"
        
        # 執(zhí)行SQL并記錄時(shí)間
        { time $ORACLE_HOME/bin/sqlplus -S $TEST_USER/$TEST_PASS <<EOF
SET TIMING ON
SET SERVEROUTPUT ON
$sql_statement
EXIT;
EOF
        ; } 2>> $test_file
        
        # 睡眠2秒
        sleep 2
    done
    
    log "完成測試: $test_name"
}
 
# 函數(shù)：執(zhí)行基準(zhǔn)測試
run_benchmark_tests() {
    log "開始執(zhí)行基準(zhǔn)測試..."
    
    # 測試1: 全表掃描
    run_sql_test "full_table_scan" "SELECT COUNT(*) FROM test_table;"
    
    # 測試2: 索引掃描
    run_sql_test "index_scan" "SELECT * FROM test_table WHERE created_date > SYSDATE - 100;"
    
    # 測試3: DML操作
    run_sql_test "dml_operations" "
DECLARE
    v_cnt NUMBER;
BEGIN
    -- 更新操作
    UPDATE test_table SET data = data || '_UPDATED' WHERE MOD(id, 10) = 0;
    COMMIT;
    
    -- 刪除操作
    DELETE FROM test_table WHERE id > 990000;
    COMMIT;
    
    -- 插入操作
    FOR i IN 990001..1000000 LOOP
        INSERT INTO test_table VALUES (i, 'NEW TEST DATA ' || TO_CHAR(i), SYSDATE);
    END LOOP;
    COMMIT;
    
    -- 回滾測試
    SAVEPOINT sp1;
    UPDATE test_table SET data = data || '_TEMP' WHERE MOD(id, 5) = 0;
    ROLLBACK TO sp1;
    
    -- 統(tǒng)計(jì)行數(shù)
    SELECT COUNT(*) INTO v_cnt FROM test_table;
    DBMS_OUTPUT.PUT_LINE('總行數(shù): ' || v_cnt);
END;
/
"
    
    log "基準(zhǔn)測試完成"
}
 
# 函數(shù)：收集AWR報(bào)告
collect_awr_report() {
    log "收集AWR報(bào)告..."
    
    local snapshot_id_start=$($ORACLE_HOME/bin/sqlplus -S / as sysdba <<EOF
SET HEADING OFF
SET FEEDBACK OFF
SET PAGESIZE 0
SELECT MAX(snap_id) FROM dba_hist_snapshot;
EXIT;
EOF
)
    
    # 等待10分鐘收集性能數(shù)據(jù)
    log "等待10分鐘收集性能數(shù)據(jù)..."
    sleep 600
    
    local snapshot_id_end=$($ORACLE_HOME/bin/sqlplus -S / as sysdba <<EOF
SET HEADING OFF
SET FEEDBACK OFF
SET PAGESIZE 0
SELECT MAX(snap_id) FROM dba_hist_snapshot;
EXIT;
EOF
)
    
    local awr_file="$TEST_RESULTS_DIR/awr_report_$(date +%Y%m%d_%H%M%S).html"
    
    # 創(chuàng)建AWR報(bào)告
    $ORACLE_HOME/bin/sqlplus -S / as sysdba <<EOF
SET SERVEROUTPUT ON
SPOOL $awr_file
@?/rdbms/admin/awrrpt.sql html
$snapshot_id_start
$snapshot_id_end
7
SPOOL OFF
EXIT;
EOF
    
    log "AWR報(bào)告已生成: $awr_file"
}
 
# 主函數(shù)
case "$1" in
    run-tests)
        log "=== 開始性能測試 ==="
        run_benchmark_tests
        log "=== 性能測試完成 ==="
        ;;
    collect-awr)
        log "=== 開始收集AWR報(bào)告 ==="
        collect_awr_report
        log "=== AWR報(bào)告收集完成 ==="
        ;;
    *)
        echo "用法: $0 [run-tests|collect-awr]"
        echo "  run-tests     - 執(zhí)行基準(zhǔn)測試"
        echo "  collect-awr   - 收集AWR性能報(bào)告"
        exit 1
        ;;
esac    

#!/bin/bash
 
# Oracle大頁內(nèi)存性能測試 - 環(huán)境準(zhǔn)備腳本
 
# 檢查是否為root用戶
if [ "$(id -u)" -ne 0 ]; then
    echo "請使用root用戶執(zhí)行此腳本"
    exit 1
fi
 
# 定義常量
SGA_SIZE_GB=8
HUGEPAGE_SIZE_MB=2
HUGEPAGE_COUNT=$((SGA_SIZE_GB * 1024 / HUGEPAGE_SIZE_MB))
ORACLE_SID="TESTDB"
ORACLE_HOME="/u01/app/oracle/product/19.3.0/dbhome_1"
 
# 函數(shù)：配置大頁內(nèi)存
configure_hugepages() {
    echo "配置大頁內(nèi)存..."
    # 修改sysctl.conf
    cat >> /etc/sysctl.conf <<EOF
# 配置大頁內(nèi)存用于Oracle性能測試
vm.nr_hugepages = $HUGEPAGE_COUNT
vm.transparent_hugepage.enabled = never
vm.transparent_hugepage.khugepaged = never
EOF
    
    # 使配置生效
    sysctl -p
    
    # 配置大頁掛載點(diǎn)
    if ! grep -q "hugetlbfs" /etc/fstab; then
        echo "none /dev/hugepages hugetlbfs defaults 0 0" >> /etc/fstab
        mkdir -p /dev/hugepages
        mount -a
    fi
    
    echo "大頁內(nèi)存配置完成"
}
 
# 函數(shù)：禁用大頁內(nèi)存
disable_hugepages() {
    echo "禁用大頁內(nèi)存..."
    # 修改sysctl.conf
    sed -i '/vm.nr_hugepages/d' /etc/sysctl.conf
    sed -i '/vm.transparent_hugepage/d' /etc/sysctl.conf
    
    # 添加禁用配置
    cat >> /etc/sysctl.conf <<EOF
# 禁用大頁內(nèi)存
vm.nr_hugepages = 0
vm.transparent_hugepage.enabled = always
vm.transparent_hugepage.khugepaged = always
EOF
    
    # 使配置生效
    sysctl -p
    
    # 卸載大頁掛載點(diǎn)
    if grep -q "hugetlbfs" /etc/fstab; then
        umount /dev/hugepages 2>/dev/null
        sed -i '/hugetlbfs/d' /etc/fstab
    fi
    
    echo "大頁內(nèi)存已禁用"
}
 
# 函數(shù)：配置Oracle使用大頁
configure_oracle_hugepages() {
    echo "配置Oracle使用大頁內(nèi)存..."
    su - oracle -c "$ORACLE_HOME/bin/sqlplus / as sysdba <<EOF
ALTER SYSTEM SET sga_target=${SGA_SIZE_GB}G SCOPE=SPFILE;
ALTER SYSTEM SET use_large_pages=TRUE SCOPE=SPFILE;
EXIT;
EOF"
    
    echo "Oracle大頁配置完成，請重啟數(shù)據(jù)庫使配置生效"
}
 
# 函數(shù)：配置Oracle不使用大頁
configure_oracle_no_hugepages() {
    echo "配置Oracle不使用大頁內(nèi)存..."
    su - oracle -c "$ORACLE_HOME/bin/sqlplus / as sysdba <<EOF
ALTER SYSTEM SET sga_target=${SGA_SIZE_GB}G SCOPE=SPFILE;
ALTER SYSTEM SET use_large_pages=FALSE SCOPE=SPFILE;
EXIT;
EOF"
    
    echo "Oracle大頁配置已禁用，請重啟數(shù)據(jù)庫使配置生效"
}
 
# 函數(shù)：創(chuàng)建測試用戶和表
create_test_objects() {
    echo "創(chuàng)建測試用戶和表..."
    su - oracle -c "$ORACLE_HOME/bin/sqlplus / as sysdba <<EOF
CREATE USER testuser IDENTIFIED BY testuser DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp;
GRANT CONNECT, RESOURCE, DBA TO testuser;
EXIT;
EOF"
    
    # 創(chuàng)建測試表
    su - oracle -c "$ORACLE_HOME/bin/sqlplus testuser/testuser <<EOF
CREATE TABLE test_table (
    id NUMBER PRIMARY KEY,
    data VARCHAR2(4000),
    created_date DATE
);
-- 插入100萬條測試數(shù)據(jù)
BEGIN
    FOR i IN 1..1000000 LOOP
        INSERT INTO test_table VALUES (i, 'TEST DATA ' || TO_CHAR(i), SYSDATE);
        IF MOD(i, 10000) = 0 THEN
            COMMIT;
        END IF;
    END LOOP;
    COMMIT;
END;
/
-- 創(chuàng)建索引
CREATE INDEX idx_test_table ON test_table(created_date);
EXIT;
EOF"
    
    echo "測試對象創(chuàng)建完成"
}
 
# 主函數(shù)
case "$1" in
    enable-hugepages)
        configure_hugepages
        configure_oracle_hugepages
        ;;
    disable-hugepages)
        disable_hugepages
        configure_oracle_no_hugepages
        ;;
    create-test-data)
        create_test_objects
        ;;
    *)
        echo "用法: $0 [enable-hugepages|disable-hugepages|create-test-data]"
        echo "  enable-hugepages    - 配置并啟用大頁內(nèi)存"
        echo "  disable-hugepages   - 禁用大頁內(nèi)存"
        echo "  create-test-data    - 創(chuàng)建測試數(shù)據(jù)"
        exit 1
        ;;
esac    

# Oracle大頁內(nèi)存性能測試實(shí)驗(yàn)步驟
 
## 一、測試環(huán)境準(zhǔn)備
### 1. 系統(tǒng)和數(shù)據(jù)庫配置
確保測試環(huán)境滿足以下條件：
- Linux操作系統(tǒng)（推薦Oracle Linux 7或Red Hat Enterprise Linux 7及以上版本）
- Oracle數(shù)據(jù)庫（12c及以上版本）
- 足夠的內(nèi)存（建議至少16GB）
- 測試數(shù)據(jù)庫實(shí)例
### 2. 安裝測試腳本
將提供的三個(gè)腳本文件復(fù)制到測試服務(wù)器：
- setup-test-env.sh - 環(huán)境準(zhǔn)備腳本
- run-performance-tests.sh - 測試執(zhí)行腳本
- analyze-results.sh - 結(jié)果分析腳本
 
確保腳本具有執(zhí)行權(quán)限：chmod +x setup-test-env.sh run-performance-tests.sh analyze-results.sh
 
## 二、執(zhí)行測試
### 1. 禁用大頁內(nèi)存并進(jìn)行測試
首先，以root用戶執(zhí)行以下命令禁用大頁內(nèi)存并配置Oracle不使用大頁：./setup-test-env.sh disable-hugepages
重啟系統(tǒng)使配置生效：shutdown -r now
系統(tǒng)重啟后，以oracle用戶連接數(shù)據(jù)庫并啟動(dòng)數(shù)據(jù)庫：sqlplus / as sysdba
STARTUP
創(chuàng)建測試數(shù)據(jù)：./setup-test-env.sh create-test-data
執(zhí)行基準(zhǔn)測試并收集結(jié)果：mkdir -p ~/non_hugepages_results
./run-performance-tests.sh run-tests > ~/non_hugepages_results/test_log_$(date +%Y%m%d).txt
./run-performance-tests.sh collect-awr > ~/non_hugepages_results/awr_log_$(date +%Y%m%d).txt
### 2. 啟用大頁內(nèi)存并進(jìn)行測試
以root用戶執(zhí)行以下命令啟用大頁內(nèi)存并配置Oracle使用大頁：./setup-test-env.sh enable-hugepages
重啟系統(tǒng)使配置生效：shutdown -r now
系統(tǒng)重啟后，以oracle用戶連接數(shù)據(jù)庫并啟動(dòng)數(shù)據(jù)庫：sqlplus / as sysdba
STARTUP
執(zhí)行基準(zhǔn)測試并收集結(jié)果：mkdir -p ~/hugepages_results
./run-performance-tests.sh run-tests > ~/hugepages_results/test_log_$(date +%Y%m%d).txt
./run-performance-tests.sh collect-awr > ~/hugepages_results/awr_log_$(date +%Y%m%d).txt
 
## 三、分析測試結(jié)果
以oracle用戶執(zhí)行結(jié)果分析腳本：./analyze-results.sh ~/non_hugepages_results ~/hugepages_results
分析腳本會(huì)生成詳細(xì)的測試對比結(jié)果和圖表數(shù)據(jù)，查看結(jié)果文件：cat ~/hugepages_analysis_*/comparison_results.txt
 
## 四、實(shí)驗(yàn)結(jié)果解讀
分析結(jié)果文件中的數(shù)據(jù)，重點(diǎn)關(guān)注以下指標(biāo)：
1. 各項(xiàng)測試（全表掃描、索引掃描、DML操作）在啟用大頁和未啟用大頁情況下的執(zhí)行時(shí)間對比
2. 性能提升百分比
3. AWR報(bào)告中的內(nèi)存使用情況、CPU使用率等關(guān)鍵指標(biāo)
 
通常情況下，啟用大頁內(nèi)存后，Oracle數(shù)據(jù)庫的性能會(huì)有明顯提升，尤其是在內(nèi)存訪問密集型操作中。
 
## 五、注意事項(xiàng)
1. 在測試過程中，確保系統(tǒng)負(fù)載穩(wěn)定，避免其他應(yīng)用程序干擾測試結(jié)果
2. 測試前關(guān)閉所有不必要的服務(wù)和進(jìn)程
3. 建議進(jìn)行多次測試以確保結(jié)果的可靠性
4. 測試完成后，可以根據(jù)實(shí)際情況決定是否在生產(chǎn)環(huán)境中啟用大頁內(nèi)存配置