oracle10g rac_dbms_service_dba_service系列檢視學習筆記
---dbms_service與dba_services_v$service的學習
1,透過dbms_service可以靈活定製service一些指標，更適應業務的需要
2,dba_services的資訊要比v$service更為豐富，多了taf方面
dtp
Declares the service to be for DTP or distributed transactions including XA transactions ---對於這個dtp也僅止於概念而已，變更它們的值true/false有本質區別
由於對plsql語法掌握不牢固，處理方法如下：
SQL> exec dbms_service.modify_service(service_name => 'service2',failover_method=>'0');
begin dbms_service.modify_service(service_name => 'service2',failover_method=>'0'); end;
ORA-44316: invalid argument
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_SERVICE", line 394
ORA-06512: at "SYS.DBMS_SERVICE", line 280
ORA-06512: at line 2
SQL> exec dbms_service.modify_service(service_name => 'service2',failover_method=>dbms_service.failover_method_none);---
PL/SQL procedure successfully completed
附上dbms_service.mofify_service的測試筆記,供後期參考與深入掌握
SQL> exec dbms_service.modify_service(service_name => 'service2',failover_method=>dbms_service.failover_method_none);
PL/SQL procedure successfully completed
SQL> select * from dba_services where name='service2';
SERVICE_ID NAME NAME_HASH NETWORK_NAME CREATION_DATE CREATION_DATE_HASH FAILOVER_METHOD FAILOVER_TYPE FAILOVER_RETRIES FAILOVER_DELAY MIN_CARDINALITY MAX_CARDINALITY GOAL DTP ENABLED AQ_HA_NOTIFICATIONS CLB_GOAL
---------- ---------------------------------------------------------------- ---------- -------------------------------------------------------------------------------- ------------- ------------------ ---------------------------------------------------------------- ---------------------------------------------------------------- ---------------- -------------- --------------- --------------- ------------ --- ------- ------------------- --------
8 service2 1180431924 service2 2010-4-11 上午 589942238 NONE SERVICE_TIME Y NO NO LONG
SQL> exec dbms_service.modify_service(service_name => 'service2',failover_method=>dbms_service.failover_method_basic);
PL/SQL procedure successfully completed
SQL> select * from dba_services where name='service2';
SERVICE_ID NAME NAME_HASH NETWORK_NAME CREATION_DATE CREATION_DATE_HASH FAILOVER_METHOD FAILOVER_TYPE FAILOVER_RETRIES FAILOVER_DELAY MIN_CARDINALITY MAX_CARDINALITY GOAL DTP ENABLED AQ_HA_NOTIFICATIONS CLB_GOAL
---------- ---------------------------------------------------------------- ---------- -------------------------------------------------------------------------------- ------------- ------------------ ---------------------------------------------------------------- ---------------------------------------------------------------- ---------------- -------------- --------------- --------------- ------------ --- ------- ------------------- --------
8 service2 1180431924 service2 2010-4-11 上午 589942238 BASIC SERVICE_TIME Y NO NO LONG
SQL> exec dbms_service.modify_service(service_name => 'service2',failover_method=>dbms_service.failover_method_none);
PL/SQL procedure successfully completed
SQL> exec dbms_service.modify_service(service_name => 'service2',failover_type=>dbms_service.failover_type_none);
PL/SQL procedure successfully completed
SQL> exec dbms_service.modify_service(service_name => 'service2',failover_type=>dbms_service.failover_type_select);
PL/SQL procedure successfully completed
SQL> exec dbms_service.modify_service(service_name => 'service2',failover_type=>dbms_service.failover_type_session);
PL/SQL procedure successfully completed
SQL> select * from dba_services where name='service2';
SERVICE_ID NAME NAME_HASH NETWORK_NAME CREATION_DATE CREATION_DATE_HASH FAILOVER_METHOD FAILOVER_TYPE FAILOVER_RETRIES FAILOVER_DELAY MIN_CARDINALITY MAX_CARDINALITY GOAL DTP ENABLED AQ_HA_NOTIFICATIONS CLB_GOAL
---------- ---------------------------------------------------------------- ---------- -------------------------------------------------------------------------------- ------------- ------------------ ---------------------------------------------------------------- ---------------------------------------------------------------- ---------------- -------------- --------------- --------------- ------------ --- ------- ------------------- --------
8 service2 1180431924 service2 2010-4-11 上午 589942238 SESSION SERVICE_TIME Y NO NO LONG
SQL> exec dbms_service.modify_service(service_name => 'service2',failover_retries=>10);
PL/SQL procedure successfully completed
SQL> exec dbms_service.modify_service(service_name => 'service2',failover_delay=>3);
PL/SQL procedure successfully completed
SQL> select * from dba_services where name='service2';
SERVICE_ID NAME NAME_HASH NETWORK_NAME CREATION_DATE CREATION_DATE_HASH FAILOVER_METHOD FAILOVER_TYPE FAILOVER_RETRIES FAILOVER_DELAY MIN_CARDINALITY MAX_CARDINALITY GOAL DTP ENABLED AQ_HA_NOTIFICATIONS CLB_GOAL
---------- ---------------------------------------------------------------- ---------- -------------------------------------------------------------------------------- ------------- ------------------ ---------------------------------------------------------------- ---------------------------------------------------------------- ---------------- -------------- --------------- --------------- ------------ --- ------- ------------------- --------
8 service2 1180431924 service2 2010-4-11 上午 589942238 3 SERVICE_TIME Y NO NO LONG
SQL> exec dbms_service.modify_service(service_name => 'service2',failover_delay=>20);
PL/SQL procedure successfully completed
SQL> select * from dba_services where name='service2';
SERVICE_ID NAME NAME_HASH NETWORK_NAME CREATION_DATE CREATION_DATE_HASH FAILOVER_METHOD FAILOVER_TYPE FAILOVER_RETRIES FAILOVER_DELAY MIN_CARDINALITY MAX_CARDINALITY GOAL DTP ENABLED AQ_HA_NOTIFICATIONS CLB_GOAL
---------- ---------------------------------------------------------------- ---------- -------------------------------------------------------------------------------- ------------- ------------------ ---------------------------------------------------------------- ---------------------------------------------------------------- ---------------- -------------- --------------- --------------- ------------ --- ------- ------------------- --------
8 service2 1180431924 service2 2010-4-11 上午 589942238 20 SERVICE_TIME Y NO NO LONG
SQL> exec dbms_service.modify_service(service_name => 'service2',failover_retries=>29);
PL/SQL procedure successfully completed
SQL> select * from dba_services where name='service2';
SERVICE_ID NAME NAME_HASH NETWORK_NAME CREATION_DATE CREATION_DATE_HASH FAILOVER_METHOD FAILOVER_TYPE FAILOVER_RETRIES FAILOVER_DELAY MIN_CARDINALITY MAX_CARDINALITY GOAL DTP ENABLED AQ_HA_NOTIFICATIONS CLB_GOAL
---------- ---------------------------------------------------------------- ---------- -------------------------------------------------------------------------------- ------------- ------------------ ---------------------------------------------------------------- ---------------------------------------------------------------- ---------------- -------------- --------------- --------------- ------------ --- ------- ------------------- --------
8 service2 1180431924 service2 2010-4-11 上午 589942238 29 SERVICE_TIME Y NO NO LONG
SQL>
---以上測試發現，retries與delay不能同時配置，也就是這兩個引數可能是互斥的；理解oracle底層有個限制，如果配置不合理，可能就不會生效
dbms_service其它 子過程同理，不再測試
分析與調整service一些檢視
V$SERVICEMETRIC
--根據每5秒和1分鐘時間對service不同的度量值進行取樣
V$SERVICEMETRIC displays metric values measured on the most recent time interval period for services executing inside the database.
Service metrics are measured in 5-second and 1-minute intervals.
Column Datatype Description
BEGIN_TIME DATE Begin timestamp for the interval period --取樣間隔開始時間
END_TIME DATE End timestamp for the interval period --取樣間隔結束時間
INTSIZE_CSEC NUMBER Interval size (in hundredths of a second) ---取樣間隔時間大小
GROUP_ID NUMBER Group ID for the service metric group ---服務度量組的group id,同型別的service進行分組管理
SERVICE_NAME_HASH NUMBER Service name hash --服務名hash,oracle好多檢視採用瞭如何機制，比如v$session,v$sqlarea and etc
SERVICE_NAME VARCHAR2(64) Service name --服務名
CTMHASH NUMBER Service create timestamp hash value---服務建立時間的hash值
ELAPSEDPERCALL NUMBER Elapsed time per call (in microseconds). This column is deprecated in favor of the DBTIMEPERCALL column.---此列已不用，被dbtimepercall列替換;
----每個使用者呼叫花費的時間
CPUPERCALL NUMBER CPU time per call (in microseconds)---每個呼叫花費的cpu time
DBTIMEPERCALL NUMBER Elapsed time per call (in microseconds)---每個呼叫花費的時間(花費時間>cpu time)
CALLSPERSEC NUMBER Number of user calls per second ---每秒內發生多少次使用者呼叫
DBTIMEPERSEC NUMBER DB time per second ---每秒產生的db time 是多少
---友好度，從字面可以這樣譯；這個值越低越好；oracle根據goal(long及short，請參考dbms_service章節）的不同值，對不同的service，從內部計算它的值。通俗來講，就是不同的服務在處理工作負荷時，對於各個rac例項的吸引力;我也沒有測試，理解不深
GOODNESS NUMBER Indicates how attractive a given instance is with respect to processing the workload that is presented to the service. A lower number is better.
This number is internally computed based on the GOAL (LONG or SHORT) that is specified for the particular service.
---這個值表明，每個新增的會話接入到某個rac實含例的可以預側到的增長數
DELTA NUMBER Indicates the predicted increase in the goodness for every additional session that is routed to this instance
---是個列表型別的列
FLAGS NUMBER Can be any of the following values:
*
0x01 - service is BLOCKED from accepting new connections ---服務接受新的連線時，可能正處於阻塞
*
0x02 - service is VIOLATING the set threshold on some metric ---服務違反某些度量上面的閥值
*
0x04 - goodness is UNKNOWN ---服務目前的狀態為未知
---以下含義與以上差不多，區別在於取樣是最近一段時間的，記錄數更多，便於分析service的執行趨勢
V$SERVICEMETRIC_HISTORY
V$SERVICEMETRIC_HISTORY displays a recent history of the metric values measured in predefined time interval periods for services executing inside the database. Service metrics are measured in 5-second and 1-minute intervals.
Column Datatype Description
BEGIN_TIME DATE Begin timestamp for the interval period
END_TIME DATE End timestamp for the interval period
INTSIZE_CSEC NUMBER Interval size (in hundredths of a second)
GROUP_ID NUMBER Group ID for the service metric group
SERVICE_NAME_HASH NUMBER Service name hash
SERVICE_NAME VARCHAR2(64) Service name
CTMHASH NUMBER Service create timestamp hash value
ELAPSEDPERCALL NUMBER Elapsed time per call (in microseconds). This column is deprecated in favor of the DBTIMEPERCALL column.
CPUPERCALL NUMBER CPU time per call (in microseconds)
DBTIMEPERCALL NUMBER Elapsed time per call (in microseconds)
CALLSPERSEC NUMBER Number of user calls per second
DBTIMEPERSEC NUMBER DB time per second
1,透過dbms_service可以靈活定製service一些指標，更適應業務的需要
2,dba_services的資訊要比v$service更為豐富，多了taf方面
dtp
Declares the service to be for DTP or distributed transactions including XA transactions ---對於這個dtp也僅止於概念而已，變更它們的值true/false有本質區別
由於對plsql語法掌握不牢固，處理方法如下：
SQL> exec dbms_service.modify_service(service_name => 'service2',failover_method=>'0');
begin dbms_service.modify_service(service_name => 'service2',failover_method=>'0'); end;
ORA-44316: invalid argument
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_SERVICE", line 394
ORA-06512: at "SYS.DBMS_SERVICE", line 280
ORA-06512: at line 2
SQL> exec dbms_service.modify_service(service_name => 'service2',failover_method=>dbms_service.failover_method_none);---
PL/SQL procedure successfully completed
附上dbms_service.mofify_service的測試筆記,供後期參考與深入掌握
SQL> exec dbms_service.modify_service(service_name => 'service2',failover_method=>dbms_service.failover_method_none);
PL/SQL procedure successfully completed
SQL> select * from dba_services where name='service2';
SERVICE_ID NAME NAME_HASH NETWORK_NAME CREATION_DATE CREATION_DATE_HASH FAILOVER_METHOD FAILOVER_TYPE FAILOVER_RETRIES FAILOVER_DELAY MIN_CARDINALITY MAX_CARDINALITY GOAL DTP ENABLED AQ_HA_NOTIFICATIONS CLB_GOAL
---------- ---------------------------------------------------------------- ---------- -------------------------------------------------------------------------------- ------------- ------------------ ---------------------------------------------------------------- ---------------------------------------------------------------- ---------------- -------------- --------------- --------------- ------------ --- ------- ------------------- --------
8 service2 1180431924 service2 2010-4-11 上午 589942238 NONE SERVICE_TIME Y NO NO LONG
SQL> exec dbms_service.modify_service(service_name => 'service2',failover_method=>dbms_service.failover_method_basic);
PL/SQL procedure successfully completed
SQL> select * from dba_services where name='service2';
SERVICE_ID NAME NAME_HASH NETWORK_NAME CREATION_DATE CREATION_DATE_HASH FAILOVER_METHOD FAILOVER_TYPE FAILOVER_RETRIES FAILOVER_DELAY MIN_CARDINALITY MAX_CARDINALITY GOAL DTP ENABLED AQ_HA_NOTIFICATIONS CLB_GOAL
---------- ---------------------------------------------------------------- ---------- -------------------------------------------------------------------------------- ------------- ------------------ ---------------------------------------------------------------- ---------------------------------------------------------------- ---------------- -------------- --------------- --------------- ------------ --- ------- ------------------- --------
8 service2 1180431924 service2 2010-4-11 上午 589942238 BASIC SERVICE_TIME Y NO NO LONG
SQL> exec dbms_service.modify_service(service_name => 'service2',failover_method=>dbms_service.failover_method_none);
PL/SQL procedure successfully completed
SQL> exec dbms_service.modify_service(service_name => 'service2',failover_type=>dbms_service.failover_type_none);
PL/SQL procedure successfully completed
SQL> exec dbms_service.modify_service(service_name => 'service2',failover_type=>dbms_service.failover_type_select);
PL/SQL procedure successfully completed
SQL> exec dbms_service.modify_service(service_name => 'service2',failover_type=>dbms_service.failover_type_session);
PL/SQL procedure successfully completed
SQL> select * from dba_services where name='service2';
SERVICE_ID NAME NAME_HASH NETWORK_NAME CREATION_DATE CREATION_DATE_HASH FAILOVER_METHOD FAILOVER_TYPE FAILOVER_RETRIES FAILOVER_DELAY MIN_CARDINALITY MAX_CARDINALITY GOAL DTP ENABLED AQ_HA_NOTIFICATIONS CLB_GOAL
---------- ---------------------------------------------------------------- ---------- -------------------------------------------------------------------------------- ------------- ------------------ ---------------------------------------------------------------- ---------------------------------------------------------------- ---------------- -------------- --------------- --------------- ------------ --- ------- ------------------- --------
8 service2 1180431924 service2 2010-4-11 上午 589942238 SESSION SERVICE_TIME Y NO NO LONG
SQL> exec dbms_service.modify_service(service_name => 'service2',failover_retries=>10);
PL/SQL procedure successfully completed
SQL> exec dbms_service.modify_service(service_name => 'service2',failover_delay=>3);
PL/SQL procedure successfully completed
SQL> select * from dba_services where name='service2';
SERVICE_ID NAME NAME_HASH NETWORK_NAME CREATION_DATE CREATION_DATE_HASH FAILOVER_METHOD FAILOVER_TYPE FAILOVER_RETRIES FAILOVER_DELAY MIN_CARDINALITY MAX_CARDINALITY GOAL DTP ENABLED AQ_HA_NOTIFICATIONS CLB_GOAL
---------- ---------------------------------------------------------------- ---------- -------------------------------------------------------------------------------- ------------- ------------------ ---------------------------------------------------------------- ---------------------------------------------------------------- ---------------- -------------- --------------- --------------- ------------ --- ------- ------------------- --------
8 service2 1180431924 service2 2010-4-11 上午 589942238 3 SERVICE_TIME Y NO NO LONG
SQL> exec dbms_service.modify_service(service_name => 'service2',failover_delay=>20);
PL/SQL procedure successfully completed
SQL> select * from dba_services where name='service2';
SERVICE_ID NAME NAME_HASH NETWORK_NAME CREATION_DATE CREATION_DATE_HASH FAILOVER_METHOD FAILOVER_TYPE FAILOVER_RETRIES FAILOVER_DELAY MIN_CARDINALITY MAX_CARDINALITY GOAL DTP ENABLED AQ_HA_NOTIFICATIONS CLB_GOAL
---------- ---------------------------------------------------------------- ---------- -------------------------------------------------------------------------------- ------------- ------------------ ---------------------------------------------------------------- ---------------------------------------------------------------- ---------------- -------------- --------------- --------------- ------------ --- ------- ------------------- --------
8 service2 1180431924 service2 2010-4-11 上午 589942238 20 SERVICE_TIME Y NO NO LONG
SQL> exec dbms_service.modify_service(service_name => 'service2',failover_retries=>29);
PL/SQL procedure successfully completed
SQL> select * from dba_services where name='service2';
SERVICE_ID NAME NAME_HASH NETWORK_NAME CREATION_DATE CREATION_DATE_HASH FAILOVER_METHOD FAILOVER_TYPE FAILOVER_RETRIES FAILOVER_DELAY MIN_CARDINALITY MAX_CARDINALITY GOAL DTP ENABLED AQ_HA_NOTIFICATIONS CLB_GOAL
---------- ---------------------------------------------------------------- ---------- -------------------------------------------------------------------------------- ------------- ------------------ ---------------------------------------------------------------- ---------------------------------------------------------------- ---------------- -------------- --------------- --------------- ------------ --- ------- ------------------- --------
8 service2 1180431924 service2 2010-4-11 上午 589942238 29 SERVICE_TIME Y NO NO LONG
SQL>
---以上測試發現，retries與delay不能同時配置，也就是這兩個引數可能是互斥的；理解oracle底層有個限制，如果配置不合理，可能就不會生效
dbms_service其它 子過程同理，不再測試
分析與調整service一些檢視
V$SERVICEMETRIC
--根據每5秒和1分鐘時間對service不同的度量值進行取樣
V$SERVICEMETRIC displays metric values measured on the most recent time interval period for services executing inside the database.
Service metrics are measured in 5-second and 1-minute intervals.
Column Datatype Description
BEGIN_TIME DATE Begin timestamp for the interval period --取樣間隔開始時間
END_TIME DATE End timestamp for the interval period --取樣間隔結束時間
INTSIZE_CSEC NUMBER Interval size (in hundredths of a second) ---取樣間隔時間大小
GROUP_ID NUMBER Group ID for the service metric group ---服務度量組的group id,同型別的service進行分組管理
SERVICE_NAME_HASH NUMBER Service name hash --服務名hash,oracle好多檢視採用瞭如何機制，比如v$session,v$sqlarea and etc
SERVICE_NAME VARCHAR2(64) Service name --服務名
CTMHASH NUMBER Service create timestamp hash value---服務建立時間的hash值
ELAPSEDPERCALL NUMBER Elapsed time per call (in microseconds). This column is deprecated in favor of the DBTIMEPERCALL column.---此列已不用，被dbtimepercall列替換;
----每個使用者呼叫花費的時間
CPUPERCALL NUMBER CPU time per call (in microseconds)---每個呼叫花費的cpu time
DBTIMEPERCALL NUMBER Elapsed time per call (in microseconds)---每個呼叫花費的時間(花費時間>cpu time)
CALLSPERSEC NUMBER Number of user calls per second ---每秒內發生多少次使用者呼叫
DBTIMEPERSEC NUMBER DB time per second ---每秒產生的db time 是多少
---友好度，從字面可以這樣譯；這個值越低越好；oracle根據goal(long及short，請參考dbms_service章節）的不同值，對不同的service，從內部計算它的值。通俗來講，就是不同的服務在處理工作負荷時，對於各個rac例項的吸引力;我也沒有測試，理解不深
GOODNESS NUMBER Indicates how attractive a given instance is with respect to processing the workload that is presented to the service. A lower number is better.
This number is internally computed based on the GOAL (LONG or SHORT) that is specified for the particular service.
---這個值表明，每個新增的會話接入到某個rac實含例的可以預側到的增長數
DELTA NUMBER Indicates the predicted increase in the goodness for every additional session that is routed to this instance
---是個列表型別的列
FLAGS NUMBER Can be any of the following values:
*
0x01 - service is BLOCKED from accepting new connections ---服務接受新的連線時，可能正處於阻塞
*
0x02 - service is VIOLATING the set threshold on some metric ---服務違反某些度量上面的閥值
*
0x04 - goodness is UNKNOWN ---服務目前的狀態為未知
---以下含義與以上差不多，區別在於取樣是最近一段時間的，記錄數更多，便於分析service的執行趨勢
V$SERVICEMETRIC_HISTORY
V$SERVICEMETRIC_HISTORY displays a recent history of the metric values measured in predefined time interval periods for services executing inside the database. Service metrics are measured in 5-second and 1-minute intervals.
Column Datatype Description
BEGIN_TIME DATE Begin timestamp for the interval period
END_TIME DATE End timestamp for the interval period
INTSIZE_CSEC NUMBER Interval size (in hundredths of a second)
GROUP_ID NUMBER Group ID for the service metric group
SERVICE_NAME_HASH NUMBER Service name hash
SERVICE_NAME VARCHAR2(64) Service name
CTMHASH NUMBER Service create timestamp hash value
ELAPSEDPERCALL NUMBER Elapsed time per call (in microseconds). This column is deprecated in favor of the DBTIMEPERCALL column.
CPUPERCALL NUMBER CPU time per call (in microseconds)
DBTIMEPERCALL NUMBER Elapsed time per call (in microseconds)
CALLSPERSEC NUMBER Number of user calls per second
DBTIMEPERSEC NUMBER DB time per second
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/9240380/viewspace-659620/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- iOS學習筆記04 檢視切換iOS筆記
- 檢視提交歷史 —— Git 學習筆記 11Git筆記
- Echarts檢視視覺化-學習筆記(努力更新中)Echarts視覺化筆記
- jQuery 學習系列筆記jQuery筆記
- Adaptive AUTOSAR 學習筆記 5 - 架構 - 物理檢視APT筆記架構
- Solidity語言學習筆記————27、檢視函式Solid筆記函式
- Adaptive AUTOSAR 學習筆記 4 - 架構 - 邏輯檢視APT筆記架構
- Java學習筆記系列-反射Java筆記反射
- “平板電視”學習筆記筆記
- 架構學習筆記系列三架構筆記
- 架構學習筆記系列二架構筆記
- 架構學習筆記系列一架構筆記
- MySQL筆記 13 檢視MySql筆記
- OpenCV學習筆記-Harris角點檢測OpenCV筆記
- C++學習筆記-Cherno C++系列C++筆記
- SpringBoot系列之YAML配置用法學習筆記Spring BootYAML筆記
- oracle學習筆記（十四） 資料庫物件 索引 檢視 序列 同義詞Oracle筆記資料庫物件索引
- ASP.Net MVC開發基礎學習筆記（10）：分部檢視PartialViewASP.NETMVC筆記View
- AI學習筆記（十二）物體檢測（上）AI筆記
- 【筆記】黃如花.資訊檢索.學習心得筆記
- numpy的學習筆記\pandas學習筆記筆記
- Vue學習筆記（六）：監視屬性Vue筆記
- JVM狂神說視訊學習筆記JVM筆記
- 學習C過程中的筆記系列-2筆記
- 學習筆記（11）商品上架與ES檢索筆記
- 學習筆記筆記
- MySQL之檢視學習MySql
- PySimpleGUI 學習筆記（純新手記錄，大神請忽視）GUI筆記
- 安卓學習筆記31：使用自定義檢視繪製文字、圖形與影像安卓筆記
- Git 中的物件模型和檔案的詳細檢視 —— Git 學習筆記 13Git物件模型筆記
- PHP從零開始系列二（學習筆記）：序言PHP筆記
- PHP從零開始系列一（學習筆記）：前言PHP筆記
- 我的 golang 學習筆記系列四：反射初識Golang筆記反射
- PHP學習筆記系列：PHP生成器概覽PHP筆記
- laracast 視訊教程系列筆記更新AST筆記
- odoo檢視入門學習- tree檢視的使用Odoo
- 【學習筆記】數學筆記
- Django學習筆記（13）——Django的使用者認證元件，檢視層和QuerySet APIDjango筆記元件API
- 機器學習學習筆記機器學習筆記