軟件測試第九講數(shù)據(jù)庫測試-資料下載頁
2024-10-17 01:30本頁面
【正文】 tall package ? Connect as sysdba ? Run @?/rdbms/admin/spcreate sql, to create all required tables, packages, user and grant privilege. ? Specify 3 required parameters: user password, tablespace and temp tablespace, it is better to create independent tablespace and temp tablespace for this schema. 2. Using statspack ? connect as perfstats. ? EXECUTE 。 (after this process finished, we can see a set of data had been generated to perfstats. STATS$SYSSTAT, by SNAP_IDm this means, system snapshot had been generated by executing this package. ? An integer snap_id will be returned, we can get it by SMART calling, or from latest SNAP_ID from table STATS$SYSSTAT. 3. Running the Statspack Report ? connect as perfstats. ? Execute sql: @?/rdbms/admin/spreport ? Specify 3 parameters: start snapshot ID, end snapshot ID and report name (default is in current path). Or batch define and run by define begine_snap, end_snap, report_name before run sql. 數(shù)據(jù)庫并發(fā)控制測試 ? 數(shù)據(jù)庫并發(fā)能力 : 多個應(yīng)用請求的并發(fā)處理過程 . ? 并發(fā)主要考慮的幾個方面 : ? 數(shù)據(jù)丟失 ? 不可重復(fù)數(shù)據(jù) ? 讀臟數(shù)據(jù) ? 數(shù)據(jù)庫的鎖 ? 并發(fā)測試的設(shè)計過程 ? 并發(fā)流程分析 ? 并發(fā)控制測試設(shè)計
教學課件相關(guān)推薦
鄂ICP備17016276號-1