2019年06月_回到未来望过去

12月 11月 10月 09月 08月 07月 06月 05月 04月 03月 02月

原创【ae】蒙版、蒙版动画

双击可恢复形状的默认值按住空格移动蒙版，上下键调节圆角，五角星的角数目，左右切换形状m快捷键mm蒙版所有属性双击蒙版可以对蒙版自由变换选图层移动和选蒙版移动不一样文字填充后的蒙版形状变换形成动画黑边反转后调节羽化效果，四角变化...

2019-06-28 20:30:33 1483

原创【dg】配置 dg_broker 开启failover

1、修改保护模式DGMGRL> edit configuration set protection mode as maxAvailability; Succeeded.2、修改日志同步方式DGMGRL> show database verbose orcl 'LogXptMode' LogXptMode = 'ASYNC' DGMGRL> show da...

2019-06-28 10:39:03 445

原创【dg】配置 dg_broker遇到的错误记录

1、监听改了起不来最开始报错的版本SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = orcl) (GLOBAL_DBNAME= ora10g_DGMGRL.localdomain) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1) ...

2019-06-28 08:40:24 1099

原创【dg】配置 dg_broker（切换方便的很，但是感觉没啥实际价值，谁会把生产库往备库上没事切啊，切了连接池还得改）

实验环境以前做过一次切换主从，目前机器环境如下primary：192.168.110.61 sid：orcl db_unique_name:ora10gstandby：192.168.110.60 sid：orcl db_unique_name:orcloracle11.2.0.11、配置listener.ora文件和tnsnames.ora文件，...

2019-06-28 08:40:20 637

转载【OCP学习1z0-053记录61】 replay parameters（CONNECT_TIME_SCALE 、THINK_TIME_SCALE ）

280.ViewtheExhibittoexaminethereplaysettingsforreplayparameters.Whatistheimplicationforsettingthevaluesforreplayparameters?(Chooseallthatapply.)A.TheCOMMITorderinthec...

2019-06-28 08:40:16 235

转载【dg】rman的dg相关设置，

10g之后的版本，Oracle在RMAN中内置增加了一项归档文件的删除策略，终于，DBA可以仅通过一项配置就解决该问题了。该策略对应两个值：APPLIED ON STANDBY：设置为该值时，当通过附加的DELETE INPUT子句删除Standby数据库仍需要的日志时，会提示RMAN-08137错误。不过用户仍然可以手动地通过DELETE ARCHIVELOG方式删除。NONE：...

2019-06-28 08:40:12 240

转载【dg】保护模式

对于主库会有以下三种不同的保护模式：• 最大可用事务在主库只有当online redo log已经传到备库才会提交，如果备库不可用，转为最大性能模式• 最大性能主库生成的redo信息会尽快写到online redo 日志里，到备库的传输是异步传输• 最大保护log已经传到备库才会提交，才能进行下一事务操作；如果备库不可用，主库会关机查...

2019-06-28 08:40:08 197

转载【dg】出现GAP后的修复方式（基于SCN号的增量补偿）

手动解决日志缺失在standby库中使用以下查询语句确定缺失问题SQL> select * from v$archive_gap;THREAD#,LOW_SEQUENCE# HIGH_SEQUENCE#--------------------------------------------------------------------------------1 ...

2019-06-27 08:42:31 478

转载【dg】MAXIMUM AVAILABILITY升级到MAXIMUM PROTECTION的方法

MAXIMUM AVAILABILITY升级到MAXIMUM PROTECTION的方法1.主库关闭启动到mount状态2.主库执行alter database set standby database to maximize protection;3.主库执行Alter database open...

2019-06-27 08:40:47 234

转载【dg】MAXIMUM PERFORMANCE升级到MAXIMUM PROTECTION的方法

MAXIMUM PERFORMANCE升级到MAXIMUM PROTECTION的方法1.主库修改参数为(如果之前是MAXIMUM AVAILABILITY或之前就是如下则不用修改了)lgwr sync affirm valid_for=(online_logfiles,primary_role)2.主库关闭并启动到mount状态3.主库执行alter databa...

