01 2022 档案

Oracle 状态及连接信息SQL
摘要：根据当前pid线程查询对应执行的sql语句 SELECT sql_text FROM v$sqltext a WHERE (a.hash_value, a.address) IN (SELECT DECODE(sql_hash_value, 0, prev_hash_value, sql_hash_ 阅读全文
posted @ 2022-01-19 09:23 好久.不见 阅读(124) 评论(0) 推荐(0)
oracle数据库 dblink互相连接
摘要：一、oracle数据库连接oracle CREATE DATABASE LINK "linkname" CONNECT TO "username" IDENTIFIED BY "password" USING '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (P 阅读全文
posted @ 2022-01-11 14:44 好久.不见 阅读(206) 评论(0) 推荐(0)