-
编辑 删除
oracle database link 使用简介
因项目需要，将A库上的hr schema复制到B库下hr scheme，使用oracle database link 能简单，快速处理。A库，ip是192.168.201.148， 库名和服务名都是orcl9i, tnsnames.ora的连接名也是orcl9iB库上，修改tnsnames.ora, 加入以下连接orcl9i = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST ...
-
编辑 删除
log
insert into MYCAR.CNT_SYN_UPDATE_INFO (NAME,SYN_ID,FSTR_USER,ID,CONTENT,OA_AUDIT_NO,LAST_UPDATE_DATE,LAN_ID)values('PEUGEOT Diagnostic Software for X-431 Series V42.56','96003','??','351','Compared...
-
编辑 删除
werdgdsds
Using the report name /tmp/awrrpt_1_10059_10061.html<html><head><title>AWR Report for DB: MYCAR, Inst: mycar, Snaps: 10059-10061</title><style. type="text/css">body.awr {font:bold 10pt Arial,Helvetica...
-
编辑 删除
wedssd
-- 2013-07-15 --SELECT COUNT(*) AS c from (select max(version_no) version_no, soft_id &...
-
编辑 删除
rere
<html><head><title>AWR Report for DB: MYCAR, Inst: mycar, Snaps: 9905-9906</title><style. type="text/css">body.awr {font:bold 10pt Arial,Helvetica,Geneva,sans-serif;color:black; background:White;}pre....
-
编辑 删除
ww
SQL> /Execution Plan----------------------------------------------------------Plan hash value: 3647926450------------------------------------------------------------------------------------------| Id&...
-
编辑 删除
awrrpt_1_9716_9717.html
<html><head><title>AWR Report for DB: MYCAR, Inst: mycar, Snaps: 9716-9717</title><style. type="text/css">body.awr {font:bold 10pt Arial,Helvetica,Geneva,sans-serif;color:black; background:White;}pre....
-
编辑 删除
asdsn1yqzjk0r
----------------------------------------------------------------------------------------------select r.DOWNLOAD_ID, r.VERSION_ID,  ...
-
编辑 删除
tunning_sql1
SQL> desc df_data_stream_desc Name &...
-
编辑 删除
awrrpt_1_9670_9671.txt
WORKLOAD REPOSITORY report forDB Name DB Id Instance Inst Num Startup Time Release RAC---...
-
编辑 删除
ADDSOFTCONFREFSOFT
CREATE OR REPLACE PROCEDURE "MYCAR"."ADDSOFTCONFREFSOFT"(v_soft_id IN diag_soft.soft_id%TYPE,v_free_time IN diag_soft.free_time%TYPE, v_soft_conf_id IN sys_soft_conf.soft_conf_id%TYPE)is cursor c...
-
编辑 删除
awrrpt_1_9474_9475.txt
WORKLOAD REPOSITORY report forDB Name DB Id Instance Inst Num Startup Time Release &nbs...
-
编辑 删除
确定引起最多等待的SQL语句
SYS@orcl> l 1 select ash.user_id, 2 u.username, 3 s.sql_text, 4 sum(ash.wait_time + ash.time_waited) ttl_wait_time 5 from v$active_s...
-
编辑 删除
shared_pool的字典缓存命中率
SYS@orcl> edWrote file afiedt.buf 1 select parameter, 2 sum(gets), 3 sum(getmisses), 4 100*sum(gets-getmisses)/sum(gets) pct_s...
-
编辑 删除
awrrpt_1_9225_9226.html
<html><head><title>AWR Report for DB: MYCAR, Inst: mycar, Snaps: 9225-9226</title><style. type="text/css">body.awr {font:bold 10pt Arial,Helvetica,Geneva,sans-serif;color:black; background:White;}pre....
-
编辑 删除
awrrpt_1_9345_9346
WORKLOAD REPOSITORY report forDB Name DB Id Instance Inst Num Startup Time Release &nbs...
-
编辑 删除
你的数据库中有等待问题么？
要找出数据库花费在等待资源而不是实际执行上的时间百分比很简单。执行以下查询找出一个数据库中等待时间和实际执行时间的相对百分比：SYS@orcl> edWrote file afiedt.buf 1 select metric_name...
-
编辑 删除
网上书店数据库脚本文件
REM --Oracle 网上书店数据库脚本文件 (订货单indent)/* ** Author:lzb ** Create Time:2005-02-05*/--------------------------------------------------管理员表drop table My_Book...
