【SQL开源代码栏目提醒】:网学会员SQL开源代码为您提供27.5.3.5.sql参考,解决您在27.5.3.5.sql学习中工作中的难题,参考学习。
--传输SQL TUNING SET
--1.
BEGIN
DBMS_SQLTUNE.CREATE_STGTAB_SQLSET(
table_name => 'mytable',
SCHEMA_NAME => 'SCOTT');
END;
/
--2.
BEGIN
DBMS_SQLTUNE.PACK_STGTAB_SQLSET(
sqlset_name => 'MY_SQL_TUNING_SET',
SQLSET_OWNER => 'SCOTT',
staging_table_name => 'staging_table',
STAGING_SCHEMA_OWNER => 'scott');
END;
/
--3.
create public database link oral
connect to system identified by system
using 'orcl'
--4.
BEGIN
DBMS_SQLTUNE.UNPACK_STGTAB_SQLSET(
sqlset_name => '%',
SQLSET_OWNER => 'SCOTT',
replace => TRUE,
staging_table_name => 'staging_table',
STAGING_SCHEMA_OWNER => 'SCOTT');
END;
/