2019-06-27 08:40:40 741

原创【dg】lgwr sync最大性能到最大可用的切换脚本、测试日志记录

一、切换脚本1：主库执行alter database set standby database to maximize availability; //之后备库应用完归档日志后也自动变成maximize availability，主库宕机后备库还是maximize availability状态2：主库执行shutdown immediate并startup3：备库执行alter d...

2019-06-27 08:40:35 373

原创【dg】dg应用standby redo log的几种命令方式

开始应用standbyredolog在备库上操作，主要使用第二个命令#Foregroundredoapply.Sessionneverreturnsuntilcancel.SQL>ALTERDATABASERECOVERMANAGEDSTANDBYDATABASE;#Backgroundredoapply.Controlisreturne...

2019-06-27 08:40:30 847

原创【dg】空间满造成dg standby库无法apply arch log，提示ora-00600 ora-10877

一、关闭mrp的自动开启SQL> show parameter standbyNAME TYPE VALUE------------------------------------ ----------- ------------------------------standby_archive_dest...

2019-06-27 08:40:25 712

原创【dg】dataguard关闭开启及顺序

关闭：主库shutdown immediate;备库alter database recover managed standby database cancel;shutdown immediate;开启：备库：Startup nomountSQL> alter database mount standby database;SQ...

2019-06-27 08:40:20 638

原创【dg】最大性能lgwr sync配置no valid type处理

未配置standby_logSQL>selectcount(*)fromv$standby_log;COUNT(*)----------0初始配置altersystemsetlog_archive_dest_2='SERVICE=ora10glgwr syncVALID_FOR=(ONLINE_LOGFILES,PRIMARY...

2019-06-27 08:39:59 256

原创【dg】归档裂缝&FAL:（Archive Gap）（FAL: Fetch Archive Log）

当Primary Database的某些日志没有成功发送到Standby Database，这时候发生饿了归档裂缝（Archive Gap）。FAL是Fetch Archive Log的简写，它是dataguard主备之间GAP的处理机制。当Primary Database的某些日志没有成功发送到Standby Database，这时候发生饿了归档裂缝（Archive Gap）。...

2019-06-26 08:42:39 584

原创【ae】调整图层

1、单图层增加效果2、增加调整图层控制它下面的所有图层效果2.1效果图层形状2.2多调整图层叠加调整图层属性列可以点选切换...

2019-06-26 08:39:47 2422

转载【11g Performance 】21 Using Application Tracing Tools

21Using Application Tracing ToolsOracle Database提供了几个跟踪工具，可以帮助您监视和分析针对Oracle数据库运行的应用程序。End-to-End Application Tracing可以通过客户端标识符、服务、模块、操作、会话、实例或整个数据库来标识过多工作负载(如高负载SQL语句)的来源。这将问题隔离到特定的用户、服务、会话或应用程序...

2019-06-26 08:39:36 217

转载【11g Performance 】19 Using Optimizer Hints

19Using Optimizer HintsYou can use optimizerhintswith SQL statements to alter execution plans. This chapter explains how to use hints to instruct the optimizer to use specific approaches.The ch...

2019-06-26 08:39:28 324

转载【11g Performance 】13 Managing Optimizer Statistics

13Managing Optimizer StatisticsThis chapter explains why statistics are important for the query optimizer and how to gather and use optimizer statistics with theDBMS_STATSpackage.The chapter con...

2019-06-26 08:39:04 273

转载【11g Performance 】14 Using Indexes and Clusters

14Using Indexes and ClustersThis chapter provides an overview of data access methods using indexes and clusters that can enhance or degrade performance.The chapter contains the following sections...

2019-06-26 08:38:58 236

转载【11g Performance 】15 Using SQL Plan Management

