首页    技术博客    PHP教程    数据库技术    前端开发   HTML5    Nginx    php论坛
新用户注册 | 会员登录
加入会员，解锁专属内容
取消
热门标签 | HotTags
当前位置:  开发笔记 > 数据库 > 正文

OracleLogminer使用

作者：黑夜乱来 | 来源：互联网 | 2018-06-09 22:48
--创建测试数据C:setNLS_LANGSIMPLIFIEDCHINESE_CHINA.ZHS16GBKC:sqlplusassysdbaSQL*Plus:Release10.2.0.4.0

--创建测试数据 C:set NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK C:sqlplus / as sysdba SQL*Plus: Release 10.2.0.4.0 - Production on 星期三 3月 12 22:10:38 2014 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. 连接到: Oracle Database 1

　　--创建测试数据

　　C:>set NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK

　　C:>sqlplus / as sysdba

　　SQL*Plus: Release 10.2.0.4.0 - Production on 星期三 3月 12 22:10:38 2014

　　Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

　　连接到:

　　Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

　　With the Partitioning, OLAP, Data Mining and Real Application Testing options

　　SQL> create tablespace zwc datafile 'C:oraclezwc01.dbf' size 500m;

　　表空间已创建。

　　SQL> create user zwc identified by zwc;

　　用户已创建。

　　SQL> grant resource,connect to zwc;

　　授权成功。

　　SQL> conn zwc

　　输入口令:

　　已连接。

　　SQL> create table zwc.tab01(a int primary key,b varchar2(100),c varchar2(100),d date default sysdate) tablespace zwc;

　　表已创建。

　　SQL> create or replace procedure p_inst_tab01 as

　　2 begin

　　3 for i in 1..2000000 loop

　　4 insert into tab01(a,b,c,d) values(i,i,i,sysdate);

　　5 if mod(i,2000)=0 then

　　6 commit;

　　7 end if;

　　8 end loop;

　　9 end p_inst_tab01;

　　10 /

　　过程已创建。

　　SQL> show user

　　USER 为 "ZWC"

　　SQL> exec p_inst_tab01;

　　PL/SQL 过程已成功完成。

　　SQL> select count(*) from tab01;

　　COUNT(*)

　　----------

　　2000000

　　SQL> select sum(bytes)/1024/1024 "size MB" from user_segments where segment_name='TAB01';

　　size MB

　　----------

　　80

　　--删除、更新数据

　　SQL> show user

　　USER 为 "SYS"

　　SQL> alter database add supplemental log data;

　　数据库已更改。

　　SQL> delete from zwc.tab01 where rownum<=100;

　　已删除100行。

　　SQL> update zwc.tab01 set d=sysdate-100 where rownum<=10;

　　已更新10行。

　　SQL> commit;

　　提交完成。

　　--使用logminer找回数据

　　SQL> alter system set utl_file_dir='c:oracle' scope=spfile;

　　系统已更改。

　　SQL> alter session set nls_date_format ='yyyy-mm-dd hh24:mi:ss';

　　会话已更改。

　　SQL> shutdown immediate

　　数据库已经关闭。

　　已经卸载数据库。

　　ORACLE 例程已经关闭。

　　SQL> startup

　　ORACLE 例程已经启动。

　　Total System Global Area 612368384 bytes

　　Fixed Size 2067656 bytes

　　Variable Size 167772984 bytes

　　Database Buffers 436207616 bytes

　　Redo Buffers 6320128 bytes

　　数据库装载完毕。

　　数据库已经打开。

　　SQL> execute dbms_logmnr_d.build(dictionary_filename=>'test.ora',dictionary_location=>'c:oracle');

　　PL/SQL 过程已成功完成。

　　--select group#,status from v$log;

　　--select group#,member from v$logfile;

　　SQL> execute dbms_logmnr.add_logfile(logfilename=>'C:archARC00041_0842045960.001',optiOns=>dbms_logmnr.new);

　　PL/SQL 过程已成功完成。

　　SQL> execute dbms_logmnr.start_logmnr(dictFilename=>'c:oracletest.ora');

　　PL/SQL 过程已成功完成。

　　SQL> create table zwc.t_logminer tablespace zwc as select * from v_$logmnr_contents;

　　表已创建。

　　SQL> select count(*) from zwc.t_logminer;

　　COUNT(*)

　　----------

　　212

　　SQL> execute dbms_logmnr.end_logmnr;

　　PL/SQL 过程已成功完成。

　　SQL> select count(*) from zwc.t_logminer where seg_name='TAB01' and seg_owner='ZWC';

