Da traduttori professionisti, imprese, pagine web e archivi di traduzione disponibili gratuitamente al pubblico.
-- create table bp_snap ( snapshot_timestamp timestamp, pool_data_l_reads bigint, pool_data_p_reads bigint, pool_data_writes bigint, pool_index_l_reads bigint, pool_index_p_reads bigint, pool_index_writes bigint, pool_read_time bigint, pool_write_time bigint, pool_async_data_rd bigint, pool_async_dt_wrt bigint, pool_async_ix_wrt bigint, pool_async_read_tm bigint, pool_async_wr_time bigint, pool_async_dt_rdrq bigint, direct_reads bigint, direct_writes bigint, direct_read_reqs bigint, direct_write_reqs bigint, direct_read_time bigint, direct_write_time bigint, pool_async_ix_rds bigint, pool_data_testore bigint, pool_index_testore bigint, pool_index_festore bigint, pool_data_festore bigint, unread_pref_pgs bigint, files_closed bigint, bp_name char(18), db_name char(8), db_path varchar(255), input_db_alias char(8) ) in userspace1; -- upq020 create a table to store buffer pool snapshots -- the snapshot is stored into this table using ups021 -- -- upq022 and following will contain sql to report from -- these tables. -- create table bp_snap ( snapshot_timestamp timestamp, pool_data_l_reads bigint, pool_data_p_reads bigint, pool_data_writes bigint, pool_index_l_reads bigint, pool_index_p_reads bigint, pool_index_writes bigint, pool_read_time bigint, pool_write_time bigint, pool_async_data_rd bigint, pool_async_dt_wrt bigint, pool_async_ix_wrt bigint, pool_async_read_tm bigint, pool_async_wr_time bigint, pool_async_dt_rdrq bigint, direct_reads bigint, direct_writes bigint, direct_read_reqs bigint, direct_write_reqs bigint, direct_read_time bigint, direct_write_time bigint, pool_async_ix_rds bigint, pool_data_testore bigint, pool_index_testore bigint, pool_index_festore bigint, pool_data_festore bigint, unread_pref_pgs bigint, files_closed bigint, bp_name char(18), db_name char(8), db_path varchar(255), input_db_alias char(8) ) in userspace1;
-- -- upq022 и следующие сценарии буду содержать sql-запросы -- для отчетов по этим таблицам. -- create table bp_snap ( snapshot_timestamp timestamp, pool_data_l_reads bigint, pool_data_p_reads bigint, pool_data_writes bigint, pool_index_l_reads bigint, pool_index_p_reads bigint, pool_index_writes bigint, pool_read_time bigint, pool_write_time bigint, pool_async_data_rd bigint, pool_async_dt_wrt bigint, pool_async_ix_wrt bigint, pool_async_read_tm bigint, pool_async_wr_time bigint, pool_async_dt_rdrq bigint, direct_reads bigint, direct_writes bigint, direct_read_reqs bigint, direct_write_reqs bigint, direct_read_time bigint, direct_write_time bigint, pool_async_ix_rds bigint, pool_data_testore bigint, pool_index_testore bigint, pool_index_festore bigint, pool_data_festore bigint, unread_pref_pgs bigint, files_closed bigint, bp_name char(18), db_name char(8), db_path varchar(255), input_db_alias char(8) ) in userspace1; -- upq020 Создать таблицу для хранения снимков текущего состояния буферного пула. -- Снимки записываются в эту таблицу при помощи ups021. -- -- upq022 и следующие сценарии буду содержать sql-запросы -- для отчетов по этим таблицам. -- create table bp_snap ( snapshot_timestamp timestamp, pool_data_l_reads bigint, pool_data_p_reads bigint, pool_data_writes bigint, pool_index_l_reads bigint, pool_index_p_reads bigint, pool_index_writes bigint, pool_read_time bigint, pool_write_time bigint, pool_async_data_rd bigint, pool_async_dt_wrt bigint, pool_async_ix_wrt bigint, pool_async_read_tm bigint, pool_async_wr_time bigint, pool_async_dt_rdrq bigint, direct_reads bigint, direct_writes bigint, direct_read_reqs bigint, direct_write_reqs bigint, direct_read_time bigint, direct_write_time bigint, pool_async_ix_rds bigint, pool_data_testore bigint, pool_index_testore bigint, pool_index_festore bigint, pool_data_festore bigint, unread_pref_pgs bigint, files_closed bigint, bp_name char(18), db_name char(8), db_path varchar(255), input_db_alias char(8) ) in userspace1;