15Using SQL Plan ManagementThis chapter describes how to manage SQL execution plans using SQL plan management. SQL plan management prevents performance regressions resulting from sudden changes to ...

2019-06-26 08:38:54 176

转载【11g Performance 】16 SQL Tuning Overview

16SQL Tuning OverviewThis chapter discusses goals for tuning, how to identify high-resource SQL statements, explains what should be collected, provides tuning suggestions, and discusses how to crea...

2019-06-26 08:38:50 335

转载【11g Performance 】17 Automatic SQL Tuning

17Automatic SQL TuningThis chapter discusses the automatic SQL tuning features of Oracle Database.Automatic SQL tuning automates the manual process, which is complex, repetitive, and time-consumin...

2019-06-26 08:38:45 452

转载【11g Performance 】12 Using EXPLAIN PLAN

12Using EXPLAIN PLANThis chapter introduces execution plans, describes the SQL statementEXPLAINPLAN, and explains how to interpret its output. This chapter also provides procedures for managing o...

2019-06-26 08:38:27 158

转载【11g Performance 】11 The Query Optimizer

11The Query OptimizerThis chapter discusses SQL processing, optimization methods, and how thequery optimizer(usually called theoptimizer) chooses a specific plan to execute SQL.The chapter con...

2019-06-25 08:28:05 332

转载【11g Performance 】10 Instance Tuning Using Performance Views

10Instance Tuning Using Performance ViewsAfter the initial configuration of a database, monitoring and tuning an instance regularly is important to eliminate any potential performance bottlenecks. ...

2019-06-25 08:11:50 319

转载【11g Performance 】9 Managing Operating System Resources

9Managing Operating System ResourcesThis chapter explains how to tune the operating system for optimal performance of Oracle Database.This chapter contains the following sections: Understandin...

2019-06-25 08:11:41 281

转载【11g Performance 】8 I/O Configuration and Design

8I/O Configuration and DesignThe I/O subsystem is a vital component of an Oracle database. This chapter introduces fundamental I/O concepts, discusses the I/O requirements of different parts of the...

2019-06-25 08:11:32 742

转载【11g Performance 】7 Configuring and Using Memory

7Configuring and Using MemoryThis chapter explains how to allocate memory to Oracle Database memory caches, and how to use those caches. Proper sizing and effective use of the Oracle Database memor...

2019-06-25 08:11:23 400

转载【11g Performance 】4 Configuring a Database for Performance

4Configuring a Database for PerformanceThis chapter contains an overview of the Oracle methodology for configuring a database for performance. Although performance modifications can be made to Orac...

2019-06-25 08:11:10 413

转载【11g Performance 】 3性能改进方法（Performance Improvement Methods）

3Performance Improvement MethodsThis chapter discusses Oracle Database improvement methods and contains the following sections: The Oracle Performance Improvement Method Emergency Performan...

2019-06-25 08:11:02 280

原创【11g】在Oracle系统中发现的十大错误

3.1.3Top Ten Mistakes Found in Oracle Systems本节列出了在Oracle数据库中发现的最常见错误。通过遵循Oracle性能改进方法，您应该能够完全避免这些错误。如果您在系统中发现了这些错误，那么就重新设计应用程序，使性能工作变得有价值。See"Automatic Performance Tuning Features"for informatio...

2019-06-25 08:10:46 196

原创【ae】用户自定义预设

2019-06-25 08:10:32 743

原创【ae】图层样式（ps里的图层样式）

不是效果菜单啊，在图层菜单下的图层样式里

2019-06-25 08:10:25 2347

原创【11g】 Performance Checklist

2.7.2Performance Checklist要帮助进行部署，请构建一个任务列表，以增加生产中获得最佳性能的机会，并支持应用程序的快速调试。执行以下操作: 当您为生产数据库创建控制文件时，通过将MAXINSTANCES、maxdatafile、MAXLOGFILES、MAXLOGMEMBERS和MAXLOGHISTORY设置为高于您对首次推出的预期值，从而允许增长。这种技术会导致...