　　COUNT(*)

　　----------

　　110

　　--需要恢复数据查询SQL_UNDO，执行误删除的是SQL_REDO，OPERATION是操作类型

　　[oracle@db10 ~]$ sqlplus zwc/zwc@192.168.1.10:1521/prod

　　SQL*Plus: Release 10.2.0.5.0 - Production on Wed Mar 12 23:10:15 2014

　　Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

　　Connected to:

　　Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

　　With the Partitioning, OLAP, Data Mining and Real Application Testing options

　　SQL> set lines 150 pages 200

　　SQL> select SQL_UNDO from t_logminer where seg_name='TAB01' and seg_owner='ZWC' and OPERATION='DELETE';

　　SQL_UNDO

　　------------------------------------------------------------------------------------------------------------------------------------------------------

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('201','201','201',TO_DATE('02-12月-13', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('202','202','202',TO_DATE('02-12月-13', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('203','203','203',TO_DATE('02-12月-13', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('204','204','204',TO_DATE('02-12月-13', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('205','205','205',TO_DATE('02-12月-13', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('206','206','206',TO_DATE('02-12月-13', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('207','207','207',TO_DATE('02-12月-13', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('208','208','208',TO_DATE('02-12月-13', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('209','209','209',TO_DATE('02-12月-13', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('210','210','210',TO_DATE('02-12月-13', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('211','211','211',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('212','212','212',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('213','213','213',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('214','214','214',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('215','215','215',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('216','216','216',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('217','217','217',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('218','218','218',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('219','219','219',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('220','220','220',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('221','221','221',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('222','222','222',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('223','223','223',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('224','224','224',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('225','225','225',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('226','226','226',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('227','227','227',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('228','228','228',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('229','229','229',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('230','230','230',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('231','231','231',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('232','232','232',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('233','233','233',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('234','234','234',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('235','235','235',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('236','236','236',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('237','237','237',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('238','238','238',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('239','239','239',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('240','240','240',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('241','241','241',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('242','242','242',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('243','243','243',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('244','244','244',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('245','245','245',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('246','246','246',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('247','247','247',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('248','248','248',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('249','249','249',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('250','250','250',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('251','251','251',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('252','252','252',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('253','253','253',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('254','254','254',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('255','255','255',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('256','256','256',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('257','257','257',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('258','258','258',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('259','259','259',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('260','260','260',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('261','261','261',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('262','262','262',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('263','263','263',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('264','264','264',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('265','265','265',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('266','266','266',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('267','267','267',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('268','268','268',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('269','269','269',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('270','270','270',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('271','271','271',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('272','272','272',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('273','273','273',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('274','274','274',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('275','275','275',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('276','276','276',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('277','277','277',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('278','278','278',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('279','279','279',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('280','280','280',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('281','281','281',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('282','282','282',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('283','283','283',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('284','284','284',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('285','285','285',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('286','286','286',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('287','287','287',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('288','288','288',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('289','289','289',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('290','290','290',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('291','291','291',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('292','292','292',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('293','293','293',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('294','294','294',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('295','295','295',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('296','296','296',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('297','297','297',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('298','298','298',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('299','299','299',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　insert into "ZWC"."TAB01"("A","B","C","D") values ('300','300','300',TO_DATE('12-3月 -14', 'DD-MON-RR'));

　　100 rows selected.

　　SQL> select SQL_UNDO from t_logminer where seg_name='TAB01' and seg_owner='ZWC' and OPERATION='UPDATE';

　　SQL_UNDO

　　------------------------------------------------------------------------------------------------------------------------------------------------------

　　update "ZWC"."TAB01" set "D" = TO_DATE('12-3月 -14', 'DD-MON-RR') where "D" = TO_DATE('02-12月-13', 'DD-MON-RR') and ROWID = 'AAAM7rAAGAAAAAMAEs';

　　update "ZWC"."TAB01" set "D" = TO_DATE('12-3月 -14', 'DD-MON-RR') where "D" = TO_DATE('02-12月-13', 'DD-MON-RR') and ROWID = 'AAAM7rAAGAAAAAMAEt';

　　update "ZWC"."TAB01" set "D" = TO_DATE('12-3月 -14', 'DD-MON-RR') where "D" = TO_DATE('02-12月-13', 'DD-MON-RR') and ROWID = 'AAAM7rAAGAAAAAMAEu';

　　update "ZWC"."TAB01" set "D" = TO_DATE('12-3月 -14', 'DD-MON-RR') where "D" = TO_DATE('02-12月-13', 'DD-MON-RR') and ROWID = 'AAAM7rAAGAAAAANAAA';

　　update "ZWC"."TAB01" set "D" = TO_DATE('12-3月 -14', 'DD-MON-RR') where "D" = TO_DATE('02-12月-13', 'DD-MON-RR') and ROWID = 'AAAM7rAAGAAAAANAAB';

　　update "ZWC"."TAB01" set "D" = TO_DATE('12-3月 -14', 'DD-MON-RR') where "D" = TO_DATE('02-12月-13', 'DD-MON-RR') and ROWID = 'AAAM7rAAGAAAAANAAC';

　　update "ZWC"."TAB01" set "D" = TO_DATE('12-3月 -14', 'DD-MON-RR') where "D" = TO_DATE('02-12月-13', 'DD-MON-RR') and ROWID = 'AAAM7rAAGAAAAANAAD';

　　update "ZWC"."TAB01" set "D" = TO_DATE('12-3月 -14', 'DD-MON-RR') where "D" = TO_DATE('02-12月-13', 'DD-MON-RR') and ROWID = 'AAAM7rAAGAAAAANAAE';

　　update "ZWC"."TAB01" set "D" = TO_DATE('12-3月 -14', 'DD-MON-RR') where "D" = TO_DATE('02-12月-13', 'DD-MON-RR') and ROWID = 'AAAM7rAAGAAAAANAAF';

　　update "ZWC"."TAB01" set "D" = TO_DATE('12-3月 -14', 'DD-MON-RR') where "D" = TO_DATE('02-12月-13', 'DD-MON-RR') and ROWID = 'AAAM7rAAGAAAAANAAG';

　　10 rows selected.

，
推荐阅读
  • sql

    SQL查询分组后每组行数的统计方法

    本文介绍了在SQL中查询分组后每组行数的统计方法。通过使用count()函数和GROUP BY子句可以统计每组的行数，但是如何统计所有组的行数呢？本文提供了一种实现方法，并给出了相应的SQL查询语句。 ... [详细]
  • sql

    基于PgpoolII的PostgreSQL集群安装与配置教程

    基于PgpoolII的PostgreSQL集群安装与配置教程
    本文介绍了基于PgpoolII的PostgreSQL集群的安装与配置教程。Pgpool-II是一个位于PostgreSQL服务器和PostgreSQL数据库客户端之间的中间件，提供了连接池、复制、负载均衡、缓存、看门狗、限制链接等功能，可以用于搭建高可用的PostgreSQL集群。文章详细介绍了通过yum安装Pgpool-II的步骤，并提供了相关的官方参考地址。 ... [详细]
  • sql

    如何限制php数据库链接数和连接超时时间？

    本文介绍了如何使用php限制数据库插入的条数并显示每次插入数据库之间的数据数目，以及避免重复提交的方法。同时还介绍了如何限制某一个数据库用户的并发连接数，以及设置数据库的连接数和连接超时时间的方法。最后提供了一些关于浏览器在线用户数和数据库连接数量比例的参考值。 ... [详细]
  • sql

    Oracle Database 10g许可授予信息及高级功能详解

    Oracle Database 10g许可授予信息及高级功能详解
    本文介绍了Oracle Database 10g许可授予信息及其中的高级功能，包括数据库优化数据包、SQL访问指导、SQL优化指导、SQL优化集和重组对象。同时提供了详细说明，指导用户在Oracle Database 10g中如何使用这些功能。 ... [详细]
  • sql

    adg架构设置及其在企业数据治理中的应用

    本文介绍了adg架构设置在企业数据治理中的应用。随着信息技术的发展，企业IT系统的快速发展使得数据成为企业业务增长的新动力，但同时也带来了数据冗余、数据难发现、效率低下、资源消耗等问题。本文讨论了企业面临的几类尖锐问题，并提出了解决方案，包括确保库表结构与系统测试版本一致、避免数据冗余、快速定位问题等。此外，本文还探讨了adg架构在大版本升级、上云服务和微服务治理方面的应用。通过本文的介绍，读者可以了解到adg架构设置的重要性及其在企业数据治理中的应用。 ... [详细]
  • sql

    Hibernate基础映射

    在说Hibernate映射前，我们先来了解下对象关系映射ORM。ORM的实现思想就是将关系数据库中表的数据映射成对象，以对象的形式展现。这样开发人员就可以把对数据库的操作转化为对 ... [详细]
  • sql

    postman测试登录后的接口_使用postman进行接口测试的方法(测试用户管理模块)

    本文介绍了使用postman进行接口测试的方法，以测试用户管理模块为例。首先需要下载并安装postman，然后创建基本的请求并填写用户名密码进行登录测试。接下来可以进行用户查询和新增的测试。在新增时，可以进行异常测试，包括用户名超长和输入特殊字符的情况。通过测试发现后台没有对参数长度和特殊字符进行检查和过滤。 ... [详细]
  • sql

    MysqlDump_mysqldump全库备份相关知识详解

    本文详细介绍了MysqlDump和mysqldump进行全库备份的相关知识，包括备份命令的使用方法、my.cnf配置文件的设置、binlog日志的位置指定、增量恢复的方式以及适用于innodb引擎和myisam引擎的备份方法。对于需要进行数据库备份的用户来说，本文提供了一些有价值的参考内容。 ... [详细]
  • sql

    使用 Ubuntu 中的 Python 获取浏览器历史记录

    使用Ubuntu中的Python获取浏览器历史记录原文: ... [详细]
  • sql

    PHP中的MySQL函数库及其常用函数介绍

    本文由编程笔记小编整理，介绍了PHP中的MySQL函数库及其常用函数，包括mysql_connect、mysql_error、mysql_select_db、mysql_query、mysql_affected_row、mysql_close等。希望对读者有一定的参考价值。 ... [详细]
  • sql

    Oracle中tnsnames.ora的作用和配置方法

    本文介绍了Oracle数据库中tnsnames.ora文件的作用和配置方法。tnsnames.ora文件在数据库启动过程中会被读取，用于解析LOCAL_LISTENER，并且与侦听无关。文章还提供了配置LOCAL_LISTENER和1522端口的示例，并展示了listener.ora文件的内容。 ... [详细]
  • sql

    Spring特性实现接口多类的动态调用详解

    Spring特性实现接口多类的动态调用详解
    本文详细介绍了如何使用Spring特性实现接口多类的动态调用。通过对Spring IoC容器的基础类BeanFactory和ApplicationContext的介绍，以及getBeansOfType方法的应用，解决了在实际工作中遇到的接口及多个实现类的问题。同时，文章还提到了SPI使用的不便之处，并介绍了借助ApplicationContext实现需求的方法。阅读本文，你将了解到Spring特性的实现原理和实际应用方式。 ... [详细]
  • sql

    Java String与StringBuffer的区别及其应用场景

    Java String与StringBuffer的区别及其应用场景
    本文主要介绍了Java中String和StringBuffer的区别，String是不可变的，而StringBuffer是可变的。StringBuffer在进行字符串处理时不生成新的对象，内存使用上要优于String类。因此，在需要频繁对字符串进行修改的情况下，使用StringBuffer更加适合。同时，文章还介绍了String和StringBuffer的应用场景。 ... [详细]
  • sql

    Oracle分析函数first_value()和last_value()的用法及原理

    Oracle分析函数first_value()和last_value()的用法及原理
    本文介绍了Oracle分析函数first_value()和last_value()的用法和原理，以及在查询销售记录日期和部门中的应用。通过示例和解释，详细说明了first_value()和last_value()的功能和不同之处。同时，对于last_value()的结果出现不一样的情况进行了解释，并提供了理解last_value()默认统计范围的方法。该文对于使用Oracle分析函数的开发人员和数据库管理员具有参考价值。 ... [详细]
  • sql

    MyBatis错题分析解析及注意事项

    MyBatis错题分析解析及注意事项
    本文对MyBatis的错题进行了分析和解析，同时介绍了使用MyBatis时需要注意的一些事项，如resultMap的使用、SqlSession和SqlSessionFactory的获取方式、动态SQL中的else元素和when元素的使用、resource属性和url属性的配置方式、typeAliases的使用方法等。同时还指出了在属性名与查询字段名不一致时需要使用resultMap进行结果映射，而不能使用resultType。 ... [详细]
author-avatar
黑夜乱来
这个家伙很懒，什么也没留下！
Tags | 热门标签
RankList | 热门文章
PHP1.CN | 中国最专业的PHP中文社区 | DevBox开发工具箱 | json解析格式化 |PHP资讯 | PHP教程 | 数据库技术 | 服务器技术 | 前端开发技术 | PHP框架 | 开发工具 | 在线工具
Copyright © 1998 - 2020 PHP1.CN. All Rights Reserved | 京公网安备 11010802041100号 | 京ICP备19059560号-4 | PHP1.CN 第一PHP社区 版权所有