alter system set open_links=0 sid ='*' scope=spfile;
System altered.
alter system set open_links_per_instance=0 sid ='*' scope=spfile;
System altered.
重启数据库
SELECT id FROM tb@db_link where rownum<=10
*
ERROR at line 1:
ORA-02020: too many database links in use
System altered.
alter system set open_links_per_instance=0 sid ='*' scope=spfile;
System altered.
重启数据库
SELECT id FROM tb@db_link where rownum<=10
*
ERROR at line 1:
ORA-02020: too many database links in use