2019-06-24 10:49:51 184

转载【11g Performance 】Designing and Developing for Performance

2Designing and Developing for Performance最优的系统性能从设计开始，并贯穿于系统的整个生命周期。在初始设计阶段仔细考虑性能问题，以便在生产期间更容易地调优系统。This chapter contains the following sections: Oracle Methodology Understanding Investme...

2019-06-24 10:33:17 1531

转载【11g Performance 】性能调优的概述

1Performance Tuning Overview本章介绍性能调优，并包含以下部分: Introduction to Performance Tuning Introduction to Performance Tuning Features and Tools 1.1Introduction to Performance Tuning本指南提供了关于调优...

2019-06-24 10:04:32 337

win10内置flash修复文件system32下的

regsvr32 C:\Windows\SysWOW64\Macromed\Flash\Flash.ocx regsvr32 C:\Windows\System32\Macromed\Flash\Flash.ocx pause

2020-09-18

django.rar

django2.2开发实战login的小例子打包，方便学习阶段入门使用 django2.2开发实战login的小例子打包，方便学习阶段入门使用 django2.2开发实战login的小例子打包，方便学习阶段入门使用

2020-09-01

coe_xfr_sql_profile.sql.zip

coe_xfr_sql_profile迁移统计信息 coe_xfr_sql_profile迁移统计信息 coe_xfr_sql_profile迁移统计信息 coe_xfr_sql_profile迁移统计信息

2020-09-01

xyj0905.rar

xyj自己修改的楼层

2020-08-23

pyundoparm.rar

【python的oracleundo实时监控最新版】数据转换是undo使用这个工具监控更直观，工具已打包exe，我的资源里下载标题显示服务器信息

2020-03-30

pyundoparm.rar

【python的oracleundo实时监控】数据转换是undo使用这个工具监控更直观，工具已打包exe，我的资源里下载这个版本增加时间定制

2020-03-30

pyundoparm.rar

【python的oracleundo实时监控】数据转换是undo使用这个工具监控更直观，工具已打包exe，我的资源里下载

2020-03-30

Python_game-master.zip

python -m pip install --upgrade pip pip install pygame -i https://pypi.doubanio.com/simple/ pip install pyinstaller -i https://pypi.doubanio.com/simple/

2020-03-15

telnet.rar

[root@lzwxhy1 home]# uname -a Linux lzwxhy1 2.6.32-431.el6.x86_64 #1 SMP Sun Nov 10 22:19:54 EST 2013 x86_64 x86_64 x86_64 GNU/Linux [root@lzwxhy1 home]# rpm -ivh xinetd-2.3.14-33.el6.x86_64.rpm rpm -ivh telnet*.rpm vi /etc/xinetd.d/telnet service xinetd restart /etc/init.d/xinetd start netstat -nltp|grep xinetd chkconfig xinetd on chkconfig --list|grep xinetd

2020-02-27

微信历史对话一个个删除.exe

感觉下载exe不安全的可以拷贝这个文本的粘到你的按键里，再搞个截图添加到付件即可 Rem mudstart Hwnd = Plugin.Window.Foreground Plugin.Window.Move Hwnd,0,0 MoveTo 179, 97 RightClick 1 Delay 300 FindPic 0,0,1024,768,"Attachment:\删除聊天.bmp",0.9,intX,intY If intX > 0 And intY > 0 Then MoveTo intX,intY LeftClick 1 Delay 300 End If Goto mudstart

2020-01-13

tuxedo81_win(1).exe

tuxedo81_win(1).exe tuxedo81_win(1).exe tuxedo81_win(1).exe tuxedo81_win(1).exe

2019-11-28

lic-TX81-China Mobile.zip

tuxedo8.1 license

2019-11-28

pip-19.3.1.rar

解压，在在解压后的当前目录下，按下shift + 鼠标右键，会出现“在此处打开命令窗口”的字样，然后点击即可。在控制台切换到pip的解压后的文件夹的路径中输入“python setup.py install”,setup.py就是它的安装文件

2019-11-22

HTMLTestRunner.py

HTMLTestRunner.py python3.xxx 1、HTMLTestRunner是Python标准库的unittest模块的扩展，无法通过pip安装； 2、下载HTMLTestRunner.py并将文件放到python3安装目录的Lib下；

2019-11-19

windows下的dd

C:\Documents and Settings\Administrator>dd --list rawwrite dd for windows version 0.6beta3. Written by John Newbigin This program is covered by terms of the GPL Version 2. Win32 Available Volume Information \\.\Volume{f96a7ab8-6270-11e9-b10a-806d6172696f}\ link to \\?\Device\HarddiskVolume1 fixed media Mounted on \\.\c: \\.\Volume{f96a7ab9-6270-11e9-b10a-806d6172696f}\ link to \\?\Device\HarddiskVolume2 fixed media Mounted on \\.\e: \\.\Volume{f96a7aba-6270-11e9-b10a-806d6172696f}\ link to \\?\Device\HarddiskVolume3 fixed media Mounted on \\.\f: \\.\Volume{f96a7abb-6270-11e9-b10a-806d6172696f}\ link to \\?\Device\HarddiskVolume4 fixed media Mounted on \\.\d: \\.\Volume{04f3c464-ee5a-11e9-b217-00e04ca38b2c}\ link to \\?\Device\Harddisk1\DP(1)0-0+8 removeable media Mounted on \\.\g: NT Block Device Objects \\?\Device\Harddisk0\Partition0 link to \\?\Device\Harddisk0\DR0 Fixed hard disk media. Block size = 512 size is 1000204886016 bytes \\?\Device\Harddisk0\Partition1 link to \\?\Device\HarddiskVolume1 \\?\Device\Harddisk0\Partition2 link to \\?\Device\HarddiskVolume2 Fixed hard disk media. Block size = 512 size is 292058824704 bytes \\?\Device\Harddisk0\Partition3 link to \\?\Device\HarddiskVolume3 Fixed hard disk media. Block size = 512 size is 308710211584 bytes \\?\Device\Harddisk0\Partition4 link to \\?\Device\HarddiskVolume4 \\?\Device\Harddisk1\Partition0 link to \\?\Device\Harddisk1\DR7 Removable media other than floppy. Block size = 512 size is 67108864000 bytes \\?\Device\Harddisk1\Partition1 link to \\?\Device\Harddisk1\DP(1)0-0+8 Virtual input devices /dev/zero (null data) /dev/random (pseudo-random data) - (standard input) Virtual output devices - (standard output) /dev/null (discard the data)

2019-10-14

xyjold.rar

xyj450巫师搭建场景入门xyj.rar修改前

2019-08-28

xyj450巫师搭建场景入门xyj.rar修改后

2019-08-28

Baymax Patch Tools v2.9.1 Hb.rar

2019-07-31

Baymax Patch Tools x64 v2.3.5.rar

2019-07-31

diablo2oo2's Universal Patcher(DUP) v2.26.1 汉化版.rar

2019-07-31

oceanbase-client-1.1.10.jar

2024-09-23

py3.7.4通过jaydebeapi访问jdbc链接oceanbase的oracle模式

2024-09-13

Microsoft Visual C++ 14.0 or greater is required

error: Microsoft Visual C++ 14.0 or greater is required. Get it with "Microsoft C++ Build Tools": https://visualstudio.microsoft.com/visual-cpp-build-tools/ [end of output] note: This error originates from a subprocess, and is likely not a problem with pip. ERROR: Failed building wheel for JPype1 Failed to build JPype1 ERROR: Could not build wheels for JPype1, which is required to install pyproject.toml-based projects

2024-09-13

全国统计用区划代码和城乡划分代码(2023版)

2024-04-08

监控oceanbase的python小工具dooba

[root@localhost ~]# cd /root/myoceanbase/oceanbase/script/dooba python2 dooba -h127.0.0.1 -P2881 -utest -ptest

2024-04-02

oracle tpt脚本 tpt-oracle-master 脚本

2023-12-22

mmap2mm mmap2mm mmap2mm

mmap2mm 工具包解压python.mmap到目录下，然后使用如下工具转换解压缩目录里的Document.xml xsltproc.exe -o test.mm mm2fm.xslt Document.xml 生成的test.mm 就是目标freemind格式的mm文件

2023-01-05

hcache Linux系统buff/cache过高问题处理

chmod 755 hcache mv hcache /usr/local/bin

2022-10-09

chrome的vue插件6.1.4

chrome的vue插件6.1.4 chrome的vue插件6.1.4

2022-05-23

echarts.zip修改增加ylabel的rotate属性

解压后放到C:\Users\viviliving\AppData\Local\Programs\Python\Python37-32\Lib\site-packages\pyecharts\echarts位置即可版本pyechart0.5

2021-12-21

融资融券最新行情排行榜与个股历史趋势py脚本

2021-08-05

ssq20210618.rar

双色球2004以来截至20210618历史红蓝号例子： 2021-06-17,2021067,01,11,19,23,25,29,09 2021-06-15,2021066,02,06,19,26,30,33,15 2021-06-13,2021065,01,04,08,19,29,33,16 2021-06-10,2021064,04,06,08,15,16,18,16 2021-06-08,2021063,04,05,06,09,23,24,09 2021-06-06,2021062,12,13,15,20,22,25,10 2021-06-03,2021061,04,09,12,18,20,23,01 2021-06-01,2021060,10,11,17,20,29,30,15

2021-06-18

dbms_datapump的subquery测试：发现impdp的query条件都可行，但是采用dbms_datapump过程方式每次都是全表泵入，没有按照subquery的条件

2019-10-10

TA创建的收藏夹 TA关注的收藏夹

TA关注的人

win10内置flash修复文件system32下的

django.rar

coe_xfr_sql_profile.sql.zip

xyj0905.rar

pyundoparm.rar

pyundoparm.rar

pyundoparm.rar

Python_game-master.zip

telnet.rar

微信历史对话一个个删除.exe

tuxedo81_win(1).exe

lic-TX81-China Mobile.zip

pip-19.3.1.rar

HTMLTestRunner.py

windows下的dd

xyjold.rar

xyj450巫师搭建场景入门xyj.rar修改后

Baymax Patch Tools v2.9.1 Hb.rar

Baymax Patch Tools x64 v2.3.5.rar

diablo2oo2's Universal Patcher(DUP) v2.26.1 汉化版.rar

oceanbase-client-1.1.10.jar

py3.7.4通过jaydebeapi访问jdbc链接oceanbase的oracle模式

Microsoft Visual C++ 14.0 or greater is required

全国统计用区划代码和城乡划分代码(2023版)

监控oceanbase的python小工具dooba

oracle tpt脚本 tpt-oracle-master 脚本

mmap2mm mmap2mm mmap2mm

hcache Linux系统buff/cache过高问题处理

chrome的vue插件6.1.4

echarts.zip修改增加ylabel的rotate属性

融资融券最新行情排行榜与个股历史趋势py脚本

ssq20210618.rar

ngiphash4.tar

ngx_http_upstream_ip_hash_module.c

datax使用python3的替换bin文件

lenses 隐形眼镜预测数据

oecd_bli_2015 gdp_per_capita

pb10的SQLanywhere9绿色win32压缩

腾讯会议pc版备份 腾讯会议pc版备份

win10内置flash修复文件SysWOW64下的

dbms_datapump的subquery测试：发现impdp的query条件都可行，但是采用dbms_datapump过程方式每次都是全表泵入，没有按照subquery的条件

腾讯会议pc版备份腾讯会议pc版备份