【爬虫】利用Python爬虫爬取小麦苗itpub博客的所有文章的连接地址(1)
爬取结果:
火狐(Firefox)如何移除add?security?exception添加的网站:http://blog.itpub.net/26736162/viewspace-2286064/ 如何将网页保存成mhtml格式:http://blog.itpub.net/26736162/viewspace-2285988/ Windows下安装MongoDB:http://blog.itpub.net/26736162/viewspace-2285966/ 【爬虫】python爬虫从入门到放弃:http://blog.itpub.net/26736162/viewspace-2285848/ 【爬虫】网页抓包工具--Charles的使用教程:http://blog.itpub.net/26736162/viewspace-2285754/ 【爬虫】网页抓包工具--Fiddler:http://blog.itpub.net/26736162/viewspace-2285735/ Tesseract-OCR的使用---提取图片中的文字(OneNote):http://blog.itpub.net/26736162/viewspace-2285595/ 【PDB升级】12.1.0.2的PDB升级到12.2.0.2的实验:http://blog.itpub.net/26736162/viewspace-2284343/ 【故障解决】ORA-17630:?Mismatch?in?the?remote?file?protocol?version?client?2:http://blog.itpub.net/26736162/viewspace-2284342/ Excel打开csv文件出现乱码的解决办法:http://blog.itpub.net/26736162/viewspace-2284328/ 【 Linux 】ps?-ef|grep详解:http://blog.itpub.net/26736162/viewspace-2284157/ 【故障处理】 Linux 下导入导出“IMP-00030:?failed?to?create?file?...?for?write”:http://blog.itpub.net/26736162/viewspace-2284051/ Oracle?12.2?新特性:?Online?PDB?relocate?(PDB?hot?move):http://blog.itpub.net/26736162/viewspace-2284043/ 【故障处理】ORA-3113??"end?of?file?on?communication?channel":http://blog.itpub.net/26736162/viewspace-2283872/ Oracle各种版本下“示例数据库的创建”的创建:http://blog.itpub.net/26736162/viewspace-2222411/ Oracle?12.2?新特性--PDB和CDB的字符集可以不一样:http://blog.itpub.net/26736162/viewspace-2222369/ 【故障解决】12c中的APEX,ORA-65346:?The?PDB?version?is?lower?and?components:http://blog.itpub.net/26736162/viewspace-2222308/ Oracle?12.2?新特性:在线PDB数据库克隆(Pluggable?Hot?Clone):http://blog.itpub.net/26736162/viewspace-2222155/ Oracle?12.2新特性:?PDB级闪回数据库(Flashback?PDB):http://blog.itpub.net/26736162/viewspace-2222124/ Linux 下使用timedatectl命令时间时区操作详解:http://blog.itpub.net/26736162/viewspace-2221928/ 在Oracle中,如何定时删除归档日志文件?:http://blog.itpub.net/26736162/viewspace-2221765/ CentOS?7.3??ECS上搭建RAC?18c+单实例DG+EMCC+DG的FSFO快速故障转移配置:http://blog.itpub.net/26736162/viewspace-2220931/ Oracle?12c中的with子句增强:http://blog.itpub.net/26736162/viewspace-2220101/ Oracle实现自增列(序列+触发器实现、Identity?Columns新特性、序列作为默认值):http://blog.itpub.net/26736162/viewspace-2220097/ windows10?彻底关闭自动更新【绝对管用】:http://blog.itpub.net/26736162/viewspace-2220067/ Oracle?12c?新参数?PGA_AGGREGATE_LIMIT?限制?PGA?内存总大小:http://blog.itpub.net/26736162/viewspace-2219952/ centos7开机无法进入图形界面,出现?sda?assuming?drive?cache?write?through:http://blog.itpub.net/26736162/viewspace-2219876/ 【12.2】Oracle?12C?R2新特性-外部表支持分区了(Partitioning?External?Tables):http://blog.itpub.net/26736162/viewspace-2219754/ Oracle?12C?R2新特性-本地UNDO模式(LOCAL_UNDO_ENABLED):http://blog.itpub.net/26736162/viewspace-2219179/ alert日志中出现Private?Strand?Flush?Not?Complete的处理方法:http://blog.itpub.net/26736162/viewspace-2219167/ 【18c】Oracle?18.3?RPM安装:http://blog.itpub.net/26736162/viewspace-2218364/ 打Oracle?PSU时碰到的一些问题处理:http://blog.itpub.net/26736162/viewspace-2218185/ PSU的GI升级,ERROR:?This?patch?is?not?applicable?to?GI?home.:http://blog.itpub.net/26736162/viewspace-2218104/ 【mos???1494646.1】Patch?Installation?and?Deinstallation?For?11.2.0.3.x?GI?PSU:http://blog.itpub.net/26736162/viewspace-2218056/ 【mos?1265700.1】Oracle?Patch?Assurance?-?Data?Guard?Standby-First?Patch?Apply:http://blog.itpub.net/26736162/viewspace-2218053/ 【MOS?966023.1】How?to?Create?an?OCM?Response?file?to?Apply?a?Patch?in?Silent:http://blog.itpub.net/26736162/viewspace-2218001/ 静默安装11.2.0.1数据库软件报[FATAL]?[INS-32035]?Unable?to?create:http://blog.itpub.net/26736162/viewspace-2217928/ 【MOS】从?11.2.0.N?版本非原地手动升级到最新的?11.2.0.N??(文档?ID?1602485.1):http://blog.itpub.net/26736162/viewspace-2217897/ 【MOS】手动升级到数据库?12c?版本1(12.1)的完整核对清单?(文档?ID?2047701.1):http://blog.itpub.net/26736162/viewspace-2217879/ 【DG】dg中如何配置多个后台observer:http://blog.itpub.net/26736162/viewspace-2217586/ EMCC?13添加其它主机和数据库:http://blog.itpub.net/26736162/viewspace-2217130/ 如何将浏览器的默认语言设置成英文?:http://blog.itpub.net/26736162/viewspace-2217033/ 手动删除EMCC13C的?Repository?Database:http://blog.itpub.net/26736162/viewspace-2216941/ 【EMCC】Oracle?13c?OEM?安装测试(13.2.0.0):http://blog.itpub.net/26736162/viewspace-2216869/ 【EMCC】?12.1.0.5?OEM?server?agent?安装配置及监控MySQL数据库:http://blog.itpub.net/26736162/viewspace-2216862/ “两地三中心”和“双活”简介--容灾技术方案:http://blog.itpub.net/26736162/viewspace-2216584/ Windows?7平台静默安装11.2.0.4软件及静默建库:http://blog.itpub.net/26736162/viewspace-2215927/ [INS-30131]?执行安装程序验证所需的初始设置失败.:http://blog.itpub.net/26736162/viewspace-2215926/ Oracle?12c?手动创建CDB和非CDB:http://blog.itpub.net/26736162/viewspace-2215902/ Oracle?12c的DG自动同步密码文件--ASM?新特性:共享密码文件:http://blog.itpub.net/26736162/viewspace-2215881/ 新书出版?|《Oracle程序员面试笔试宝典》:http://blog.itpub.net/26736162/viewspace-2215744/ 【密码文件】Oracle?18c?orapwd?命令??OPW-00029:?Password?complexity?failed:http://blog.itpub.net/26736162/viewspace-2215659/ RMAN?duplicate?from?active?时遭遇?RMAN-04017和ORA-00439:http://blog.itpub.net/26736162/viewspace-2215546/ RMAN?duplicate?from?active?时遭遇?RMAN-06136?ORA-17627?ORA-17629?ORA-12154:http://blog.itpub.net/26736162/viewspace-2215543/ 【故障处理】ORA-65500:?could?not?modify?DB_UNIQUE_NAME,?resource?exists:http://blog.itpub.net/26736162/viewspace-2215518/ RHEL?7.X?或CentOS?7?安装?11.2.0.4?RAC碰到的问题:http://blog.itpub.net/26736162/viewspace-2215349/ n2n内网穿透神器--可以用于设置rac搭建时的网卡(在云平台上有用):http://blog.itpub.net/26736162/viewspace-2215010/ MySQL登陆命令行参数:http://blog.itpub.net/26736162/viewspace-2214658/ ASM重命名包含OCR/vote?file的磁盘组:http://blog.itpub.net/26736162/viewspace-2214506/ Oracle?12c和18c中的MGMTDB(下):http://blog.itpub.net/26736162/viewspace-2214405/ RHEL6?或CentOS?6配置共享存储--使用iSCSI:http://blog.itpub.net/26736162/viewspace-2214388/ RHEL7?或CentOS7配置共享存储--使用iSCSI:http://blog.itpub.net/26736162/viewspace-2214385/ CentOS7和RHEL7在?/etc/fstab中不包含/dev/shm:http://blog.itpub.net/26736162/viewspace-2214381/ RHEL7或CentOS7中缺少compat-libstdc++-33-3.2.3:http://blog.itpub.net/26736162/viewspace-2214380/ Huge?pages?(标准大页)和?Transparent?Huge?pages(透明大页):http://blog.itpub.net/26736162/viewspace-2214374/ DAS、SAN、NAS三种存储:http://blog.itpub.net/26736162/viewspace-2214368/ CentOS7?或者?CentOS6?忘记root密码重新设置方法:http://blog.itpub.net/26736162/viewspace-2214079/ CentOS?7?中英文桌面安装步骤详细图解:http://blog.itpub.net/26736162/viewspace-2214076/ CentOS7.3下载,CentOS7.3?iso下载:http://blog.itpub.net/26736162/viewspace-2214056/ 在Oracle中,什么是物理读和逻辑读?:http://blog.itpub.net/26736162/viewspace-2213588/ Oracle?12c?EM?express系列:http://blog.itpub.net/26736162/viewspace-2213570/ Oracle?12C?中CDB和PDB的参数文件管理:http://blog.itpub.net/26736162/viewspace-2213348/ 【OCP最新题库解析(052)--题10】?Which?two?are?true?about?the?Archive?(ARCn:http://blog.itpub.net/26736162/viewspace-2213225/ 【OCP最新题库解析(052)--题9】You?want?to?install?Oracle?11g?database:http://blog.itpub.net/26736162/viewspace-2213224/ 【OCP最新题库解析(052)--题8】Which?two?are?true?about?undo?tablespaces?:http://blog.itpub.net/26736162/viewspace-2213223/ 【OCP最新题库解析(052)--题7】?Examine?theses?SQL?statements?and?output:http://blog.itpub.net/26736162/viewspace-2213221/ 【OCP最新题库解析(052)--题6】Which?structure?can?span?multiple?data?files:http://blog.itpub.net/26736162/viewspace-2213220/ 【OCP最新题库解析(052)--题5】Which?two?are?true?about?roles?:http://blog.itpub.net/26736162/viewspace-2213218/ 【OCP最新题库解析(052)--题4】Which?four?are?true?about?the?tools?used?to?:http://blog.itpub.net/26736162/viewspace-2213217/ 【OCP最新题库解析(052)--题3】Which?two?are?true?about?external?tables?:http://blog.itpub.net/26736162/viewspace-2213215/ 【OCP最新题库解析(052)--题2】...is?true?about?FAST_START_MTTR_TARGET:http://blog.itpub.net/26736162/viewspace-2213214/ Oracle??RAC?One?node:http://blog.itpub.net/26736162/viewspace-2213212/ Oracle?12c?新特性之临时Undo--temp_undo_enabled:http://blog.itpub.net/26736162/viewspace-2212794/ Oracle?rac使用nid和dbms_backup_restore包修改dbid和dbname:http://blog.itpub.net/26736162/viewspace-2212464/ 【dgmgrl】使用dgmgrl做switchover切换报错ORA-16501,?ORA-16625等:http://blog.itpub.net/26736162/viewspace-2200090/ 【MSSQL】SSMS快速获取表结构:http://blog.itpub.net/26736162/viewspace-2199336/ MySQL中日期转换?FROM_UNIXTIME和UNIX_TIMESTAMP:http://blog.itpub.net/26736162/viewspace-2199334/ 新书出版?|《数据库程序员面试笔试真题库》:http://blog.itpub.net/26736162/viewspace-2199229/ 新书出版?|《数据库程序员面试笔试宝典》:http://blog.itpub.net/26736162/viewspace-2199226/ 【静默】在RHEL?6.5上静默安装Oracle?18c:http://blog.itpub.net/26736162/viewspace-2168949/ 【静默】Oracle各类响应文件何在?:http://blog.itpub.net/26736162/viewspace-2168887/ 物理DG、逻辑DG和快照DG的搭建(视频讲解):http://blog.itpub.net/26736162/viewspace-2158321/ 【故障处理】ORA-31600和ORA-04063错误:http://blog.itpub.net/26736162/viewspace-2158232/ 修复由于主库NOLOGGING操作引起的备库ORA-01578和ORA-26040错误:http://blog.itpub.net/26736162/viewspace-2158170/ HowTo?Restore?RMAN?Disk?backups?of?RAC?Database?to?Single?Instance?On?Another?No:http://blog.itpub.net/26736162/viewspace-2158037/ 海量IT资料?+?各种平台下的Oracle安装文件?+?公开课录像?+?各种视频教程资料:http://blog.itpub.net/26736162/viewspace-1624453/ Oracle软件权限修复:http://blog.itpub.net/26736162/viewspace-2157665/ Linux ?vi替换字符串:http://blog.itpub.net/26736162/viewspace-2157664/ 【麦课】1~OEL的下载:http://blog.itpub.net/26736162/viewspace-2157637/ 【RAC】如何修改SCAN?IP的IP地址、名称、端口等信息:http://blog.itpub.net/26736162/viewspace-2157372/ 如何在?oracle?集群环境下修改私网信息?(文档?ID?2103317.1):http://blog.itpub.net/26736162/viewspace-2157364/ 如何修改集群的公网信息(包括?VIP)?(文档?ID?1674442.1):http://blog.itpub.net/26736162/viewspace-2157362/ Windows和 Linux 下的MTU查看和修改:http://blog.itpub.net/26736162/viewspace-2157354/ SQL?SERVER使用STUFF函数拼接记录为逗号分隔符:http://blog.itpub.net/26736162/viewspace-2157302/ SqlServer中循环和条件语句:http://blog.itpub.net/26736162/viewspace-2157291/ SQL?SERVER?日期格式化、日期和字符串转换:http://blog.itpub.net/26736162/viewspace-2157290/ 11gR2?RAC添加和删除节点步骤:http://blog.itpub.net/26736162/viewspace-2157256/ Oracle集群(RAC)时间同步(ntp和CTSS):http://blog.itpub.net/26736162/viewspace-2157130/ /etc/inittab文件详解:http://blog.itpub.net/26736162/viewspace-2157027/ wwid、uuid、lun、multipath、hba、udev总结:http://blog.itpub.net/26736162/viewspace-2156989/ 【OCP最新题库解析(052)--题1】Which?is?true?about?the?SYSTEM?and?SYSAUX...:http://blog.itpub.net/26736162/viewspace-2156982/ SQL?Server函数之空值处理:http://blog.itpub.net/26736162/viewspace-2156949/ Oracle?11g?RAC安装--基于openfiler存储+多路径+udev方式:http://blog.itpub.net/26736162/viewspace-2156494/ SqlServer获取当前日期:http://blog.itpub.net/26736162/viewspace-2156462/ SQL?Server中字符串处理函数:http://blog.itpub.net/26736162/viewspace-2156459/ “ORA-28007:?the?password?cannot?be?reused”解决:http://blog.itpub.net/26736162/viewspace-2156370/ SQL?Server常见数据类型介绍:http://blog.itpub.net/26736162/viewspace-2156218/ 如何查看端口被哪个进程占用?:http://blog.itpub.net/26736162/viewspace-2156095/ oracle?11gR2?RAC?root.sh?错误?ORA-15072?ORA-15018:http://blog.itpub.net/26736162/viewspace-2155736/ RAC?增加SCAN?IP:http://blog.itpub.net/26736162/viewspace-2155652/ 将RAC软件转换为单实例软件:http://blog.itpub.net/26736162/viewspace-2155632/ 数据泵导出导入物化视图(ORA-39083):http://blog.itpub.net/26736162/viewspace-2155381/ 【DB笔试面试185】在Oracle中,如何让普通用户可以TRUNCATE其他用户的表?:http://blog.itpub.net/26736162/viewspace-2155367/ ORA-00245:?control?file?backup?failed;?target?is?likely?on?a?local?file?system:http://blog.itpub.net/26736162/viewspace-2155016/ 使用RMAN进行排除表空间备份:http://blog.itpub.net/26736162/viewspace-2154814/ 【解决方案】Oracle插入/更新CLOB字段报ORA-01704:字符串文字太长:http://blog.itpub.net/26736162/viewspace-2154662/ 在Oracle中,如何定时清理INACTIVE状态的会话?:http://blog.itpub.net/26736162/viewspace-2154547/ 为何SYSTEM用户可以将V$SESSION的查询权限赋权给其他用户而SYS用户却不可以?:http://blog.itpub.net/26736162/viewspace-2154543/ Oracle?同义词总结:http://blog.itpub.net/26736162/viewspace-2154285/ ifconfig命令:http://blog.itpub.net/26736162/viewspace-2153430/ Oracle闪回恢复区(fast?recovery?area,FRA):http://blog.itpub.net/26736162/viewspace-2153332/ Oracle中有哪些指导模块(Advisor)?:http://blog.itpub.net/26736162/viewspace-2153325/ Oracle数据字典:http://blog.itpub.net/26736162/viewspace-2153324/ Oracle表空间的管理方式(LMT、DMT)--本地和字典管理:http://blog.itpub.net/26736162/viewspace-2153321/ 【OCP|052】OCP最新题库解析(052)--小麦苗解答版:http://blog.itpub.net/26736162/viewspace-2153255/ 【 Linux 】 Linux 文件之/etc/fstab:http://blog.itpub.net/26736162/viewspace-2153116/ 【 Linux 】虚拟磁盘挂载错误,不能进入系统(fsck.ext3:no?such?file?directory):http://blog.itpub.net/26736162/viewspace-2153113/ IDE、SATA、SCSI、SAS、FC、SSD?硬盘类型:http://blog.itpub.net/26736162/viewspace-2153054/ MySQL添加列、删除列,创建主键等常用操作总结:http://blog.itpub.net/26736162/viewspace-2153033/ ?什么是CRUD(?What?is?CRUD):http://blog.itpub.net/26736162/viewspace-2152988/ MySQL?的日期和时间函数:http://blog.itpub.net/26736162/viewspace-2152970/ Linux 环境安装Python3.6.x:http://blog.itpub.net/26736162/viewspace-2152955/ 【DB笔试面试164】在Oracle中,如何彻底停止expdp数据泵进程?:http://blog.itpub.net/26736162/viewspace-2152918/ 如何导出存储过程、函数、包和触发器的定义语句?如何导出表和索引的创建语句?:http://blog.itpub.net/26736162/viewspace-2152892/ 在Oracle中,如何得到真实的执行计划?:http://blog.itpub.net/26736162/viewspace-2152884/ 【DB笔试面试352】在Oracle数据库中,哪些操作会导致索引失效?--UNUSABLE?INDEXES:http://blog.itpub.net/26736162/viewspace-2152871/ SYSAUX表空间占用过大情况下的处理(AWR信息过多):http://blog.itpub.net/26736162/viewspace-2152868/ 如何让excel单元格内只能输入指定内容?:http://blog.itpub.net/26736162/viewspace-2152787/ ORA-01578和ORA-26040--NOLOGGING操作引起的坏块-错误解释和解决方案:http://blog.itpub.net/26736162/viewspace-2152783/ ORA-02303无法使用类型或表的相关性来删除或取代一个类型:http://blog.itpub.net/26736162/viewspace-2152780/ 【12c】oracle12c?的SYSBACKUP、SYSDG、SYSKM系统用户:http://blog.itpub.net/26736162/viewspace-2152738/ 【12c】12c?RMAN新特性之通过网络远程恢复数据库(RESTORE/Recover?from?Service):http://blog.itpub.net/26736162/viewspace-2152717/ 【12c】12c?RMAN新特性之UNTIL?AVAILABLE?REDO--自动恢复到REDO终点的步骤简化:http://blog.itpub.net/26736162/viewspace-2152715/ 【12c】12c?RMAN新特性之recover?table(表级别恢复):http://blog.itpub.net/26736162/viewspace-2152712/ 【RMAN】SPFILE的恢复方式有哪几种?:http://blog.itpub.net/26736162/viewspace-2152507/ 【RMAN】如果控制文件损坏那么如何恢复?恢复控制文件的方式有哪几种?:http://blog.itpub.net/26736162/viewspace-2152506/ MySQL存储过程系列:http://blog.itpub.net/26736162/viewspace-2152182/ 【rman】恢复目录的使用(Recovery?catalog):http://blog.itpub.net/26736162/viewspace-2152132/ 【RMAN】Oracle中如何备份控制文件?备份控制文件的方式有哪几种?:http://blog.itpub.net/26736162/viewspace-2152115/ RAC环境单实例启动数据库收到ORA-29702报错:http://blog.itpub.net/26736162/viewspace-2151251/ 在高并发、高负载的情况下,如何给表添加字段并设置DEFAULT值?:http://blog.itpub.net/26736162/viewspace-2151015/ CentOS?7.1静默安装11.2.0.3?64位单机数据库软件:http://blog.itpub.net/26736162/viewspace-2150941/ centos7修改主机名方法:http://blog.itpub.net/26736162/viewspace-2150940/ 造成错误“ORA-12547:?TNS:lost?contact”的常见原因有哪些?:http://blog.itpub.net/26736162/viewspace-2150922/ MD5值的简介和查看:http://blog.itpub.net/26736162/viewspace-2150149/ 在AIX或 Linux 下,如何查看磁盘是否包含数据?:http://blog.itpub.net/26736162/viewspace-2149976/ Linux ?Swap交换分区介绍总结:http://blog.itpub.net/26736162/viewspace-2149754/ Oracle数据类型介绍:http://blog.itpub.net/26736162/viewspace-2149685/ Linux 操作系统常用log日志:http://blog.itpub.net/26736162/viewspace-2149616/ Linux 中查看文件时显示行号:http://blog.itpub.net/26736162/viewspace-2149603/ 如何让oracle?DB、监听和oem开机启动(dbstart):http://blog.itpub.net/26736162/viewspace-2149597/ Linux 下chkconfig命令详解?(service):http://blog.itpub.net/26736162/viewspace-2149595/ Oracle使用SQL*Plus生成html文件:http://blog.itpub.net/26736162/viewspace-2149543/ Oracle?sqlplus的set命令详细使用和设置:http://blog.itpub.net/26736162/viewspace-2149540/ Oracle?sqlplus参数autocommit(自动提交)的设置:http://blog.itpub.net/26736162/viewspace-2149538/ Oracle?iSQL*Plus(11g已经弃用):http://blog.itpub.net/26736162/viewspace-2149536/ 【MySQL】参数wait_timeout和interactive_timeout的作用和区别是什么?:http://blog.itpub.net/26736162/viewspace-2149454/ 【转载】?MySQL数据库“十宗罪”(十大经典错误案例):http://blog.itpub.net/26736162/viewspace-2149449/ 【MySQL】有关登录连接的几个参数(max_connections等)及其相关错误:http://blog.itpub.net/26736162/viewspace-2149444/ 【MySQL】如何对SQL语句进行跟踪(trace)?:http://blog.itpub.net/26736162/viewspace-2149385/ 【MySQL】通过show?status?优化数据库性能:http://blog.itpub.net/26736162/viewspace-2149326/ MySQL临时表:http://blog.itpub.net/26736162/viewspace-2149312/ 如何将一个数字转换为字符串并且按照指定格式显示?--TO_CHAR:http://blog.itpub.net/26736162/viewspace-2149299/ Oracle中CAST函数使用简介:http://blog.itpub.net/26736162/viewspace-2149297/ Oracle中的并行:http://blog.itpub.net/26736162/viewspace-2149240/ MySQL?Workbench?已经停止工作的解决方案:http://blog.itpub.net/26736162/viewspace-2149201/ Oracle归档日志比联机重做日志小很多的情况总结:http://blog.itpub.net/26736162/viewspace-2149091/ Oracle的NLS_DATE_FORMAT设置(日期格式设置):http://blog.itpub.net/26736162/viewspace-2149081/ 【MySQL】SHOW?WARNINGS和SHOW?ERRORS的作用是什么?:http://blog.itpub.net/26736162/viewspace-2149036/ ORA-29876?无法执行ODCIINDEXDELETE例行程序?处理过程:http://blog.itpub.net/26736162/viewspace-2149032/ MySQL?SQL?Mode(模式)介绍:http://blog.itpub.net/26736162/viewspace-2149027/ 【MySQL】为什么索引没有被使用?:http://blog.itpub.net/26736162/viewspace-2148950/ MySQL??pager和nopager命令--不显示查询结果:http://blog.itpub.net/26736162/viewspace-2148933/ MySQL?SQL?hint?提示:http://blog.itpub.net/26736162/viewspace-2148878/ oracle?Extract?函数:http://blog.itpub.net/26736162/viewspace-2148873/ MySQL?隐式类型转换:http://blog.itpub.net/26736162/viewspace-2148819/ MySQL中的limit分页优化:http://blog.itpub.net/26736162/viewspace-2148816/ mysql中utf8和utf8mb4区别:http://blog.itpub.net/26736162/viewspace-2148812/ myisampack工具(MyISAM表压缩工具):http://blog.itpub.net/26736162/viewspace-2148714/ Oracle?11g中的IO?Calibrate(IO校准)--Automatic?Degree?of?Parallelism(DOP):http://blog.itpub.net/26736162/viewspace-2148709/ Oracle?dblink介绍:http://blog.itpub.net/26736162/viewspace-2148696/ Oracle?Directory(目录)介绍:http://blog.itpub.net/26736162/viewspace-2148694/ 【体系结构】有关Oracle?SCN知识点的整理--补充内容:http://blog.itpub.net/26736162/viewspace-2148359/ Linux 上创建和更改硬链接和符号链接(软连接):http://blog.itpub.net/26736162/viewspace-2148266/ optimizer_index_caching和optimizer_index_cost_adj两个参数说明:http://blog.itpub.net/26736162/viewspace-2148153/ 【OCP|OCM】Oracle培训考证系列:http://blog.itpub.net/26736162/viewspace-2148098/ Oracle?11g?新特性?--?Online?Patching?(Hot?Patching?热补丁)说明:http://blog.itpub.net/26736162/viewspace-2147975/ Listings?of?System?and?Object?Privileges--系统和对象权限列表:http://blog.itpub.net/26736162/viewspace-2147935/ truncate后恢复包---FY_Recover_Data.pck?包的内容:http://blog.itpub.net/26736162/viewspace-2147931/ DBA,SYSDBA,SYSOPER三者的区别:http://blog.itpub.net/26736162/viewspace-2147919/ STS(SQL?Tuning?Set)导入导出过程及错误处理:http://blog.itpub.net/26736162/viewspace-2147891/ Oracle之函数索引:http://blog.itpub.net/26736162/viewspace-2147880/ 【密码文件】Oracle?OS认证与密码文件(口令文件)认证--密码文件介绍:http://blog.itpub.net/26736162/viewspace-2147876/ 在Oracle中,如何判断一个字符串是否为数字?:http://blog.itpub.net/26736162/viewspace-2147825/ ipcs、ipcrm、sysresv、kernel.shmmax:http://blog.itpub.net/26736162/viewspace-2147273/ 【DG】利用闪回数据库(flashback)修复Failover后的DG环境:http://blog.itpub.net/26736162/viewspace-2146883/ Oracle工具之sqlldr的使用--如何将文本文件或Excel中的数据导入数据库:http://blog.itpub.net/26736162/viewspace-2146660/ 如何安装DBMS_NETWORK_ACL_ADMIN包?:http://blog.itpub.net/26736162/viewspace-2146642/ 数据文件、表空间offline用法及区别:http://blog.itpub.net/26736162/viewspace-2146637/ ERROR:?NMO?not?setuid-root?(Unix-only)错误的解决方法:http://blog.itpub.net/26736162/viewspace-2145971/ ?Oracle优化器:星型转换(Star?Query?Transformation?)?:http://blog.itpub.net/26736162/viewspace-2145824/ 如何重建encrytion?wallet??in?ORA-28374?:http://blog.itpub.net/26736162/viewspace-2145525/ ?ORA-30009:?CONNECT?BY?操作内存不足--XMLTable的使用:http://blog.itpub.net/26736162/viewspace-2145464/ 【DG】DG备库报ORA-28000:?the?account?is?locked的解决办法:http://blog.itpub.net/26736162/viewspace-2145402/ 设置su和sudo为不需要密码:http://blog.itpub.net/26736162/viewspace-2145374/ 【BBED】BBED模拟并修复ORA-08102错误:http://blog.itpub.net/26736162/viewspace-2145368/ Oracle?中?Object_iD?和?Data_Object_ID?的区别:http://blog.itpub.net/26736162/viewspace-2145230/ Oracle的dump函数:http://blog.itpub.net/26736162/viewspace-2145228/ SYS.MON_MODS$、SYS.MON_MODS_ALL$和DBA_TAB_MODIFICATIONS:http://blog.itpub.net/26736162/viewspace-2145157/ 藏在表分区统计信息背后的小秘密:http://blog.itpub.net/26736162/viewspace-2145154/ MySQL和Oracle中的隐式转换:http://blog.itpub.net/26736162/viewspace-2145096/ ORA-19566?exceeded?limit?of?0?corrupt?blocks数据坏块处理:http://blog.itpub.net/26736162/viewspace-2145033/ 等待事件之enq:?HW?-?contention:http://blog.itpub.net/26736162/viewspace-2144992/ 常用 Linux 命令集锦:http://blog.itpub.net/26736162/viewspace-2144985/ Linux ?TOP命令:http://blog.itpub.net/26736162/viewspace-2144984/ 工作十年的程序员,却拿着毕业三年的工资……:http://blog.itpub.net/26736162/viewspace-2144980/ DBMS_METADATA包获得对象DDL语句:http://blog.itpub.net/26736162/viewspace-2144976/ DBMS_ERRLOG记录DML错误日志:http://blog.itpub.net/26736162/viewspace-2144970/ Oracle?12c数据库优化器统计信息收集的最佳实践:http://blog.itpub.net/26736162/viewspace-2144967/ 从删库到跑路,DBA?如何防止被淘汰?:http://blog.itpub.net/26736162/viewspace-2144966/ 【故障|监听】TNS-12545、TNS-12560、TNS-00515和 Linux ?Error:?111:http://blog.itpub.net/26736162/viewspace-2144915/ ? linux系统 启动报错:[contains?a?file?system?with?errors,?check?forced]的解决方法:http://blog.itpub.net/26736162/viewspace-2144861/ coe_xfr_sql_profile.sql和coe_load_sql_profile.sql:http://blog.itpub.net/26736162/viewspace-2144831/ 云和恩墨的两道Oracle面试题:http://blog.itpub.net/26736162/viewspace-2144810/ ORA-00600:?internal?error?code,?arguments:?[4194]:http://blog.itpub.net/26736162/viewspace-2144770/ SQL?Server连接SQL?Server、SQL?Server连接ORACLE?链接服务器:http://blog.itpub.net/26736162/viewspace-2144712/ Oracle连接MongoDB数据库:http://blog.itpub.net/26736162/viewspace-2144709/ MySQL索引之全文索引(FULLTEXT):http://blog.itpub.net/26736162/viewspace-2144690/ 如何让普通用户可以对DBA_SOURCE视图进行闪回查询?:http://blog.itpub.net/26736162/viewspace-2144687/ MySQL索引之空间索引(SPATIAL):http://blog.itpub.net/26736162/viewspace-2144682/ MySQL索引之哈希索引和自适应哈希索引(Adaptive?Hash?Index):http://blog.itpub.net/26736162/viewspace-2144680/ [Oracle->?MySQL]?Oracle通过dblink连接MySQL:http://blog.itpub.net/26736162/viewspace-2144661/ MySQL之mysqlcheck、check、optimize和analyze:http://blog.itpub.net/26736162/viewspace-2144629/ MySQL前缀索引和索引选择性:http://blog.itpub.net/26736162/viewspace-2144621/ MySQL示例数据库sakila-db的安装导入:http://blog.itpub.net/26736162/viewspace-2144611/ MySQL中的索引:http://blog.itpub.net/26736162/viewspace-2144556/ Oracle获取绑定变量的各种方法:http://blog.itpub.net/26736162/viewspace-2144519/ MySQL字符集和校对规则(Collation):http://blog.itpub.net/26736162/viewspace-2144469/ MySQL??InnoDB?共享表空间和独立表空间:http://blog.itpub.net/26736162/viewspace-2144443/ MySQL中的数据类型:http://blog.itpub.net/26736162/viewspace-2144417/ MySQL中的运算符:http://blog.itpub.net/26736162/viewspace-2144415/ MySQL常用函数:http://blog.itpub.net/26736162/viewspace-2144414/ 【故障处理】EXP-00003:?no?storage?definition?found?for?segment:http://blog.itpub.net/26736162/viewspace-2144392/ 【OCM】Oracle?11g?OCM?考试大纲:http://blog.itpub.net/26736162/viewspace-2144375/ MySQL之SHOW?TABLE?STATUS命令:http://blog.itpub.net/26736162/viewspace-2144284/ MySQL覆盖索引(Covering?Index):http://blog.itpub.net/26736162/viewspace-2144269/ 【MySQL】 Linux 下MySQL?5.5、5.6和5.7的RPM、二进制和源码安装:http://blog.itpub.net/26736162/viewspace-2144261/ Mysql?5.7.19三种安装方式手册:http://blog.itpub.net/26736162/viewspace-2144212/ MySQL多实例管理(mysqld_multi):http://blog.itpub.net/26736162/viewspace-2144199/ 批量杀死MySQL连接的几种方法详解:http://blog.itpub.net/26736162/viewspace-2144194/ MySQL?show?processlist命令详解及查看当前连接数:http://blog.itpub.net/26736162/viewspace-2144193/ 如何在MySQL中查询OS线程id(LWP)?:http://blog.itpub.net/26736162/viewspace-2144192/ MySQL中show命令用法大全:http://blog.itpub.net/26736162/viewspace-2144191/ Linux 中线程和进程的区别:http://blog.itpub.net/26736162/viewspace-2144188/ MySQL分布式事务(XA事务):http://blog.itpub.net/26736162/viewspace-2144135/ Navicat?提示Cannot?create?oci?environment?解决方案:http://blog.itpub.net/26736162/viewspace-2144077/ MySQL中事务的分类:http://blog.itpub.net/26736162/viewspace-2144050/ [Warning]?Using?a?password?on?the?command?line?interface?can?be?insecure.:http://blog.itpub.net/26736162/viewspace-2144047/ MySQL文件概述:http://blog.itpub.net/26736162/viewspace-2144040/ MySQL数据库的套接字文件和pid文件:http://blog.itpub.net/26736162/viewspace-2144037/ MySQL默认数据库介绍:http://blog.itpub.net/26736162/viewspace-2144018/ MySQL远程连接ERROR?2003?(HY000)?Cant?connect?to?MySQL?server?on?(10060):http://blog.itpub.net/26736162/viewspace-2144012/ ERROR?2002?(HY000):?Cant?connect?to?local?MySQL?server?through?socket的解决方法:http://blog.itpub.net/26736162/viewspace-2144007/ ?MySQL?5.7?SYS?SCHEMA:http://blog.itpub.net/26736162/viewspace-2143988/ ? Linux 文件与目录的三种时间状态(mtime,atime,ctime)区别:http://blog.itpub.net/26736162/viewspace-2143962/ MySQL存储引擎:http://blog.itpub.net/26736162/viewspace-2143926/ 【存储】裸设备和Oracle:http://blog.itpub.net/26736162/viewspace-2143756/ DBA学习书籍推荐:http://blog.itpub.net/26736162/viewspace-2143446/ Oracle?11gR2新特性--延迟段创建(Deferred?Segment?Creation)和exp不能导出空表:http://blog.itpub.net/26736162/viewspace-2143238/ 盘点?Oracle?11g?中新特性带来的10大性能影响:http://blog.itpub.net/26736162/viewspace-2143222/ 在MySQL中如何有效的删除一个大表?:http://blog.itpub.net/26736162/viewspace-2143135/ MySQL备份:http://blog.itpub.net/26736162/viewspace-2143129/ MySQL分区表:http://blog.itpub.net/26736162/viewspace-2143125/ MySQL修改提示符(prompt):http://blog.itpub.net/26736162/viewspace-2143124/ 如何格式化不属于任何段的损坏块?(文档?ID?1526163.1):http://blog.itpub.net/26736162/viewspace-2143111/ Oracle?分页方法研究:http://blog.itpub.net/26736162/viewspace-2143110/ 实用的 Linux 命令行技巧:http://blog.itpub.net/26736162/viewspace-2143109/ 密码错误频繁登录引发的“library?cache?lock”或“row?cache?lock”等待:http://blog.itpub.net/26736162/viewspace-2143106/ ?Oracle?User?和?Schema?的区别:http://blog.itpub.net/26736162/viewspace-2143101/ SQL?Server中的临时表:http://blog.itpub.net/26736162/viewspace-2143061/ MVCC(Multi-Version?Concurrent?Control,多版本并发控制)简介:http://blog.itpub.net/26736162/viewspace-2143025/ 【锁】MySQL间隙锁:http://blog.itpub.net/26736162/viewspace-2143009/ MySQL中的几类日志文件介绍:http://blog.itpub.net/26736162/viewspace-2142929/ Linux 如何查看JDK的安装路径:http://blog.itpub.net/26736162/viewspace-2142928/ SQL?Server中的页和区:http://blog.itpub.net/26736162/viewspace-2142922/ CAP定理:http://blog.itpub.net/26736162/viewspace-2142893/ MySQL5.6?GTID:http://blog.itpub.net/26736162/viewspace-2142792/ 从MySQL全库备份中恢复某个库和某张表:http://blog.itpub.net/26736162/viewspace-2142784/ MySQL之权限管理:http://blog.itpub.net/26736162/viewspace-2142783/ MySQL笔试面试题集合:http://blog.itpub.net/26736162/viewspace-2142764/ 区块链技术简介:http://blog.itpub.net/26736162/viewspace-2142749/ NewSQL数据库简介:http://blog.itpub.net/26736162/viewspace-2142748/ Windows?下?tail?查看日志命令工具:http://blog.itpub.net/26736162/viewspace-2142743/ 【虚拟机】如何判断CPU是否支持硬件虚拟化:http://blog.itpub.net/26736162/viewspace-2142719/ 【OS】AIX之topas命令详解:http://blog.itpub.net/26736162/viewspace-2142706/ 【OS】 Linux 如何关闭防火墙:http://blog.itpub.net/26736162/viewspace-2142703/ 【OS】 Linux 环境下配置固定IP地址--静态IP地址(不能上外网问题):http://blog.itpub.net/26736162/viewspace-2142702/ 【 Linux 】定时任务crontab和at命令详解:http://blog.itpub.net/26736162/viewspace-2142694/ 【OS】 Linux 和AIX修改主机名的方法:http://blog.itpub.net/26736162/viewspace-2142676/ 【OS】 Linux 命令如何放到后台运行:http://blog.itpub.net/26736162/viewspace-2142674/ 【OS】什么是YUM?如何配置本地YUM源?:http://blog.itpub.net/26736162/viewspace-2142670/ 【OS】 Linux 下?/dev?常见特殊设备介绍与应用[loop]:http://blog.itpub.net/26736162/viewspace-2142668/ 小麦苗博客用到的图片:http://blog.itpub.net/26736162/viewspace-2142651/ Linux ?系统下查看硬件信息命令大全:http://blog.itpub.net/26736162/viewspace-2142641/ 80?多个? Linux ?系统管理员必备的监控工具:http://blog.itpub.net/26736162/viewspace-2142640/ 【OS】 Linux 下/dev/shm的作用及ORA-00845错误的处理:http://blog.itpub.net/26736162/viewspace-2142633/ 【OS】OSWbb(OSWatcher?Black?Box)的简介和使用:http://blog.itpub.net/26736162/viewspace-2142613/ 利用Oracle?RDA(?Remote?Diagnostic?Agent)快速收集Oracle产品分析数据?:http://blog.itpub.net/26736162/viewspace-2142607/ Oratop工具——实时数据库性能监控工具?:http://blog.itpub.net/26736162/viewspace-2142602/ 【OS】NMON的简介和使用:http://blog.itpub.net/26736162/viewspace-2142585/ 【AIX】AIX内存机制:http://blog.itpub.net/26736162/viewspace-2142574/ 【RAC】参数CLUSTER_INTERCONNECTS:http://blog.itpub.net/26736162/viewspace-2142556/ ORAchk-数据库健康检查?:http://blog.itpub.net/26736162/viewspace-2142555/ 【AIX】LPar分区技术、逻辑CPU、虚拟CPU、物理CPU:http://blog.itpub.net/26736162/viewspace-2142551/ 【存储】AIX存储管理基本概念和操作(LVM):http://blog.itpub.net/26736162/viewspace-2142546/ 【存储】RAID?技术介绍和总结:http://blog.itpub.net/26736162/viewspace-2142521/ 【会话】V$SESSION视图:http://blog.itpub.net/26736162/viewspace-2142504/ Oracle?Data?Recovery?Advisor(DRA)?数据恢复顾问:http://blog.itpub.net/26736162/viewspace-2142502/ 【Tomcat】Tomcat的使用:http://blog.itpub.net/26736162/viewspace-2142487/ Oracle?ACFS、ADVM:http://blog.itpub.net/26736162/viewspace-2142483/ 【RMAN】RMAN恢复各类错误解决总结:http://blog.itpub.net/26736162/viewspace-2142480/ 【JOB】Oracle?JOB全面学习(DBMS_JOB和DBMS_SCHEDULER):http://blog.itpub.net/26736162/viewspace-2142477/ Oracle10g新增DBMS_MONITOR包:http://blog.itpub.net/26736162/viewspace-2142442/ 【OGG】OGG故障错误处理总结:http://blog.itpub.net/26736162/viewspace-2142440/ ORA-08104:?该索引对象68100正在被联机建立或重建:http://blog.itpub.net/26736162/viewspace-2142437/ 聚集索引和非聚集索引:http://blog.itpub.net/26736162/viewspace-2142434/ 【三思笔记】?全面学习Oracle分区表及分区索引:http://blog.itpub.net/26736162/viewspace-2142424/ MySQL大表优化方案:http://blog.itpub.net/26736162/viewspace-2142421/ SQL?Server事务隔离级别详解:http://blog.itpub.net/26736162/viewspace-2142403/ 【存储】GPFS简介及搭建:http://blog.itpub.net/26736162/viewspace-2142397/ 【DBA?|?IT人生】数据库解惑系列:http://blog.itpub.net/26736162/viewspace-2142388/ Oracle?正则表达式:http://blog.itpub.net/26736162/viewspace-2142367/ Redis和Memcached的区别:http://blog.itpub.net/26736162/viewspace-2142359/ Oracle数据库安全管理:http://blog.itpub.net/26736162/viewspace-2142356/ Oracle和MySQL分组查询GROUP?BY:http://blog.itpub.net/26736162/viewspace-2142345/ 【ASM】多路径(multipath)简介及配置:http://blog.itpub.net/26736162/viewspace-2142338/ 涂抹MySQL自序?-?轮扁斫轮:http://blog.itpub.net/26736162/viewspace-2142331/ 【AIX】AIX中级试题:http://blog.itpub.net/26736162/viewspace-2142311/ 【DG】Oracle?Data?Guard官方直译:http://blog.itpub.net/26736162/viewspace-2142310/ Oracle?10gR2分析函数汇总:http://blog.itpub.net/26736162/viewspace-2142309/ dd命令详解:http://blog.itpub.net/26736162/viewspace-2142306/ 【sqlplus】SQL*Plus命令使用大全:http://blog.itpub.net/26736162/viewspace-2142298/ 【安装】 linux系统 (X64)安装Oracle?11g:http://blog.itpub.net/26736162/viewspace-2142291/ 【安装】Windows下Oracle安装图解----oracle-win-64-11g?详细安装步骤:http://blog.itpub.net/26736162/viewspace-2142290/ 数据库的范式和反范式设计:http://blog.itpub.net/26736162/viewspace-2142253/ 【书】《数据库面试笔试宝典系列》简介:http://blog.itpub.net/26736162/viewspace-2142121/ 【RAC】RAC中的负载均衡和故障切换--TAF配置:http://blog.itpub.net/26736162/viewspace-2142102/ 【锁】Latch、lock、?pin的区别:http://blog.itpub.net/26736162/viewspace-2142070/ Oracle的commit做了什么?:http://blog.itpub.net/26736162/viewspace-2141922/ 数值在Oracle的内部存储:http://blog.itpub.net/26736162/viewspace-2141917/ ORA-12560:?TNS:?协议适配器错误??常见原因:http://blog.itpub.net/26736162/viewspace-2141873/ Oracle?Namespace?说明:http://blog.itpub.net/26736162/viewspace-2141869/ Oracle常见问题一千问:http://blog.itpub.net/26736162/viewspace-2141868/ SQLite快速入门教程及全面学习:http://blog.itpub.net/26736162/viewspace-2141867/ 如何解决Oracle?GoldenGate?没有主键的问题?:http://blog.itpub.net/26736162/viewspace-2141852/ 【MySQL】MySQL的四种事务隔离级别:http://blog.itpub.net/26736162/viewspace-2141789/ 【OGG】关于在一套复制环境中使用不同版本OGG的问题:http://blog.itpub.net/26736162/viewspace-2141788/ 【题库】Oracle开发类笔试面试题集:http://blog.itpub.net/26736162/viewspace-2141783/ 【恢复】Redo日志文件丢失的恢复:http://blog.itpub.net/26736162/viewspace-2141732/ Oracle数据库体系结构理论:http://blog.itpub.net/26736162/viewspace-2141662/ COUNT(*)计算行数有哪些优化手段:http://blog.itpub.net/26736162/viewspace-2141601/ SQL性能健康检查脚本?(SQLHC)(文档?ID?1626277.1):http://blog.itpub.net/26736162/viewspace-2141559/ Oracle诊断工具SQLT简介?(文档?ID?1677588.1、1526574.1):http://blog.itpub.net/26736162/viewspace-2141558/ 【OGG】OGG基础知识整理:http://blog.itpub.net/26736162/viewspace-2141550/ 数据库之Oracle笔试面试题收集(来自网络):http://blog.itpub.net/26736162/viewspace-2141548/ Oracle?EBS基础:http://blog.itpub.net/26736162/viewspace-2141523/ Oracle执行计划filter下多个节点的优化:http://blog.itpub.net/26736162/viewspace-2141522/ 【体系结构】Oracle数据块详解:http://blog.itpub.net/26736162/viewspace-2141499/ Oracle数据库的整体结构:http://blog.itpub.net/26736162/viewspace-2141498/ 事务的4个特性——ACID(原子性、一致性、隔离性和持久性)、更新丢失问题:http://blog.itpub.net/26736162/viewspace-2141490/ 自动段空间管理(ASSM)和?手动段空间管理(MSSM):http://blog.itpub.net/26736162/viewspace-2141407/ 索引重建的必要性与影响?(文档?ID?1525787.1):http://blog.itpub.net/26736162/viewspace-2141341/ ?NULL?值与索引:http://blog.itpub.net/26736162/viewspace-2141337/ Oracle的一些基本索引:http://blog.itpub.net/26736162/viewspace-2141332/ 【SQL?Profile】coe_xfr_sql_profile.sql内容:http://blog.itpub.net/26736162/viewspace-2141322/ 【DBA】?Oracle?学习路线:http://blog.itpub.net/26736162/viewspace-2141277/ Oracle大表清理truncate?..?reuse?storage:http://blog.itpub.net/26736162/viewspace-2141248/ 【RAC】Oracle?11gR2?RAC?中的?Grid?Plug?and?Play(GPnP)?是什么?:http://blog.itpub.net/26736162/viewspace-2141232/ 【RAC】RAC相关基础知识:http://blog.itpub.net/26736162/viewspace-2141231/ 【ASM】ASM基础知识:http://blog.itpub.net/26736162/viewspace-2141229/ ASM管理命令行三工具:KFOD、KFED和AMDU:http://blog.itpub.net/26736162/viewspace-2141226/ 【RAC】11g?R2?RAC新特性之Highly?Available?IP(HAIP)?:http://blog.itpub.net/26736162/viewspace-2141223/ 【MOS】如何诊断?11.2?集群节点驱逐问题?(文档?ID?1674872.1):http://blog.itpub.net/26736162/viewspace-2141216/ 【MOS】OCR/Vote?disk?维护操作:?(添加/删除/替换/移动)?(文档?ID?1674859.1):http://blog.itpub.net/26736162/viewspace-2141215/ 【MOS】RAC?环境中?gc?block?lost?和私网通信性能问题的诊断?(文档?ID?1674865.1):http://blog.itpub.net/26736162/viewspace-2141214/ Oracle性能调整的三把利剑--ASH,AWR,ADDM:http://blog.itpub.net/26736162/viewspace-2141208/ 【DG】DG之Switchover和Failover的区别:http://blog.itpub.net/26736162/viewspace-2141207/ 【DG】DG概念原理详解:http://blog.itpub.net/26736162/viewspace-2141206/ 【DG】DG环境的日常巡检:http://blog.itpub.net/26736162/viewspace-2141205/ 【DG】DG日常维护:http://blog.itpub.net/26736162/viewspace-2141204/ 【DG】?DataGuard?中处理archive?gap的方法:http://blog.itpub.net/26736162/viewspace-2141203/ 【DG】[三思笔记]一步一步学DataGuard:http://blog.itpub.net/26736162/viewspace-2141202/ 【DG】DG的3种保护模式:http://blog.itpub.net/26736162/viewspace-2141200/ 【体系结构】Oracle重做日志文件(Redo?Log?Files):http://blog.itpub.net/26736162/viewspace-2141163/ Oracle日志挖掘之LogMiner:http://blog.itpub.net/26736162/viewspace-2141148/ Oracle全局临时表:http://blog.itpub.net/26736162/viewspace-2140960/ 实例恢复(Instance?Recovery)之前滚(Rolling?Forward)和回滚(Rolling?Back):http://blog.itpub.net/26736162/viewspace-2140915/ Oracle增量备份和快速备份(块改变跟踪Block?Change?Tracking):http://blog.itpub.net/26736162/viewspace-2140902/ 用户表空间配额(User?tablespace?Quota):http://blog.itpub.net/26736162/viewspace-2140868/ shared?pool?latch和library?cache?latch:http://blog.itpub.net/26736162/viewspace-2140857/ 库缓存(Library?Cache)内存结构:http://blog.itpub.net/26736162/viewspace-2140856/ Oracle的对象权限、角色权限、系统权限:http://blog.itpub.net/26736162/viewspace-2140775/ Oracle?定义者权限与调用者权限(AUTHID?CURRENT_USER):http://blog.itpub.net/26736162/viewspace-2140774/ Oracle角色权限之Default?Role?:http://blog.itpub.net/26736162/viewspace-2140769/ Oracle的簇与簇表:http://blog.itpub.net/26736162/viewspace-2140737/ Oracle几种表的优缺点总结:http://blog.itpub.net/26736162/viewspace-2140734/ 深入解析:由SQL解析失败看开发与DBA的性能之争:http://blog.itpub.net/26736162/viewspace-2140725/ Oracle中的优化器--CBO和RBO:http://blog.itpub.net/26736162/viewspace-2140698/ Oracle审计功能:http://blog.itpub.net/26736162/viewspace-2140644/ Oracle?ADDM?--dbms_addm执行oracle数据库诊断?:http://blog.itpub.net/26736162/viewspace-2140642/ ?使用NID修改DBID和DBNAME实验:http://blog.itpub.net/26736162/viewspace-2140640/ SET?UNUSED列可以恢复吗??:http://blog.itpub.net/26736162/viewspace-2140639/ 使用隐含Trace参数诊断Oracle?Data?Pump(expdp)故障?:http://blog.itpub.net/26736162/viewspace-2140637/ Oracle?DG(Data?Guard)支持异构平台说明?:http://blog.itpub.net/26736162/viewspace-2140635/ Oracle?Temp临时表空间及其故障处理?:http://blog.itpub.net/26736162/viewspace-2140629/ Oracle分批提交DML?:http://blog.itpub.net/26736162/viewspace-2140626/ 【MOS】Limitations?of?the?Oracle?Cost?Based?Optimizer?(文档?ID?212809.1):http://blog.itpub.net/26736162/viewspace-2140620/ 踩坑CBO,解决那些坑爹的SQL优化问题:http://blog.itpub.net/26736162/viewspace-2140619/ Oracle?CBO几种基本的查询转换详解:http://blog.itpub.net/26736162/viewspace-2140618/ Oracle结果集缓存(Result?Cache)--服务器、客户端、函数缓存:http://blog.itpub.net/26736162/viewspace-2140589/ Oracle游标共享(Cursor?Sharing)--常规游标共享和自适应游标共享(ACS):http://blog.itpub.net/26736162/viewspace-2140584/ Oracle绑定变量分级(Bind?Graduation):http://blog.itpub.net/26736162/viewspace-2140560/ Oracle?隐含参数:http://blog.itpub.net/26736162/viewspace-2140539/ Oracle中的游标、硬解析、软解析、软软解析、解析失败:http://blog.itpub.net/26736162/viewspace-2140502/ CBO中基数(cardinality)、可选择率(selectivity)的计算公式:http://blog.itpub.net/26736162/viewspace-2140358/ LOW_VALUE、HIGH_VALUE、ENDPOINT_VALUE转换--UTL_RAW、DBMS_STATS.CONVERT_RAW_VALUE:http://blog.itpub.net/26736162/viewspace-2140335/ ?11gR2?新特性--待定的统计信息(Pending?Statistic):http://blog.itpub.net/26736162/viewspace-2140300/ [参考文档]?[翻译]Oracle?12c?R2优化器白皮书:http://blog.itpub.net/26736162/viewspace-2140289/ 使用TWO_TASK或者LOCAL环境变量:http://blog.itpub.net/26736162/viewspace-2140246/ 收集统计信息的SQL脚本(sosi.sql)--崔华大师:http://blog.itpub.net/26736162/viewspace-2140227/ Oracle收集统计信息:http://blog.itpub.net/26736162/viewspace-2140225/ Oracle系统统计信息:http://blog.itpub.net/26736162/viewspace-2140215/ 基数反馈(Cardinality?Feedback):http://blog.itpub.net/26736162/viewspace-2140200/ High?Version?Count(高版本游标)数目过多诊断的方法?:http://blog.itpub.net/26736162/viewspace-2140136/ Oracle?外部表?:http://blog.itpub.net/26736162/viewspace-2140135/ 从五个SQL看with?as使用?:http://blog.itpub.net/26736162/viewspace-2140134/ Oracle变异表解决方法--ORA-04091错误:http://blog.itpub.net/26736162/viewspace-2140133/ Oracle?物理读?逻辑读?一致性读?当前模式读总结浅析:http://blog.itpub.net/26736162/viewspace-2140132/ Oracle?12c?新SQL提示(hint):http://blog.itpub.net/26736162/viewspace-2140051/ WORKAREA_SIZE_POLICY参数引起的ORA-04030错误:http://blog.itpub.net/26736162/viewspace-2139825/ 等待事件之Row?Cache?Lock:http://blog.itpub.net/26736162/viewspace-2139754/ 数据库的三种状态RESTRICT、QUIESCE和SUSPEND:http://blog.itpub.net/26736162/viewspace-2139738/ Oracle数据坏块简介及其恢复(dbv、BMR):http://blog.itpub.net/26736162/viewspace-2139709/ DG参数?LOG_ARCHIVE_DEST_n:http://blog.itpub.net/26736162/viewspace-2139647/ Oracle实例囚笼(Instance?Caging):http://blog.itpub.net/26736162/viewspace-2139639/ 【RAC】Oracle集群心跳及其参数misscount/disktimeout/reboottime:http://blog.itpub.net/26736162/viewspace-2139636/ 应用ROWDEPENDENCIES行级跟踪,查询oracle表中数据行上最后的DML时间:http://blog.itpub.net/26736162/viewspace-2139595/ Oracle??降低高水位线的方法?:http://blog.itpub.net/26736162/viewspace-2139546/ Oracle收集统计信息之NO_INVALIDATE参数:http://blog.itpub.net/26736162/viewspace-2139300/ Oracle多列统计信息:http://blog.itpub.net/26736162/viewspace-2139297/ Oracle直方图:http://blog.itpub.net/26736162/viewspace-2139293/ Oracle动态采样分析:http://blog.itpub.net/26736162/viewspace-2139284/ 能够管理ASM?instance的三种角色:http://blog.itpub.net/26736162/viewspace-2139269/ Oracle之虚拟列及虚拟列索引:http://blog.itpub.net/26736162/viewspace-2139258/ Oracle?索引扫描的五种类型:http://blog.itpub.net/26736162/viewspace-2139246/ Oracle索引分裂(Index?Block?Split):http://blog.itpub.net/26736162/viewspace-2139232/ Oracle聚簇因子(Clustering?factor,CF):http://blog.itpub.net/26736162/viewspace-2139229/ Oracle数据库的字符集更改:http://blog.itpub.net/26736162/viewspace-2139179/ ?Oracle?参数文件(spfile和pfile):http://blog.itpub.net/26736162/viewspace-2139146/ ?Oracle?数据库实例启动关闭过程:http://blog.itpub.net/26736162/viewspace-2139136/ 行链接(Row?Chaining)和行迁移(Row?Migration):http://blog.itpub.net/26736162/viewspace-2139126/ Oracle?Lob类型存储浅析:http://blog.itpub.net/26736162/viewspace-2139045/ SQL使用模糊查询like的优化:http://blog.itpub.net/26736162/viewspace-2139039/ Oracle全文索引:http://blog.itpub.net/26736162/viewspace-2139034/ Oracle?反向键索引的原理和用途(减少索引热点块):http://blog.itpub.net/26736162/viewspace-2139025/ oracle?索引压缩:http://blog.itpub.net/26736162/viewspace-2139022/ Hash?Cluster?Table?研究:http://blog.itpub.net/26736162/viewspace-2139016/ 使用位图连接索引优化OLAP查询:http://blog.itpub.net/26736162/viewspace-2139014/ 【exp/imp】将US7ASCII字符集的dmp文件导入到ZHS16GBK字符集的数据库中:http://blog.itpub.net/26736162/viewspace-2138791/ 【MOS】Parameter?FILESIZE?-??Multiple?Export?Files?(文档?ID?290810.1):http://blog.itpub.net/26736162/viewspace-2138759/ Alert?Log中“Fatal?NI?connect?error?12170”错误:http://blog.itpub.net/26736162/viewspace-2138674/ Oracle?ASMM和AMM:http://blog.itpub.net/26736162/viewspace-2138627/ Oracle内存分配中的子池(Subpool)--ORA-04031:http://blog.itpub.net/26736162/viewspace-2138626/ 物化视图快速刷新报?ORA-12008?&?ORA-01031:http://blog.itpub.net/26736162/viewspace-2138546/ 再次遇到ORA-04030的错误:http://blog.itpub.net/26736162/viewspace-2138404/ ORA-04031错误:http://blog.itpub.net/26736162/viewspace-2138388/ ORA-04030错误:http://blog.itpub.net/26736162/viewspace-2138387/ ?Windows10开机自动运行批处理、脚本等的方法:http://blog.itpub.net/26736162/viewspace-2138323/ 专用服务器模式(MTS)和共享服务器模式:http://blog.itpub.net/26736162/viewspace-2138307/ 【MOS】零宕机迁移ASM磁盘组到另一个SAN/磁盘阵列/DAS的准确步骤?(文档?ID?1946664.1):http://blog.itpub.net/26736162/viewspace-2137830/ Oracle归档模式和非归档模式:http://blog.itpub.net/26736162/viewspace-2137829/ 绑定变量优缺点、使用、绑定变量窥探、?Oracle自适应共享游标:http://blog.itpub.net/26736162/viewspace-2137446/ 如何保持Oracle数据库SQL性能的稳定性:http://blog.itpub.net/26736162/viewspace-2137377/ Windows下进程占用CPU过大的解决方案:http://blog.itpub.net/26736162/viewspace-2137272/ TNS-01190:?The?user?is?not?authorized?to?execute?the?requested?listener?command:http://blog.itpub.net/26736162/viewspace-2137249/ Oracle用SQL打印日历:http://blog.itpub.net/26736162/viewspace-2137224/ Oracle分区技术--?interval?parition实验及总结:http://blog.itpub.net/26736162/viewspace-2137151/ Oracle数据库服务器IO高的分析方案和案例探讨:http://blog.itpub.net/26736162/viewspace-2137141/ 【分析函数】Oracle分析函数之LAG和LEAD:http://blog.itpub.net/26736162/viewspace-2137138/ 退出exp、imp、telnet等等交互窗口:http://blog.itpub.net/26736162/viewspace-2137132/ Oracle体系结构之内存结构(SGA、PGA)?:http://blog.itpub.net/26736162/viewspace-2137064/ Oracle?MTS简介:http://blog.itpub.net/26736162/viewspace-2137061/ 【MOS】EVENT:?DROP_SEGMENTS?-?cleanup?of?TEMPORARY?segments?(文档?ID?47400.1):http://blog.itpub.net/26736162/viewspace-2137022/ 如何更改图片的背景色(PS、证件照之星):http://blog.itpub.net/26736162/viewspace-2136976/ Oracle查看执行计划的几种方法:http://blog.itpub.net/26736162/viewspace-2136865/ 【OERR】?oerr?ora?错误?11.2.0.3?【20000-64307】:http://blog.itpub.net/26736162/viewspace-2136864/ 【OERR】?oerr?ora?错误?11.2.0.3?【00000-19999】:http://blog.itpub.net/26736162/viewspace-2136862/ 【OERR】?oerr?ora?错误??12.2.0.1??【40000-65535】:http://blog.itpub.net/26736162/viewspace-2136857/ 【OERR】?oerr?ora?错误??12.2.0.1??【20000-39999】:http://blog.itpub.net/26736162/viewspace-2136856/ 【MOS】关于events的几篇MOS(75713.1、160178.1、436036.1、1051056.6):http://blog.itpub.net/26736162/viewspace-2136855/ 【OERR】?oerr?ora?错误?12.2.0.1【00000-19999】:http://blog.itpub.net/26736162/viewspace-2136851/ 【OERR】?oerr?ora?错误??10.2.0.1:http://blog.itpub.net/26736162/viewspace-2136848/ ORA-00600:??[keltnfy-ldmInit],?[46],?[1],?[],?[],?[],?[],?[]:http://blog.itpub.net/26736162/viewspace-2136844/ 循序渐进讲解Oracle数据库的完整性概念:http://blog.itpub.net/26736162/viewspace-2136777/ 【DG】搭建DG时报错:ORA-01017、ORA-17627、ORA-17629?invalid?username/password:http://blog.itpub.net/26736162/viewspace-2136553/ Oracle闪回(flashback)功能详解??闪回数据归档(Flashback?Data?Archive):http://blog.itpub.net/26736162/viewspace-2136497/ 【DG】DBMS_LOGSTDBY包的应用--逻辑DG跳过某些操作:http://blog.itpub.net/26736162/viewspace-2136495/ 11g?逻辑备库简单故障处理:http://blog.itpub.net/26736162/viewspace-2136491/ 使用ErrorStack进行错误跟踪及诊断:http://blog.itpub.net/26736162/viewspace-2136457/ Oracle11gR2集群心跳单网卡改bond实施方案:http://blog.itpub.net/26736162/viewspace-2136412/ cluvfy(Cluster?Verification?Utility,集群检验工具),简称CVU,cvuqdisk包:http://blog.itpub.net/26736162/viewspace-2136390/ 【优化】COUNT(1)、COUNT(*)、COUNT(常量)、COUNT(主键)、COUNT(ROWID)等:http://blog.itpub.net/26736162/viewspace-2136339/ Oracle事件之10053?跟踪的trace文件相关解释:http://blog.itpub.net/26736162/viewspace-2136332/ Oracle?事件之10046?跟踪的trace文件相关解释?tkprof:http://blog.itpub.net/26736162/viewspace-2136330/ SQL?Plan?Management介绍:http://blog.itpub.net/26736162/viewspace-2136294/ 使用DBLINK查询时报ORA-00600:?internal?error?code,?arguments:?[kzdlk_zt2?err]?:http://blog.itpub.net/26736162/viewspace-2136281/ SQL优化:组内排序取最大值:http://blog.itpub.net/26736162/viewspace-2136211/ V$LOG的底层表之X$KCCLE深入剖析:http://blog.itpub.net/26736162/viewspace-2136095/ 如何查看操作系统的块大小:http://blog.itpub.net/26736162/viewspace-2136094/ Supported?Platforms:?MySQL?Database??MySQL安装支持的平台:http://blog.itpub.net/26736162/viewspace-2136083/ MySQL在Windows上安装多个实例的方法:http://blog.itpub.net/26736162/viewspace-2136081/ Oracle中序列(Sequence)详解:http://blog.itpub.net/26736162/viewspace-2136049/ Oracle?hint之DRIVING_SITE:http://blog.itpub.net/26736162/viewspace-2135973/ Oracle所有诊断事件列表events:http://blog.itpub.net/26736162/viewspace-2135959/ 用SQL命令查看Mysql数据库大小:http://blog.itpub.net/26736162/viewspace-2135954/ Windows下?MySQL-5.7.11?安装与配置:http://blog.itpub.net/26736162/viewspace-2135953/ Win7完全卸载MySQL的步骤:http://blog.itpub.net/26736162/viewspace-2135952/ Linux 卸载MySQL:http://blog.itpub.net/26736162/viewspace-2135951/ 解决“指定的服务已经标记为删除”问题:http://blog.itpub.net/26736162/viewspace-2135949/ MySQL中xtrabackup备份恢复全攻略:http://blog.itpub.net/26736162/viewspace-2135948/ MySQL中大小写问题:http://blog.itpub.net/26736162/viewspace-2135882/ MySQL查看当前使用的配置文件my.cnf的方法:http://blog.itpub.net/26736162/viewspace-2135880/ MySQL?5.6所有系统变量(系统参数):http://blog.itpub.net/26736162/viewspace-2135875/ 远程连接MySQL数据库提示:ERROR?1130?(HY000)的解决办法:http://blog.itpub.net/26736162/viewspace-2135829/ Windows环境下MySQL5.7中文显示乱码的三种解决方案:http://blog.itpub.net/26736162/viewspace-2135824/ 老程序员的思想变迁:http://blog.itpub.net/26736162/viewspace-2135803/ SQL?Server阻塞查询语句?:http://blog.itpub.net/26736162/viewspace-2135726/ 无法打开到SQL?Server的连接?(Microsoft?SQL?Server,?错误:53)?.:http://blog.itpub.net/26736162/viewspace-2135723/ MySQL使用profile分析语句性能消耗?:http://blog.itpub.net/26736162/viewspace-2135700/ Oracle?Q-quote?delimiter??Quote(q)?字符串原样输出:http://blog.itpub.net/26736162/viewspace-2135631/ ?DBMS_APPLICATION_INFO包的使用:http://blog.itpub.net/26736162/viewspace-2135626/ SQL*Plus中plustrce.sql(SP2-0613、SP2-0611)和(SP2-0618、SP2-0611):http://blog.itpub.net/26736162/viewspace-2135621/ 【方法】如何限定IP访问Oracle数据库:http://blog.itpub.net/26736162/viewspace-2135609/ Oracle?中的userenv():http://blog.itpub.net/26736162/viewspace-2135554/ 说说sys_context函数:http://blog.itpub.net/26736162/viewspace-2135551/ ORACLE?存储过程中的Authid?Current_User:http://blog.itpub.net/26736162/viewspace-2135496/ Authid?Current_User的使用:http://blog.itpub.net/26736162/viewspace-2135495/ 【方法】Oracle用户密码含特殊字符时的登陆问题:http://blog.itpub.net/26736162/viewspace-2135493/ 【故障|监听】TNS-12518、TNS-00517和? Linux ?Error:32:Broken?pipe:http://blog.itpub.net/26736162/viewspace-2135468/ timesten常见的一些简单问题:http://blog.itpub.net/26736162/viewspace-2135438/ TimesTen学习(四)Data?Manager守护进程:http://blog.itpub.net/26736162/viewspace-2135437/ TimesTen学习(三)远程连接TimesTen数据库:http://blog.itpub.net/26736162/viewspace-2135436/ TimesTen学习(二)连接创建第一个数据库:http://blog.itpub.net/26736162/viewspace-2135435/ TimesTen学习(一)安装篇:http://blog.itpub.net/26736162/viewspace-2135434/ 【ASM】udev简介及配置、多路径(multipath)等:http://blog.itpub.net/26736162/viewspace-2135271/ Oracle环境变量、监听listener.ora、tnsnames.ora、sqlnet.ora配置:http://blog.itpub.net/26736162/viewspace-2135163/ ORA-28547?连接服务器失败,可能是Oracle?Net?管理错误:http://blog.itpub.net/26736162/viewspace-2135162/ Java笔试面试题合集:http://blog.itpub.net/26736162/viewspace-2135149/ 博客园(cnblogs)右侧添加悬浮打赏功能:http://blog.itpub.net/26736162/viewspace-2135148/ lsnrctl启动报错, Linux ?Error:?29:?Illegal?seek:http://blog.itpub.net/26736162/viewspace-2135077/ [FATAL]?[DBT-10317]?Specified?SID?Name?(lhr122)?already?exists.:http://blog.itpub.net/26736162/viewspace-2135035/ Oracle?11gR2?restart?单机使用asm存储?主机名发生更改处理过程?(文档?ID?986740.1):http://blog.itpub.net/26736162/viewspace-2135034/ ?【DG】怎么使用Data?Pump备份物理备库:http://blog.itpub.net/26736162/viewspace-2135025/ MySQL数据库常见错误及解决方案:http://blog.itpub.net/26736162/viewspace-2134960/ 【ROLLUP】Oracle分组函数之ROLLUP魅力:http://blog.itpub.net/26736162/viewspace-2134748/ 数据库笔试面试题库(Oracle、MySQL等):http://blog.itpub.net/26736162/viewspace-2134706/ PLSQL?Developer软件使用大全:http://blog.itpub.net/26736162/viewspace-2134628/ HugePages??大内存页:http://blog.itpub.net/26736162/viewspace-2134314/ ?Oracle并发(CONCURREMT)收集统计信息?(文档?ID?1555451.1):http://blog.itpub.net/26736162/viewspace-2134312/ 磁盘组不能自动挂载:http://blog.itpub.net/26736162/viewspace-2134257/ ?Oracle?RESETLOGS?和?NORESETLOGS?区别说明:http://blog.itpub.net/26736162/viewspace-2134187/ 在?Oracle?Enterprise? Linux ?和?iSCSI?上构建您自己的?Oracle?RAC?11g?集群:http://blog.itpub.net/26736162/viewspace-2134185/ 【ASM】ASMLIB?系列:http://blog.itpub.net/26736162/viewspace-2134171/ Oracle?12C?R2-新特性-SQLPLUS提供查看历史命令的功能:http://blog.itpub.net/26736162/viewspace-2133816/ Oracle?12C?R2-新特性-新增两个视图:方便查看trace文件和内容:http://blog.itpub.net/26736162/viewspace-2133815/ Oracle?12C?R2-新特性-转换函数的增强:http://blog.itpub.net/26736162/viewspace-2133814/ ?HP-UX常用命令:http://blog.itpub.net/26736162/viewspace-2133796/ 【12c】扩展数据类型(Extended?Data?Types)--?MAX_STRING_SIZE:http://blog.itpub.net/26736162/viewspace-2133623/ 【OH】Oracle软件安装需要的软件包(官方文档):http://blog.itpub.net/26736162/viewspace-2133603/ 使用OpenFiler来模拟存储配置RAC中ASM共享盘及多路径(multipath)的测试:http://blog.itpub.net/26736162/viewspace-2132858/ Linux 下如何查看系统启动时间和运行时间:http://blog.itpub.net/26736162/viewspace-2132856/ Oracle?12cR1?RAC?在VMware?Workstation上安装(下)—静默安装:http://blog.itpub.net/26736162/viewspace-2132773/ Oracle?12cR1?RAC?在VMware?Workstation上安装(中)—图形界面安装:http://blog.itpub.net/26736162/viewspace-2132772/ Oracle?12cR1?RAC?在VMware?Workstation上安装(上)—OS环境配置:http://blog.itpub.net/26736162/viewspace-2132768/ Oracle?12c中的MGMTDB:http://blog.itpub.net/26736162/viewspace-2132763/ DB_NAME、DB_UNIQUE_NAME、SERVICE_NAME和INSTANCE_NAME等的区别:http://blog.itpub.net/26736162/viewspace-2132760/ oracle?11g?asm?磁盘组兼容属性:http://blog.itpub.net/26736162/viewspace-2132601/ 【MOS】Redundant?Interconnect?ora.cluster_interconnect.haip?(文档?ID?1210883.1):http://blog.itpub.net/26736162/viewspace-2132596/ 【MOS】Cluster?Health?Monitor?(CHM)?FAQ?(文档?ID?1328466.1??ID?2062234.1):http://blog.itpub.net/26736162/viewspace-2132364/ 【故障处理】imp-00051,imp-00008:http://blog.itpub.net/26736162/viewspace-2132064/ PKG_COLLECTION_LHR??存储过程或函数返回集合类型:http://blog.itpub.net/26736162/viewspace-2131977/ 解读SQL?内存数据库的细节:http://blog.itpub.net/26736162/viewspace-2131690/ [转载]?DBA职业生涯规划:八步打造高级DBA专家:http://blog.itpub.net/26736162/viewspace-2131565/ 【 Linux 】将Oracle安装目录从根目录下迁移到逻辑卷:http://blog.itpub.net/26736162/viewspace-2131488/ You?cannot?change?a?partition?into?an?extended?one?or?vice?versa?Delete?it?first:http://blog.itpub.net/26736162/viewspace-2131419/ Red?Hat?6.5安装Oracle?10g故障汇总:http://blog.itpub.net/26736162/viewspace-2131418/ ?Mysql报错Fatal?error:Can't?open?and?lock?privilege?tables:http://blog.itpub.net/26736162/viewspace-2131368/ 【故障处理】ORA-28040:?No?matching?authentication?protocol:http://blog.itpub.net/26736162/viewspace-2131338/ 关于VMware虚拟机磁盘收缩的几种方法:http://blog.itpub.net/26736162/viewspace-2131337/ 【故障处理】队列等待之enq?IV?-??contention案例:http://blog.itpub.net/26736162/viewspace-2131320/ ORACLE数据库DDL审计触发器与隐藏参数_system_trig_enabled:http://blog.itpub.net/26736162/viewspace-2131205/ 【故障处理】告警日志报“ORA-01565?Unable?To?open?Spfile”:http://blog.itpub.net/26736162/viewspace-2131070/ 【ASH】如何导出视图DBA_HIST_ACTIVE_SESS_HISTORY的查询结果数据:http://blog.itpub.net/26736162/viewspace-2130980/ 【OH】Deprecated?and?Desupported?Features?for?Oracle?Database?12c:http://blog.itpub.net/26736162/viewspace-2130977/ DNS?引起经典RAC故障:http://blog.itpub.net/26736162/viewspace-2130925/ 【MOS】RAC?环境中最常见的?5?个数据库和/或实例性能问题?(文档?ID?1602076.1):http://blog.itpub.net/26736162/viewspace-2130835/ 【MOS】 EXPDP?-?ORA-39166?(Object?Was?Not?Found)??(文档?ID?1640392.1):http://blog.itpub.net/26736162/viewspace-2130834/ 【MOS】12c?RAC?"enq:?IV?-?contention"?(文档?ID?2028503.1):http://blog.itpub.net/26736162/viewspace-2130833/ 【MOS】EXPDP?Fails?ORA-39165:?Schema?SYS?Was?Not?Found?(文档?ID?553402.1):http://blog.itpub.net/26736162/viewspace-2130832/ 【MOS】Why?an?Object?Not?Be?Exported??ORA-39166?or?ORA-31655?(文档?ID?2114233.1):http://blog.itpub.net/26736162/viewspace-2130831/ 【12C】数据泵新特性(DISABLE_ARCHIVE_LOGGING+VIEWS_AS_TABLES导出视图+LOGTIME):http://blog.itpub.net/26736162/viewspace-2130830/ Oracle技巧:如何诊断一些未预料的?Oracle?错误(ORA-NNNN):http://blog.itpub.net/26736162/viewspace-2130829/ DBCA建库问题处理之-无法创建RAC实例:http://blog.itpub.net/26736162/viewspace-2130821/ alter?table?move跟shrink?space的区别:http://blog.itpub.net/26736162/viewspace-2130733/ ASMCMD执行ASM元数据备份与还原:http://blog.itpub.net/26736162/viewspace-2130448/ 【OH】Glossary?Oracle词汇表(下):http://blog.itpub.net/26736162/viewspace-2130447/ 【OH】Glossary?Oracle词汇表(中):http://blog.itpub.net/26736162/viewspace-2130446/ 【MOS】How?to?backup?or?restore?OLR?in?11.2/12c?Grid?Infrastructure:http://blog.itpub.net/26736162/viewspace-2130323/ 【OH】3?Managing?Oracle?Cluster?Registry?and?Voting?Disks:http://blog.itpub.net/26736162/viewspace-2130322/ 【MOS】Top?5?Grid?Infrastructure?Startup?Issues?(文档?ID?1368382.1):http://blog.itpub.net/26736162/viewspace-2130321/ 在oracle集群中更改表决磁盘配置:http://blog.itpub.net/26736162/viewspace-2130276/ 【故障处理】一次RAC故障处理过程:http://blog.itpub.net/26736162/viewspace-2130218/ Oracle?无备份情况恢复ocr和olr:http://blog.itpub.net/26736162/viewspace-2130216/ RAC?11G?ASM磁盘损坏恢复:http://blog.itpub.net/26736162/viewspace-2130203/ oracle?表移动表空间:http://blog.itpub.net/26736162/viewspace-2130093/ dbms_shared_pool.purge?清理某个SQL执行计划:http://blog.itpub.net/26736162/viewspace-2129896/ 小麦苗健康检查脚本说明(Oracle巡检脚本):http://blog.itpub.net/26736162/viewspace-2129647/ 【密码】Oracle用户密码系列:http://blog.itpub.net/26736162/viewspace-2129595/ 健康检查报告V5.5.9版本:http://blog.itpub.net/26736162/viewspace-2129512/ 【用户状态】详细解读Oracle用户ACCOUNT_STATUS的九种状态:http://blog.itpub.net/26736162/viewspace-2129454/ 【MOS】Troubleshooting?Performance?Issues?(文档?ID?1377446.1):http://blog.itpub.net/26736162/viewspace-2129427/ 【ASM】ASMSNMP用户已存在:http://blog.itpub.net/26736162/viewspace-2129422/ Oracle?11g?密码设置为不过期:http://blog.itpub.net/26736162/viewspace-2129357/ lsdg中的Usable_file_MB?为什么是负值?:http://blog.itpub.net/26736162/viewspace-2129290/ 【故障处理】CRS-1153错误处理:http://blog.itpub.net/26736162/viewspace-2129163/ 【静默安装】configToolAllCommands响应文件问题:http://blog.itpub.net/26736162/viewspace-2129161/ 【锁】Oracle锁系列:http://blog.itpub.net/26736162/viewspace-2128896/ 【函数】Oracle函数系列(2)--数学函数及日期函数:http://blog.itpub.net/26736162/viewspace-2128764/ 【微信公众号】【深入解析】DRM和read-mostly?locking:http://blog.itpub.net/26736162/viewspace-2128730/ 【微信公众号●云和恩墨】知己知彼-关于Oracle安全比特币勒索问题揭秘和防范:http://blog.itpub.net/26736162/viewspace-2128728/ Oracle检查点(Checkpoint)详解?(文档?ID?1526118.1):http://blog.itpub.net/26736162/viewspace-2128727/ 【MOS】 [INS-41112]?Specified?network?interface(文档?ID?1427202.1):http://blog.itpub.net/26736162/viewspace-2128584/ 【LOCK】V$LOCK视图中的ID1和ID2含义:http://blog.itpub.net/26736162/viewspace-2128559/ ORACLE?回滚段详解:http://blog.itpub.net/26736162/viewspace-2128461/ 【MOS】如何利用RMAN可传输表空间迁移数据库到不同字节序的平台(文档?ID?1983639.1):http://blog.itpub.net/26736162/viewspace-2128460/ 【11g新特性】DDL_LOCK_TIMEOUT的作用:http://blog.itpub.net/26736162/viewspace-2128459/ 【MOS】Index?Rebuild?Is?Hanging?Or?Taking?Too?Long?(文档?ID?272762.1):http://blog.itpub.net/26736162/viewspace-2128370/ 【SQL查询】集合查询之INTERSECT:http://blog.itpub.net/26736162/viewspace-2128358/ 用户登录信息查看:http://blog.itpub.net/26736162/viewspace-2128301/ Streams?AQ:?qmn?coordinator?waiting?for?slave?to?start等待事件:http://blog.itpub.net/26736162/viewspace-2128262/ 【故障处理】IMP-00010错误?12C的dmp文件导入11G:http://blog.itpub.net/26736162/viewspace-2128197/ 【MOS】Troubleshooting?'enq:?TX?-?index?contention'?Waits?(文档?ID?873243.1)?:http://blog.itpub.net/26736162/viewspace-2127973/ 【故障处理】ORA-30012的解决过程:http://blog.itpub.net/26736162/viewspace-2127949/ 收集优化统计数据(Optimizer?Statistics)的最佳实践方法:http://blog.itpub.net/26736162/viewspace-2127849/ 【等待事件】序列等待事件总结(SQ、SV、row?cache?lock、DFS?lock?handle):http://blog.itpub.net/26736162/viewspace-2127465/ DB-Engines:2016年10月份全球数据库排名:http://blog.itpub.net/26736162/viewspace-2127375/ Oracle推导参数Derived?Parameter介绍:http://blog.itpub.net/26736162/viewspace-2127374/ 【体系结构】Oracle参数介绍:http://blog.itpub.net/26736162/viewspace-2127338/ 【锁】Oracle死锁(DeadLock)的分类及其模拟:http://blog.itpub.net/26736162/viewspace-2127247/ Oracle之3种表连接方式(排序合并连接、嵌套循环、哈希连接):http://blog.itpub.net/26736162/viewspace-2127240/ Oracle数据文件和临时文件的管理:http://blog.itpub.net/26736162/viewspace-2127025/ 【函数】Oracle函数系列(1)--字符函数:http://blog.itpub.net/26736162/viewspace-2126927/ Oracle字符集的简单图解,中文乱码解决:http://blog.itpub.net/26736162/viewspace-2126759/ SQL注入系列问题:http://blog.itpub.net/26736162/viewspace-2126757/ ?Oracle?监听器日志配置与管理:http://blog.itpub.net/26736162/viewspace-2126607/ Web页面或URL转换为PDF的在线工具:http://blog.itpub.net/26736162/viewspace-2126510/ 吃剩的苹果、长芽的土豆别扔!会有奇迹发生!:http://blog.itpub.net/26736162/viewspace-2126506/ 【体系结构】有关Oracle?SCN知识点的整理:http://blog.itpub.net/26736162/viewspace-2126407/ 三种Oracle?RMAN备份加密策略(下):http://blog.itpub.net/26736162/viewspace-2126333/ 三种Oracle?RMAN备份加密策略(上):http://blog.itpub.net/26736162/viewspace-2126332/ Oracle实例恢复和介质恢复:http://blog.itpub.net/26736162/viewspace-2126293/ Oracle恢复流程图:http://blog.itpub.net/26736162/viewspace-2126198/ ?【微信公众号●?DBAplus】Oracle原厂老兵:从负面案例看Hint的最佳使用方式:http://blog.itpub.net/26736162/viewspace-2126195/ 【sessions】Oracle中sessions和processes的大小关系(10g和11g不同):http://blog.itpub.net/26736162/viewspace-2126128/ 【等待事件】等待事件系列(5.1)--Enqueue(队列等待):http://blog.itpub.net/26736162/viewspace-2126079/ 【转载】RAC?修改?spfile?参数:http://blog.itpub.net/26736162/viewspace-2126005/ 【OH】Glossary?Oracle词汇表(上):http://blog.itpub.net/26736162/viewspace-2125950/ SQL?Server中的锁:http://blog.itpub.net/26736162/viewspace-2125949/ 【知识点整理】NOLOGGING、APPEND、ARCHIVE和PARALLEL下,REDO、UNDO和执行速度的比较:http://blog.itpub.net/26736162/viewspace-2125815/ [原创]append_values?hint:http://blog.itpub.net/26736162/viewspace-2125785/ Oracle11gr2新增APPEND_VALUES提示:http://blog.itpub.net/26736162/viewspace-2125784/ 【转载】Hint的常见错误使用方式:http://blog.itpub.net/26736162/viewspace-2125709/ 【方法整理】Oracle?获取trace跟踪文件名的几种常用方式:http://blog.itpub.net/26736162/viewspace-2125659/ 【XTTS】XTTS使用说明:http://blog.itpub.net/26736162/viewspace-2125658/ 分析解决11gR2?双节点RAC环境下的gc?cr?block?busy/gc?buffer?busy?acquire等待:http://blog.itpub.net/26736162/viewspace-2125637/ 那些你眼熟的global?cache等待事件是如何被触发的(一):http://blog.itpub.net/26736162/viewspace-2125636/ 【MOS】Top?Ten?Performance?Mistakes?Found?in?Oracle?Systems.?(文档?ID?858539.1):http://blog.itpub.net/26736162/viewspace-2125539/ 【MOS】TNSPING?TNS-12543:?TNS:destination?host?unreachable?(文档?ID?1556918.1):http://blog.itpub.net/26736162/viewspace-2125538/ 【故障处理】DG环境主库丢失归档情况下数据文件的恢复:http://blog.itpub.net/26736162/viewspace-2125336/ asm管理的dg数据文件缺失的处理方法:http://blog.itpub.net/26736162/viewspace-2125261/ 【云和恩墨】insert?into太慢?Roger?带你找真凶:http://blog.itpub.net/26736162/viewspace-2125233/ 【等待事件】等待事件系列(3+4)--System?IO(控制文件)+日志类等待:http://blog.itpub.net/26736162/viewspace-2125065/ 【转载】运维角度浅谈MySQL数据库优化:http://blog.itpub.net/26736162/viewspace-2125039/ 【转载】MySQL慢查询日志总结:http://blog.itpub.net/26736162/viewspace-2125038/ MySQL?EXPLAIN命令详解学习(查看执行计划):http://blog.itpub.net/26736162/viewspace-2125036/ 为什么忘记commit也会造成select查询的性能问题(SELECT产生Redo的情形):http://blog.itpub.net/26736162/viewspace-2125034/ 【DBAplus】SQL优化:一篇文章说清楚Oracle?Hint的正确使用姿势:http://blog.itpub.net/26736162/viewspace-2125011/ ?【技巧】如何让普通用户可以杀掉自己用户的会话:http://blog.itpub.net/26736162/viewspace-2124932/ 【函数】wm_concat包的订制:http://blog.itpub.net/26736162/viewspace-2124931/ 【云和恩墨】性能优化: Linux 环境下合理配置大内存页(HugePage):http://blog.itpub.net/26736162/viewspace-2124855/ 【技巧】如何使用客户端发布BLOG+如何快速发布微信公众号文章:http://blog.itpub.net/26736162/viewspace-2124780/ 【故障处理】队列等待之TX?-?allocate?ITL?entry引起的死锁处理:http://blog.itpub.net/26736162/viewspace-2124771/ 【故障处理】队列等待之enq:?US?-?contention案例:http://blog.itpub.net/26736162/viewspace-2124767/ 关于enq:?US?–?contention:http://blog.itpub.net/26736162/viewspace-2124740/ 强大的AWR-Format的使用:http://blog.itpub.net/26736162/viewspace-2124737/ 【故障处理】队列等待之TX?-?allocate?ITL?entry案例:http://blog.itpub.net/26736162/viewspace-2124735/ Linux 磁盘管理:LVM逻辑卷管理:http://blog.itpub.net/26736162/viewspace-2124620/ ?队列、资源与锁?:http://blog.itpub.net/26736162/viewspace-2124615/ Oracle一次缩小表空间的处理过程:http://blog.itpub.net/26736162/viewspace-2124606/ 如何正确的删除表空间数据文件:http://blog.itpub.net/26736162/viewspace-2124605/ 【比较】Oracle不同版本中关于ALTER?TABLESPACE的功能演进:http://blog.itpub.net/26736162/viewspace-2124604/ oracle数据库enq:?TX?-?allocate?ITL?entry性能诊断:http://blog.itpub.net/26736162/viewspace-2124534/ 关于enq:?TX?-?allocate?ITL?entry的问题分析:http://blog.itpub.net/26736162/viewspace-2124533/ 【MOS】?Troubleshooting?waits?for?enq:?TX?-?allocate?ITL?entry(1472175.1):http://blog.itpub.net/26736162/viewspace-2124531/ Mac?下的MySQL?ERROR?1227(42000):?Access?denied;?you?need?(at?least?one?of):http://blog.itpub.net/26736162/viewspace-2124455/ mysql?innodb间隙锁示例:http://blog.itpub.net/26736162/viewspace-2124454/ 【等待事件】等待事件系列(1)--User?I/O类型:http://blog.itpub.net/26736162/viewspace-2124417/ 【故障处理】队列等待之enq:?TX?-?row?lock?contention:http://blog.itpub.net/26736162/viewspace-2124369/ 【索引】Oracle之不可见索引和虚拟索引的比对:http://blog.itpub.net/26736162/viewspace-2124164/ Oracle之不可见索引(invisible?indexes):http://blog.itpub.net/26736162/viewspace-2124044/ 【故障处理】序列cache值过小导致CPU利用率过高:http://blog.itpub.net/26736162/viewspace-2123996/ OCP如何查看历史成绩(2):http://blog.itpub.net/26736162/viewspace-2123883/ Oracle之虚拟索引:http://blog.itpub.net/26736162/viewspace-2123687/ 【DBAplus社群】MySQL进阶路:从小工到专家的必读书籍和必备工具:http://blog.itpub.net/26736162/viewspace-2123634/ 小麦苗微信公众号文章链接地址:http://blog.itpub.net/26736162/viewspace-2123527/ Oracle?11g新特性direct?path?read引发的系统停运故障诊断处理:http://blog.itpub.net/26736162/viewspace-2123524/ 常识之外:全表扫描为何产生大量?db?file?sequential?read?单块读?:http://blog.itpub.net/26736162/viewspace-2123513/ 消除11.2上的db?file?parallel?read:http://blog.itpub.net/26736162/viewspace-2123473/ 【BBED】bbed常用命令:http://blog.itpub.net/26736162/viewspace-2123465/ 【故障处理】ORA-12545:?Connect?failed?because?target?host:http://blog.itpub.net/26736162/viewspace-2123414/ ORA-29339错误解决办法:http://blog.itpub.net/26736162/viewspace-2123366/ DUAL系列:http://blog.itpub.net/26736162/viewspace-2123291/ Oracle如何删除表中重复记录:http://blog.itpub.net/26736162/viewspace-2123234/ 【故障处理】分布式事务ORA-01591错误解决:http://blog.itpub.net/26736162/viewspace-2122999/ 《Oracle?DBA工作笔记》第二章?常用工具和问题分析:http://blog.itpub.net/26736162/viewspace-2122942/ 【故障处理】ORA-19809错误处理:http://blog.itpub.net/26736162/viewspace-2122820/ 小麦苗的常用代码(仅限自己使用):http://blog.itpub.net/26736162/viewspace-2122294/ 数据文件offline后unusable索引造成的问题:http://blog.itpub.net/26736162/viewspace-2122112/ Oracle?RAC之--安装过程中碰到的问题及解决方法:http://blog.itpub.net/26736162/viewspace-2122110/ 聊聊Oracle?11g中的Reference?Partition(下):http://blog.itpub.net/26736162/viewspace-2122109/ 聊聊Oracle?11g中的Reference?Partition(上):http://blog.itpub.net/26736162/viewspace-2122108/ 使用awk来解析dump文件:http://blog.itpub.net/26736162/viewspace-2122031/ Oracle手动建库常见问题:http://blog.itpub.net/26736162/viewspace-2121981/ 《Oracle?DBA工作笔记》第一章:http://blog.itpub.net/26736162/viewspace-2121930/ 【故障处理】DBCA建库诡异问题处理--rac环境不能创建rac库:http://blog.itpub.net/26736162/viewspace-2121863/ 【海量数据学院】DBA的学习方法论系列—正确的学习方法:http://blog.itpub.net/26736162/viewspace-2121789/ 【海量数据学院】DBA学习方法论系列之:明确的学习目标:http://blog.itpub.net/26736162/viewspace-2121788/ Oracle?AWR报告详细分析??(文档?ID?1523048.1):http://blog.itpub.net/26736162/viewspace-2121787/ 【云和恩墨】内外兼修:Oracle?ACED熊军谈Oracle学习:http://blog.itpub.net/26736162/viewspace-2121774/ 【DG】物理DG中LNSn、NSS、NSA进程:http://blog.itpub.net/26736162/viewspace-2121688/ Oracle?OCR的备份与恢复:http://blog.itpub.net/26736162/viewspace-2121470/ 小麦苗的微信公众号开通啦,欢迎大家扫码关注:http://blog.itpub.net/26736162/viewspace-2121429/ 【ASM】ASMCMD?之md_backup,md_restore介绍:http://blog.itpub.net/26736162/viewspace-2121309/ 【ASM】ASMCMD?磁盘元数据的备份与恢复实践:http://blog.itpub.net/26736162/viewspace-2121308/ Oracle后台进程及其作用简介:http://blog.itpub.net/26736162/viewspace-2121305/ 11gR2?GI和DB安装目录权限属主被修改后的恢复方法:http://blog.itpub.net/26736162/viewspace-2121304/ Oracle回收站及flashback?drop(下):http://blog.itpub.net/26736162/viewspace-2121137/ Oracle回收站及flashback?drop(上):http://blog.itpub.net/26736162/viewspace-2121136/ 【OH】SET?System?Variable?Summary?SQLPLUS?系统变量设置:http://blog.itpub.net/26736162/viewspace-2121072/ 【SQL*Plus】11g版本对?SQL*Plus错误日志的记录功能——errorlogging参数:http://blog.itpub.net/26736162/viewspace-2121056/ 【会话】Oracle?kill?session系列:http://blog.itpub.net/26736162/viewspace-2121019/ Oracle索引的监控:http://blog.itpub.net/26736162/viewspace-2120752/ 互联网协议入门及DNS原理入门:http://blog.itpub.net/26736162/viewspace-2120540/ oracle大表添加字段default经验分享:http://blog.itpub.net/26736162/viewspace-2120470/ 【Mysql】如何查看mysql软件版本信息:http://blog.itpub.net/26736162/viewspace-2120357/ 【问题处理】Error?accessing?PRODUCT_USER_PROFILE错误一例:http://blog.itpub.net/26736162/viewspace-2120166/ 【实验】使用PRODUCT_USER_PROFILE禁止特定用户在SQL*Plus中使用delete语句:http://blog.itpub.net/26736162/viewspace-2120165/ alert文件中出現:Auto-tuning:?Shutting?down?background?process?GTXd:http://blog.itpub.net/26736162/viewspace-2120022/ MySQL误删物理文件的恢复( Linux ):http://blog.itpub.net/26736162/viewspace-2119299/ Linux 下利用文件描述符恢复的成功失败实验:http://blog.itpub.net/26736162/viewspace-2119296/ 【MOS】常见问题cursor?library?cache类型的等待事件:http://blog.itpub.net/26736162/viewspace-2119198/ 【故障处理】?DBCA建库报错CRS-2566:http://blog.itpub.net/26736162/viewspace-2114484/ 【MOS】中文文档列表?-?Oracle?Database?(文档?ID?1533057.1):http://blog.itpub.net/26736162/viewspace-2113676/ 【MOS:1549181.1】为何在查询中索引未被使用--为什么索引没有被使用:http://blog.itpub.net/26736162/viewspace-2113670/ SQL的开发建议(MySQL和Oracle):http://blog.itpub.net/26736162/viewspace-2113587/ 【故障解决】IPCS和IPCRM使用:http://blog.itpub.net/26736162/viewspace-2112518/ ORACLE内核参数:http://blog.itpub.net/26736162/viewspace-2112447/ sysresv:http://blog.itpub.net/26736162/viewspace-2112443/ 【分区】如何将一个普通表转换为分区表:http://blog.itpub.net/26736162/viewspace-2109454/ 运维利器:万能的?strace:http://blog.itpub.net/26736162/viewspace-2109448/ 【SPM】Oracle如何固定执行计划:http://blog.itpub.net/26736162/viewspace-2107604/ 在10g/11g中如何查看SQL?Profiles信息:http://blog.itpub.net/26736162/viewspace-2106743/ wait?for?stopper?event?to?be?increased:http://blog.itpub.net/26736162/viewspace-2103071/ 【OUTLINE】使用Oracle?Outline技术暂时锁定SQL的执行计划:http://blog.itpub.net/26736162/viewspace-2102180/ 【PSU】AIX?11g?RAC自动打GI?PSU5--PSU升级详细过程:http://blog.itpub.net/26736162/viewspace-2101673/ 【云和恩墨】嵌入云端:12c?Policy-Managed?Cluster为Oracle?DBaaS助力:http://blog.itpub.net/26736162/viewspace-2101096/ SQL?Server常用的几种启动方式:http://blog.itpub.net/26736162/viewspace-2100654/ DBA?技能树:http://blog.itpub.net/26736162/viewspace-2098449/ 【OH】?Database?Sample?Schemas?--?Installation?and?Descriptions:http://blog.itpub.net/26736162/viewspace-2098222/ 【OH】Creating?a?Database?with?the?CREATE?DATABASE?Statement:http://blog.itpub.net/26736162/viewspace-2098211/ 【OH】常用数据字典脚本说明?SQL?Scripts:http://blog.itpub.net/26736162/viewspace-2098205/ 【MOS】PSU等?补丁号码快速参考?(ID?1922396.1、756671.1、2227021.1)?:http://blog.itpub.net/26736162/viewspace-2096650/ ORACLE?11.2?RAC修改数据库静态参数:http://blog.itpub.net/26736162/viewspace-2096314/ 【云和恩墨】Oracle初学者入门指南-什么是?Metalink?或?MOS??:http://blog.itpub.net/26736162/viewspace-2095976/ 【DBAplus】深入Oracle优化器:一条诡异执行计划的解决之道:http://blog.itpub.net/26736162/viewspace-2095973/ 【子衿技术】DBA进阶之路:http://blog.itpub.net/26736162/viewspace-2095970/ 【云和恩墨】一次?truncate?核心表衍生的安全管理思考:http://blog.itpub.net/26736162/viewspace-2095966/ ORACLE?RAC?手动建库:http://blog.itpub.net/26736162/viewspace-2094506/ 使用create?database语句创建数据库的详细操作步骤:http://blog.itpub.net/26736162/viewspace-2094505/ 数据库安装An?unexpected?error?has?been?detected?by?HotSpot? Virtual ?Machine:http://blog.itpub.net/26736162/viewspace-2094436/ 关于dual表的破坏性测试:http://blog.itpub.net/26736162/viewspace-2090566/ 【故障处理】DG归档丢失的恢复:http://blog.itpub.net/26736162/viewspace-2087473/ 细致入微?|?让?SQL?优化再多飞一会儿:http://blog.itpub.net/26736162/viewspace-2084979/ 用好HugePage,告别 Linux 性能故障:http://blog.itpub.net/26736162/viewspace-2084973/ RHEL6?64位系统安装ORACLE?10g?64bit?数据库:http://blog.itpub.net/26736162/viewspace-2084920/ oracle?12c?数据库上编写SQL语句时卡顿的问题解决:http://blog.itpub.net/26736162/viewspace-2084854/ 聊聊字符串数据长度和nls_length_semantics参数:http://blog.itpub.net/26736162/viewspace-2084683/ 【BBED】?SYSTEM文件头损坏的恢复(4):http://blog.itpub.net/26736162/viewspace-2084329/ 【中亦安图】运维无小事之一次导致数据丢失的小变更(10):http://blog.itpub.net/26736162/viewspace-2083751/ 【中亦安图】SQL优化之基于SQL特征的改写(9):http://blog.itpub.net/26736162/viewspace-2083744/ 【中亦安图】Systemstate?Dump分析经典案例(8):http://blog.itpub.net/26736162/viewspace-2083738/ 【中亦安图】Systemstate?Dump分析经典案例(7):http://blog.itpub.net/26736162/viewspace-2083736/ 【中亦安图】Oracle内存过度消耗风险提醒(6):http://blog.itpub.net/26736162/viewspace-2083731/ 【中亦安图】清算/报表/日终跑批程序之性能优化案例(5):http://blog.itpub.net/26736162/viewspace-2083724/ 【中亦安图】导致Oracle性能抖动的参数提醒(4):http://blog.itpub.net/26736162/viewspace-2083717/ 【中亦安图】关于数据库文件损坏风险的提醒(3):http://blog.itpub.net/26736162/viewspace-2083709/ 【中亦安图】风险提醒之Oracle?RAC高可用失效(2):http://blog.itpub.net/26736162/viewspace-2083700/ 【中亦安图】小机上运行Oracle需要注意的进程调度bug(1):http://blog.itpub.net/26736162/viewspace-2083690/ 【BBED】?sys.bootstrap$?对象的恢复:http://blog.itpub.net/26736162/viewspace-2083621/ truncate表后恢复方法总结:http://blog.itpub.net/26736162/viewspace-2082965/ Oracle?11gr2中的自动并行度:http://blog.itpub.net/26736162/viewspace-2082758/ ORA-00704、ORA-39700处理:http://blog.itpub.net/26736162/viewspace-2081295/ Oracle?内部2,8,10,16进制转换函数包:http://blog.itpub.net/26736162/viewspace-2081074/ ORA-01555?快照太旧、Undo表空间、一致性读、延时块清除:http://blog.itpub.net/26736162/viewspace-2080746/ 【SQL】Oracle?SQL?monitor:http://blog.itpub.net/26736162/viewspace-2080743/ 揭秘ASM磁盘头信息:http://blog.itpub.net/26736162/viewspace-2080729/ 揭秘Oracle数据库truncate原理:http://blog.itpub.net/26736162/viewspace-2080727/ 看了此文,Oracle?SQL优化文章不必再看!:http://blog.itpub.net/26736162/viewspace-2080721/ 一个老DBA的自白:http://blog.itpub.net/26736162/viewspace-2080718/ SQL优化之六脉神剑:http://blog.itpub.net/26736162/viewspace-2080717/ System?State?转储分析案例一则:http://blog.itpub.net/26736162/viewspace-2080714/ 非常规方法,轻松应对Oracle数据库危急异常:http://blog.itpub.net/26736162/viewspace-2080698/ Oracle?hang?之sqlplus?-prelim使用方法:http://blog.itpub.net/26736162/viewspace-2080696/ 80?多个? Linux ?必备的监控工具:http://blog.itpub.net/26736162/viewspace-2080690/ 一条关于swap争用的报警邮件分析:http://blog.itpub.net/26736162/viewspace-2080685/ 数据安全:巧妙解决由密码过期导致的用户锁定问题:http://blog.itpub.net/26736162/viewspace-2080681/ 性能为王:SQL标量子查询的优化案例分析:http://blog.itpub.net/26736162/viewspace-2080676/ 如何提高datapump操作性能:http://blog.itpub.net/26736162/viewspace-2079654/ ORA-01189的完整解决过程(File?is?from?a?different?RESETLOGS?than?previous?files):http://blog.itpub.net/26736162/viewspace-2079650/ 【BBED】丢失归档文件情况下的恢复:http://blog.itpub.net/26736162/viewspace-2079337/ ORA-16433?The?database?must?be?opened?in?read?write?mode故障解决:http://blog.itpub.net/26736162/viewspace-2079108/ oracle_16进制与10进制转换小示例:http://blog.itpub.net/26736162/viewspace-2077804/ oracle?rba一些小知识:http://blog.itpub.net/26736162/viewspace-2077801/ Linux 扩展根目录大小??:http://blog.itpub.net/26736162/viewspace-2076301/ 【AIX】3004-314?Password?was?recently?used?and?is?not?valid?for?reuse:http://blog.itpub.net/26736162/viewspace-2075782/ 【BBED】编译及基本命令(1):http://blog.itpub.net/26736162/viewspace-2075216/ KFED-320错误:http://blog.itpub.net/26736162/viewspace-2073805/ 修改profile实现资源限制:http://blog.itpub.net/26736162/viewspace-2073764/ ORALCE10G?位图索引探究:http://blog.itpub.net/26736162/viewspace-2073673/ oracle插入随机数据:http://blog.itpub.net/26736162/viewspace-2073557/ 【RAC】rac中如何指定job的运行实例:http://blog.itpub.net/26736162/viewspace-2072635/ 如何解决ORACLE11G里面ORA-24247?网络访问被访问控制列表?(ACL)?拒绝?错误:http://blog.itpub.net/26736162/viewspace-2072163/ 如何全文搜索oracle官方文档:http://blog.itpub.net/26736162/viewspace-2065550/ 【故障处理】因AIX异步IO没有开启导致SQL*Plus不可用:http://blog.itpub.net/26736162/viewspace-2063573/ Oracle?Database?RAC?11.2.0.3?for?AIX6.1TL7安装记录(5):http://blog.itpub.net/26736162/viewspace-2062874/ Oracle?Database?RAC?11.2.0.3?for?AIX6.1TL7安装记录(4):http://blog.itpub.net/26736162/viewspace-2062873/ 【ERROR】非DBA用户要使用autotrace功能,报错(SP2-0618:和SP2-0611:和ORA-01919):http://blog.itpub.net/26736162/viewspace-2061718/ 预防晕车方法大全:http://blog.itpub.net/26736162/viewspace-2060532/ 用直接路径(direct-path)insert提升性能的两种方法:http://blog.itpub.net/26736162/viewspace-2060489/ Metalink使用指南?:http://blog.itpub.net/26736162/viewspace-2059718/ AIX平台下磁盘的PVID对ASM磁盘的破坏:http://blog.itpub.net/26736162/viewspace-2058516/ AIX?6.1?Oracle11g?11.2.0.4?RAC?安装心得:http://blog.itpub.net/26736162/viewspace-2058487/ 【安装】AIX安装单实例11gR2?GRID+DB:http://blog.itpub.net/26736162/viewspace-2057286/ 【RAC安装】?AIX下安装Oracle?11gR2?RAC:http://blog.itpub.net/26736162/viewspace-2057270/ ORA-16179??不允许使用?SPFILE?对?"log_archive_dest_1"?进行增量更改:http://blog.itpub.net/26736162/viewspace-2052064/ Oracle?Bigfile?Tablespace大文件表空间:http://blog.itpub.net/26736162/viewspace-2039283/ 【OEM】OEM安装维护:http://blog.itpub.net/26736162/viewspace-2029565/ 【故障处理】修改SPFILE无权限:http://blog.itpub.net/26736162/viewspace-2029515/ 【RAC安装故障】multiple?user?has?uid?0:http://blog.itpub.net/26736162/viewspace-2029482/ Oracle?Database?RAC?11.2.0.3?for?AIX6.1TL7安装记录(3):http://blog.itpub.net/26736162/viewspace-2025754/ Oracle?Database?RAC?11.2.0.3?for?AIX6.1TL7安装记录(2):http://blog.itpub.net/26736162/viewspace-2025748/ Oracle?11gR2?RAC?Database使用emca配置集群dbconsole:http://blog.itpub.net/26736162/viewspace-2025733/ Ask?Hoegh(5)——buffer?cache和buffer有什么区别?:http://blog.itpub.net/26736162/viewspace-2025183/ Oracle?Database?RAC?11.2.0.3?for?AIX6.1TL7安装记录(1):http://blog.itpub.net/26736162/viewspace-1995473/ oracle?9i/10g/11g(11.2.0.3)安装包和PATCH下载地址汇总:http://blog.itpub.net/26736162/viewspace-1995400/ shell?will?time?out?in?60?seconds:http://blog.itpub.net/26736162/viewspace-1992203/ 利用Oracle?Data?Guard完成跨平台的数据库迁移案例:http://blog.itpub.net/26736162/viewspace-1992200/ RMAN-04006:?error?from?auxiliary?database:?ORA-01034:?ORACLE?not?available:http://blog.itpub.net/26736162/viewspace-1992198/ 【DG】主rac?+?备rac?dg?部署:http://blog.itpub.net/26736162/viewspace-1991614/ 【AIX】AIX?开机自动挂载NFS共享:http://blog.itpub.net/26736162/viewspace-1989809/ 【TTS】AIX-> Linux --基于RMAN(真实环境)--续:http://blog.itpub.net/26736162/viewspace-1987974/ 【TTS】AIX-> Linux --基于RMAN(真实环境):http://blog.itpub.net/26736162/viewspace-1987971/ 【TTS】传输表空间AIX-> Linux 基于rman:http://blog.itpub.net/26736162/viewspace-1987961/ 【TTS】传输表空间AIX?asm?->? Linux ?asm:http://blog.itpub.net/26736162/viewspace-1987957/ 【TTS】传输表空间 Linux ?->AIX?基于rman:http://blog.itpub.net/26736162/viewspace-1987953/ 【TTS】传输表空间 Linux ?asm?->?AIX?asm:http://blog.itpub.net/26736162/viewspace-1987949/ 【故障解决】enq:?PS?-?contention:http://blog.itpub.net/26736162/viewspace-1985380/ RMAN同字节序跨平台跨版本迁移数据库(二):http://blog.itpub.net/26736162/viewspace-1985360/ RMAN同字节序跨平台跨版本迁移数据库(一):http://blog.itpub.net/26736162/viewspace-1985359/ RMAN跨小版本跨平台与字节序传输表空间:http://blog.itpub.net/26736162/viewspace-1985357/ RMAN使用备份传输表空间的各种自定义操作:http://blog.itpub.net/26736162/viewspace-1985356/ RMAN使用备份按时间点传输表空间:http://blog.itpub.net/26736162/viewspace-1985355/ RMAN使用备份传输表空间:http://blog.itpub.net/26736162/viewspace-1985354/ 【探索】【oerr】对oerr出处的一点点探索:http://blog.itpub.net/26736162/viewspace-1982714/ 【故障解决】OGG-00446?错误解决:http://blog.itpub.net/26736162/viewspace-1982701/ 【故障解决】ORA-06502错误解决:http://blog.itpub.net/26736162/viewspace-1982193/ Data?Pump?Client?Gets?UDE-8?ORA-31626?ORA-39086?(文档?ID?549781.1):http://blog.itpub.net/26736162/viewspace-1982166/ UDE-00008:?operation?generated?ORACLE?error?31626:http://blog.itpub.net/26736162/viewspace-1982165/ 【expdp/impdp】?ORA-06502、ORA-39077?错误分析与解决方案:http://blog.itpub.net/26736162/viewspace-1982160/ 执行时间在1秒以下的SQL同样也会引发性能问题:http://blog.itpub.net/26736162/viewspace-1980964/ 重建控制文件时resetlogs与noresetlogs的使用情况:http://blog.itpub.net/26736162/viewspace-1980959/ 我的oracle健康检查报告(三):http://blog.itpub.net/26736162/viewspace-1870296/ oracle中Alter?system?命令的总结:http://blog.itpub.net/26736162/viewspace-1846054/ 数据泵导出出现ORA-31617错误:http://blog.itpub.net/26736162/viewspace-1845530/ ORA-01002?“fetch?out?of?sequence”关于cursor的一个bug:http://blog.itpub.net/26736162/viewspace-1828362/ ORACLE?RAC环境下节点自动重启问题总结:http://blog.itpub.net/26736162/viewspace-1822179/ ORACLE?RAC?的启动和关闭顺序:http://blog.itpub.net/26736162/viewspace-1822177/ Oracle?Executable?Binary?Mismatch?Detected:http://blog.itpub.net/26736162/viewspace-1814139/ 【DBA】如何快速的成为一个合格的Oracle?DBA?:http://blog.itpub.net/26736162/viewspace-1813921/ Oracle官方文档及个人书签地址:http://blog.itpub.net/26736162/viewspace-1813688/ imp导入报错:IMP-00037:?Character?set?marker?unknown:http://blog.itpub.net/26736162/viewspace-1812251/ 【DATAGUARD】物理dg配置客户端无缝切换?(八.4)--ora-16652?和?ora-16603错误:http://blog.itpub.net/26736162/viewspace-1811947/ 【DATAGUARD】物理dg配置客户端无缝切换?(八.3)--客户端TAF?配置:http://blog.itpub.net/26736162/viewspace-1811944/ 【DATAGUARD】物理dg配置客户端无缝切换?(八.2)--Fast-Start?Failover?的配置:http://blog.itpub.net/26736162/viewspace-1811936/ 【DATAGUARD】物理dg配置客户端无缝切换?(八.1)--Data?Guard?Broker?的配置:http://blog.itpub.net/26736162/viewspace-1811839/ 我的oracle健康检查报告(二):http://blog.itpub.net/26736162/viewspace-1805156/ 怎样清除v$archived_log视图中的过期信息:http://blog.itpub.net/26736162/viewspace-1799884/ 我的oracle健康检查报告:http://blog.itpub.net/26736162/viewspace-1783297/ 【DATAGUARD】物理dg在主库丢失归档文件的情况下的恢复(七):http://blog.itpub.net/26736162/viewspace-1780863/ WARNING:?Heavy?swapping?observed?on?system?in?last?5?mins:http://blog.itpub.net/26736162/viewspace-1764380/ 审计数据库登陆失败触发器:http://blog.itpub.net/26736162/viewspace-1763011/ 我想大声告诉你:http://blog.itpub.net/26736162/viewspace-1762680/ 我们都在不断赶路忘记了出路:http://blog.itpub.net/26736162/viewspace-1762673/ 如何看实例的历史最大连接数?:http://blog.itpub.net/26736162/viewspace-1762656/ 【故障处理】ORA-?2730*,status?12故障分析与处理:http://blog.itpub.net/26736162/viewspace-1762342/ 【问题处理】Memory?Notification:?Library?Cache?Object?loaded?into?SGA:http://blog.itpub.net/26736162/viewspace-1762328/ 用EXP/IMP从高版本数据库导出至低版本数据库导入实验:http://blog.itpub.net/26736162/viewspace-1760580/ ORA-00600:?internal?error?code,?arguments:?[kcratr_scan_lastbwr]错误处理:http://blog.itpub.net/26736162/viewspace-1760579/ 复盘eygle在甲骨文大会上演讲中的示例,看看什么是大师的由点及面:http://blog.itpub.net/26736162/viewspace-1756210/ UPDATE子查询的ORA-1779错误:http://blog.itpub.net/26736162/viewspace-1756209/ 数据库容灾-没有最好,只有最适合:http://blog.itpub.net/26736162/viewspace-1755135/ Data?Masking-克隆“真实”的假数据:http://blog.itpub.net/26736162/viewspace-1755130/ 【DATAGUARD】物理dg的failover切换(六):http://blog.itpub.net/26736162/viewspace-1753130/ 【DATAGUARD】物理dg的switchover切换(五):http://blog.itpub.net/26736162/viewspace-1753111/ Oracle?10.2.0.4上ora-01882故障解决一例:http://blog.itpub.net/26736162/viewspace-1745402/ 【故障处理】ORA-01882:?未找到时区区域?%s:http://blog.itpub.net/26736162/viewspace-1741579/ 【故障处理】ORA-12162?错误的处理:http://blog.itpub.net/26736162/viewspace-1736192/ 【故障处理】ORA-12162:?TNS:net?service?name?is?incorrectly?specified:http://blog.itpub.net/26736162/viewspace-1735917/ 【RAC】?RAC?For?W2K8R2?安装--共享磁盘的配置(三):http://blog.itpub.net/26736162/viewspace-1721270/ RAC性能分析gc?buffer?busy?acquire?等待事件:http://blog.itpub.net/26736162/viewspace-1725871/ 如何解决enq:?TX-?index?contention:http://blog.itpub.net/26736162/viewspace-1725763/ RHEL?6/CentOS?6上安装Oracle?11.2.0.3(Gird/Database)及以上缺少pdksh包的解决方法:http://blog.itpub.net/26736162/viewspace-1721660/ 【RAC】?RAC?For?W2K8R2?安装--结尾篇(十):http://blog.itpub.net/26736162/viewspace-1721378/ 【RAC】?RAC?For?W2K8R2?安装--安装过程中碰到的问题(九):http://blog.itpub.net/26736162/viewspace-1721373/ 【RAC】?RAC?For?W2K8R2?安装--卸载(八):http://blog.itpub.net/26736162/viewspace-1721331/ 【RAC】?RAC?For?W2K8R2?安装--dbca创建数据库(七):http://blog.itpub.net/26736162/viewspace-1721324/ 【RAC】?RAC?For?W2K8R2?安装--创建ASM磁盘组(六):http://blog.itpub.net/26736162/viewspace-1721314/ 【RAC】?RAC?For?W2K8R2?安装--RDBMS软件的安装(五):http://blog.itpub.net/26736162/viewspace-1721304/ 【RAC】?RAC?For?W2K8R2?安装--grid的安装(四):http://blog.itpub.net/26736162/viewspace-1721281/ 【RAC】?RAC?For?W2K8R2?安装--操作系统环境配置?(二):http://blog.itpub.net/26736162/viewspace-1721253/ 【RAC】?RAC?For?W2K8R2?安装--总体规划?(一):http://blog.itpub.net/26736162/viewspace-1721232/ Oracle?11.2.0.4?RAC?Database?for?Windows?2012安装DB时收到[INS-35423]错误:http://blog.itpub.net/26736162/viewspace-1710840/ 使用sqld360进行特定SQL调优分析:http://blog.itpub.net/26736162/viewspace-1704097/ 使用 Linux ?Strace跟踪调试Oracle程序进程:http://blog.itpub.net/26736162/viewspace-1704086/ GoldenGate的安全配置:http://blog.itpub.net/26736162/viewspace-1699654/ 【OGG】?RAC环境下管理OGG的高可用?(五):http://blog.itpub.net/26736162/viewspace-1699536/ 【OGG】RAC环境下配置OGG单向同步?(四):http://blog.itpub.net/26736162/viewspace-1699522/ 【OGG】OGG简单配置双向复制(三):http://blog.itpub.net/26736162/viewspace-1699516/ 【OGG】OGG的单向复制配置-支持DDL(二):http://blog.itpub.net/26736162/viewspace-1696031/ 【OGG】OGG的单向DML复制配置(一):http://blog.itpub.net/26736162/viewspace-1696020/ 【OGG】OGG的下载和安装篇:http://blog.itpub.net/26736162/viewspace-1693241/ 配置GoldenGate捕获Replicat端数据应用异常:http://blog.itpub.net/26736162/viewspace-1691771/ 使用PURGEOLDEXTRACTS设置goldengate自动清除trail?file:http://blog.itpub.net/26736162/viewspace-1691236/ Oracle中如何判断一个字符串是否含有汉字(中文):http://blog.itpub.net/26736162/viewspace-1688209/ [转载]?三十不立,四十迷惑的人生?:http://blog.itpub.net/26736162/viewspace-1686288/ 修正执行计划的利器,SQL?PROFILE脚本:http://blog.itpub.net/26736162/viewspace-1686263/ 11gR2?集群管理软件(GI)?启动顺序和诊断方法简介:http://blog.itpub.net/26736162/viewspace-1686232/ exp导出出现:ORA-00904:?:?invalid?identifier:http://blog.itpub.net/26736162/viewspace-1686082/ rman备份时记录更多的log?或者trace信息:http://blog.itpub.net/26736162/viewspace-1685932/ oracle?11g?adrci??工具使用方法:http://blog.itpub.net/26736162/viewspace-1685917/ 在win7主机上为你的 Linux 虚拟机配置ntp服务:http://blog.itpub.net/26736162/viewspace-1685899/ oracle数据库dba_hist等视图中的Delta相关字段介绍:http://blog.itpub.net/26736162/viewspace-1685877/ 11g包dbms_parallel_execute在海量数据处理过程中的应用:http://blog.itpub.net/26736162/viewspace-1684396/ 配置防火墙允许从外网访问内网oracle:http://blog.itpub.net/26736162/viewspace-1683610/ 【RAC】将RAC备份集恢复为单实例数据库:http://blog.itpub.net/26736162/viewspace-1682255/ 【RAC】将单实例备份集恢复为rac数据库:http://blog.itpub.net/26736162/viewspace-1682250/ 【RAC】rac环境下的数据库备份与还原:http://blog.itpub.net/26736162/viewspace-1682237/ AIX5.3:?Too?many?processes?0403-030:http://blog.itpub.net/26736162/viewspace-1676280/ 【RMAN】RMAN脚本中使用替换变量--windows?下rman全备脚本:http://blog.itpub.net/26736162/viewspace-1673725/ 【TSPITR】RMAN表空间基于时间点的自动恢复:http://blog.itpub.net/26736162/viewspace-1671741/ 红帽 Linux ?6.5上配置ASM流程:http://blog.itpub.net/26736162/viewspace-1670842/ Alert?Log中“Fatal?NI?connect?error?12170”错误问题:http://blog.itpub.net/26736162/viewspace-1670601/ 李阳和他的疯狂英语:http://blog.itpub.net/26736162/viewspace-1670222/ 2015年5月23日?备研日:http://blog.itpub.net/26736162/viewspace-1669235/ 密码延迟验证导致的系统HANG住:http://blog.itpub.net/26736162/viewspace-1667742/ 【书评:Oracle查询优化改写】第五至十三章:http://blog.itpub.net/26736162/viewspace-1665934/ 【impdp】IMPDP中的TRANSFORM参数--【数据泵】EXPDP导出表结构(真实案例)后传:http://blog.itpub.net/26736162/viewspace-1662344/ 【IMPDP】使用?TRANSFORM选项去掉表空间和存储子句:http://blog.itpub.net/26736162/viewspace-1662276/ 【书评:Oracle查询优化改写】第三章:http://blog.itpub.net/26736162/viewspace-1660422/ 11gr2全外连接优化执行计划(三):http://blog.itpub.net/26736162/viewspace-1660092/ 11gr2全外连接优化执行计划(二):http://blog.itpub.net/26736162/viewspace-1660091/ 11gr2全外连接优化执行计划:http://blog.itpub.net/26736162/viewspace-1660089/ 11g改变了DELETE语句的执行计划:http://blog.itpub.net/26736162/viewspace-1660072/ Native?Full?Outer?Join:http://blog.itpub.net/26736162/viewspace-1660038/ 【数据泵】EXPDP导出表结构(真实案例):http://blog.itpub.net/26736162/viewspace-1657828/ 11g新增默认用户密码监测:http://blog.itpub.net/26736162/viewspace-1656003/ 【书评:Oracle查询优化改写】第二章:http://blog.itpub.net/26736162/viewspace-1654252/ 【书评:Oracle查询优化改写】第一章:http://blog.itpub.net/26736162/viewspace-1652985/ Oracle11g新特性之Replay?a?captured?workload?捕获工作负载新环境重放负载测试压力:http://blog.itpub.net/26736162/viewspace-1650000/ 【RAC】RAC安装错误手工卸载:http://blog.itpub.net/26736162/viewspace-1630145/ 10G?RAC?RAW+ASM?rhel-server-5.5-x86_64:http://blog.itpub.net/26736162/viewspace-1627708/ Oracle?11g?的?VKTM?进程?-? Virtual ?keeper?of?time:http://blog.itpub.net/26736162/viewspace-1626281/ ORA-28001:?the?password?has?expired?(DBD?ERROR:?OCISessionBegin)?EM无法登录:http://blog.itpub.net/26736162/viewspace-1626193/ ORACLE?EM?12C?监控MySQL:http://blog.itpub.net/26736162/viewspace-1626162/ MySQL?高可用MHA安装部署以及故障转移详细资料汇总:http://blog.itpub.net/26736162/viewspace-1626128/ MySQL?高可用MMM安装部署以及故障转移详细资料汇总:http://blog.itpub.net/26736162/viewspace-1626126/ OCP如何查看历史成绩:http://blog.itpub.net/26736162/viewspace-1624996/ 小麦苗BLOG文章索引:http://blog.itpub.net/26736162/viewspace-1624408/ 【RMAN】rm?-rf?误操作的恢复过程:http://blog.itpub.net/26736162/viewspace-1623938/ 【RMAN】利用备份片还原数据库:http://blog.itpub.net/26736162/viewspace-1621581/ Oracle?cols_as_rows?比对数据:http://blog.itpub.net/26736162/viewspace-1617320/ 【RAC】如何让Oracle?RAC?crs_stat?命令显示完整:http://blog.itpub.net/26736162/viewspace-1610957/ Java?资料大放送(自己总结的):http://blog.itpub.net/26736162/viewspace-1609604/ 10g?RAC?数据库更改IP及回退方案详解:http://blog.itpub.net/26736162/viewspace-1609331/ 11gR2?RAC修改IP:http://blog.itpub.net/26736162/viewspace-1609330/ 国外、国内Hadoop的应用现状:http://blog.itpub.net/26736162/viewspace-1608177/ 与oracle紧密相关的unix/ Linux 内核参数:http://blog.itpub.net/26736162/viewspace-1595179/ archive?log文件大小与redo?log文件大小关系探究:http://blog.itpub.net/26736162/viewspace-1591697/ 【DBCA?-SILENT】静默方式安装11gR2?oracle数据库软件:http://blog.itpub.net/26736162/viewspace-1589769/ 11.2静默安装碰到的错误:http://blog.itpub.net/26736162/viewspace-1588810/ 【DBCA?-SILENT】静默安装之rac数据库安装:http://blog.itpub.net/26736162/viewspace-1586352/ 【DBCA?-SILENT】静默安装如何启用归档模式:http://blog.itpub.net/26736162/viewspace-1585925/ MySQL?采用Xtrabackupex进行全库备份过程汇总:http://blog.itpub.net/26736162/viewspace-1571770/ MySQL?主从复制资料汇总:http://blog.itpub.net/26736162/viewspace-1571768/ MySQL?利用xtrabackup进行增量备份详细过程汇总:http://blog.itpub.net/26736162/viewspace-1571765/ 关于OCM数量及OCM?Profile登记:http://blog.itpub.net/26736162/viewspace-1571627/ Linux 引导过程和GRUB引导器:http://blog.itpub.net/26736162/viewspace-1571608/ 我的博客pdf文档集合:http://blog.itpub.net/26736162/viewspace-1562636/ 【RMAN】RMAN跨版本恢复(下):http://blog.itpub.net/26736162/viewspace-1562583/ Oracle?组件系列小结:http://blog.itpub.net/26736162/viewspace-1562441/ 【RMAN】RMAN跨版本恢复(中):http://blog.itpub.net/26736162/viewspace-1561352/ 【RMAN】RMAN跨版本恢复(上):http://blog.itpub.net/26736162/viewspace-1561185/ 【MOS】在不同版本和平台之间进行还原或复制?(文档?ID?1526162.1)--跨版本恢复:http://blog.itpub.net/26736162/viewspace-1549041/ 【oracle官网】?Restoring?a?Database?on?a?New?Host:http://blog.itpub.net/26736162/viewspace-1548104/ 【DATAGUARD】?将11g物理备库转换为Snapshot?Standby:http://blog.itpub.net/26736162/viewspace-1525548/ 【DATAGUARD】?基于同一个主机建立物理备库和逻辑备库?(四)--添加一个物理dg节点:http://blog.itpub.net/26736162/viewspace-1484878/ 【DATAGUARD】?基于同一个主机建立物理备库和逻辑备库?(三):http://blog.itpub.net/26736162/viewspace-1481972/ ksvcreate:?Process(m000)?creation?failed?处理:http://blog.itpub.net/26736162/viewspace-1480397/ 关于Oracle的技术问答:http://blog.itpub.net/26736162/viewspace-1472739/ glogin.sql配置不当引起sqlplus?hang的假象分析:http://blog.itpub.net/26736162/viewspace-1470432/ MySQL?Fabric使用介绍01——高可用性HA:http://blog.itpub.net/26736162/viewspace-1470366/ mysql5.6的online?ddl功能测试:http://blog.itpub.net/26736162/viewspace-1470365/ mydumper工作原理:http://blog.itpub.net/26736162/viewspace-1466393/ rman存储脚本:http://blog.itpub.net/26736162/viewspace-1466391/ MySQL索引性能测试:http://blog.itpub.net/26736162/viewspace-1466094/ MySQL?数据库备份种类以及常用备份工具汇总:http://blog.itpub.net/26736162/viewspace-1460921/ undo表空间文件丢失恢复(4)--无备份无recover的情况下恢复:http://blog.itpub.net/26736162/viewspace-1458787/ undo表空间文件丢失恢复(3)--无备份无redo的情况下恢复:http://blog.itpub.net/26736162/viewspace-1458750/ undo表空间文件丢失恢复(2)--无备份有redo的情况下恢复:http://blog.itpub.net/26736162/viewspace-1458663/ undo表空间文件丢失恢复(1)--有备份:http://blog.itpub.net/26736162/viewspace-1458654/ SQLNET跟踪tnsping过程:http://blog.itpub.net/26736162/viewspace-1455126/ DBCA静默方式建库:http://blog.itpub.net/26736162/viewspace-1448220/ 【DATAGUARD】?基于同一个主机建立物理备库和逻辑备库(二):http://blog.itpub.net/26736162/viewspace-1448207/ 【DATAGUARD】?基于同一个主机建立物理备库和逻辑备库(一)?:http://blog.itpub.net/26736162/viewspace-1448197/ ORACLE?数据泵之NETWORK_LINK:http://blog.itpub.net/26736162/viewspace-1432591/ oracle?OEM中?Accessibility?Mode?disable解决办法:http://blog.itpub.net/26736162/viewspace-1431546/ 按时间点恢复:http://blog.itpub.net/26736162/viewspace-1429425/ Oracle控制文件在缺失归档日志的情况下的恢复:http://blog.itpub.net/26736162/viewspace-1426552/ ORACLE?只读数据文件备份与恢复:http://blog.itpub.net/26736162/viewspace-1425283/ MySQL和Oracle对比学习之数据字典元数据:http://blog.itpub.net/26736162/viewspace-1423822/ Oracle的网络三大配置文件(sqlnet.ora、tnsnames.ora、listener.ora):http://blog.itpub.net/26736162/viewspace-1423799/ 热备下的测试库搭建:http://blog.itpub.net/26736162/viewspace-1405324/ 【ASM】如何创建ASM磁盘:http://blog.itpub.net/26736162/viewspace-1401193/ 【ASM】ASM数据文件和OS文件(FILESYSTEM)转移方法总结:http://blog.itpub.net/26736162/viewspace-1400516/ oracle?异构平台迁移之传输表空间一例:http://blog.itpub.net/26736162/viewspace-1391913/ Oracle?ASM存储Spfile解析:http://blog.itpub.net/26736162/viewspace-1386986/ Oracle?Restart启动数据库实例故障一例:http://blog.itpub.net/26736162/viewspace-1386980/ Oracle如何预估将要创建的索引和表的大小:http://blog.itpub.net/26736162/viewspace-1381160/ oracle?传输表空间一例:http://blog.itpub.net/26736162/viewspace-1375260/ 常见dml、ddl语句使用nologging选项所生成的redo和undo大小比较:http://blog.itpub.net/26736162/viewspace-1365636/ 11g?Database?Replay使用详解:http://blog.itpub.net/26736162/viewspace-1365208/ 运维注意事项及案例讲解(个人心得):http://blog.itpub.net/26736162/viewspace-1363522/ 利用binlog进行数据库的还原:http://blog.itpub.net/26736162/viewspace-1352600/ 利用rman来实现 Linux 平台数据库复制到windows平台数据库:http://blog.itpub.net/26736162/viewspace-1352436/ 直接复制数据文件实现 Linux 平台数据库复制到windows平台数据库:http://blog.itpub.net/26736162/viewspace-1352243/ MySQL?5.6.21下载安装之安装篇(二):http://blog.itpub.net/26736162/viewspace-1349787/ MySQL?5.6.21下载安装之下载篇(一):http://blog.itpub.net/26736162/viewspace-1349705/ SQL优化中索引列使用函数之灵异事件:http://blog.itpub.net/26736162/viewspace-1329880/ 12C?SQL方面新特性小结:http://blog.itpub.net/26736162/viewspace-1328184/ 一步一步搭建11gR2?rac+dg之结尾篇(十):http://blog.itpub.net/26736162/viewspace-1328156/ 一步一步搭建11gR2?rac+dg之DG?SWITCHOVER功能(九):http://blog.itpub.net/26736162/viewspace-1328050/ Oracle的学习路径与方法讨论:http://blog.itpub.net/26736162/viewspace-1324336/ Linux ?CPU实时监控命令mpstat介绍:http://blog.itpub.net/26736162/viewspace-1323874/ oracle同步软件技术实现对比:http://blog.itpub.net/26736162/viewspace-1323260/ 复制数据库中需要注意的几点事项:http://blog.itpub.net/26736162/viewspace-1310465/ 如何从数据库?11.2?降级至之前的版本:http://blog.itpub.net/26736162/viewspace-1310463/ ?一步一步搭建11gR2?rac+dg之配置单实例的DG(八):http://blog.itpub.net/26736162/viewspace-1298735/ 一步一步搭建11gR2?rac+dg之DG?机器配置(七):http://blog.itpub.net/26736162/viewspace-1298733/ 一步一步搭建11gR2?rac+dg之安装rac出现问题解决(六):http://blog.itpub.net/26736162/viewspace-1297128/ 一步一步搭建oracle?11gR2?rac+dg之database安装(五):http://blog.itpub.net/26736162/viewspace-1297113/ 一步一步搭建?oracle?11gR2?rac+dg之grid安装(四):http://blog.itpub.net/26736162/viewspace-1297101/ 一步一步搭建oracle?11gR2?rac+dg之共享磁盘设置(三):http://blog.itpub.net/26736162/viewspace-1291144/ 一步一步搭建oracle?11gR2?rac+dg之环境准备(二):http://blog.itpub.net/26736162/viewspace-1290416/ 一步一步搭建?oracle?11gR2?rac?+?dg??之前传?(一):http://blog.itpub.net/26736162/viewspace-1290405/ Oracle??11.2.0.1升级到11.2.0.3:http://blog.itpub.net/26736162/viewspace-1283912/ oracle??转义字符??总结:http://blog.itpub.net/26736162/viewspace-1281835/ 【IT生活】吕海波:阿里巴巴离职DBA职业生涯总结:突然35岁:http://blog.itpub.net/26736162/viewspace-1280793/ 一份DBA试题????转载:http://blog.itpub.net/26736162/viewspace-1280636/ 2011年安博培训?QQ项目演示:http://blog.itpub.net/26736162/viewspace-1280441/ 【IT技术】阿里RDS首席产品架构师何云飞:阿里云数据库的架构演进之路:http://blog.itpub.net/26736162/viewspace-1280265/ 【IT生活】成长,没有想象的那么迫切?——叶绍琛:http://blog.itpub.net/26736162/viewspace-1279641/ Oracle中对列加密的方法:http://blog.itpub.net/26736162/viewspace-1274191/ 【EZCONNECT】?sqlnet.ora文件中EZCONNECT参数与Easy?Connect?Naming?Method方法:http://blog.itpub.net/26736162/viewspace-1273938/ 外键列上是否需要索引:http://blog.itpub.net/26736162/viewspace-1273166/ Oracle行列互换总结:http://blog.itpub.net/26736162/viewspace-1272538/ itpub坛友问题--基于普通表或分区表创建索引,会占用临时表空间及何时回收临时表空间:http://blog.itpub.net/26736162/viewspace-1271376/ 用冷备份技术快速将DB迁移到新机器:http://blog.itpub.net/26736162/viewspace-1268191/ 关于under?any?table/view?权限的解释:http://blog.itpub.net/26736162/viewspace-1266876/ Oracle?数据库官方申明不支持Vmware:http://blog.itpub.net/26736162/viewspace-1263389/ 【SQL监控】SQL完全监控的脚本:http://blog.itpub.net/26736162/viewspace-1262559/ 统计信息不准确导致执行计划走了笛卡尔积:http://blog.itpub.net/26736162/viewspace-1254942/ OCP—051试题:http://blog.itpub.net/26736162/viewspace-1252569/ 11.2.0.2的SPM的一个bug:http://blog.itpub.net/26736162/viewspace-1248506/ update修改为merge(max+decode):http://blog.itpub.net/26736162/viewspace-1244055/ 将游标修改为建表来提高效率:http://blog.itpub.net/26736162/viewspace-1244050/ 一个insert插入语句很慢的优化:http://blog.itpub.net/26736162/viewspace-1244044/ rman?backup遇到ORA-19811:http://blog.itpub.net/26736162/viewspace-1225709/ ocp|ocm考证系列文章!:http://blog.itpub.net/26736162/viewspace-1225695/ 使用OEM复制数据库:http://blog.itpub.net/26736162/viewspace-1224865/ 采用DUPLICATE?把asm数据库复制到文件系统:http://blog.itpub.net/26736162/viewspace-1224861/ Duplicating?a?Database?Without?Recovery?Catalog?or?Target?Connection:http://blog.itpub.net/26736162/viewspace-1223253/ Duplicating?an?Active?Database:http://blog.itpub.net/26736162/viewspace-1223247/ 都是标量子查询惹的祸:http://blog.itpub.net/26736162/viewspace-1222431/ 采用merge语句的非关联形式再次显神能:http://blog.itpub.net/26736162/viewspace-1222423/ 采用MERGE语句的非关联形式提升性能?---后传:http://blog.itpub.net/26736162/viewspace-1222417/ Oracle的告警日志之v$diag_alert_ext视图:http://blog.itpub.net/26736162/viewspace-1221559/ 采用MERGE?语句的非关联形式提升性能:http://blog.itpub.net/26736162/viewspace-1218671/ 使用PLSQL?Developer?来查看官方文档:http://blog.itpub.net/26736162/viewspace-1217589/ 自己听公开课的时候一些录像?+?oracle?各种系统下安装文件:http://blog.itpub.net/26736162/viewspace-1217099/ 如何批量处理word中的表格:http://blog.itpub.net/26736162/viewspace-1216192/ OCP?1Z0-053?第1~30题:http://blog.itpub.net/26736162/viewspace-1216100/ Oracle的SYS用户登录报权限不足(ORA-01031:?insufficient?privileges):http://blog.itpub.net/26736162/viewspace-1214946/ 从执行计划的预估行数看执行计划是否正确:http://blog.itpub.net/26736162/viewspace-1209796/ 走了索引为啥还像蜗牛一样?:http://blog.itpub.net/26736162/viewspace-1208814/ 表空间暴涨原因核查:http://blog.itpub.net/26736162/viewspace-1205641/ 如何查看windows下的Oracle进程:http://blog.itpub.net/26736162/viewspace-1205532/ 【ASM】Oracle?ASM?+?11gR2?+?RHEL6.5?安装:http://blog.itpub.net/26736162/viewspace-1205206/ 如何离线在itpub上发表博文:http://blog.itpub.net/26736162/viewspace-1202069/ o(︶︿︶)o?唉,总是没有十全十美的:http://blog.itpub.net/26736162/viewspace-1202038/ 打算写技术博客前传之家的寻找:http://blog.itpub.net/26736162/viewspace-1200120/
?
原Python爬虫代码:
import?requests import?re url?=?'http://blog.itpub.net/26736162/list/%d/' pattern=re测试数据pile(r'<a?target=_blank?href="(.*?)"?class="w750"><p?class="title">(.*?)</p></a>') #pattern=re测试数据pile(r'<a?target=_blank?href="(.*?)"?class="w750"><p?class="title">') #ret=pattern.findall(data) #print(''.join(ret)) def?write2file(items): ????with?open('./download/lhrbest_itpub_link_title.txt','a',encoding='utf-8')?as?fp: ????????for?item?in?items: ????????????item=item[::-1] ????????????s=':'.join(item) ????????????#?print('----',len(items)) ????????????fp.write(s+'\n') ????????????#?fp.write('---------------------------------------------------------------\n') ????pass headers?=?{'User-Agent':'Mozilla/5.0?(Windows?NT?10.0;?WOW64)?AppleWebKit/537.36?(KHTML,?like?Gecko)?Chrome/63.0.3239.84?Safari/537.36'} def?loadHtml(page): ????if?page?>=?1: ????????for?p?in?range(1,page+1): ????????????url_itpub?=?url%(p) ????????????print(url_itpub) ????????????response?=?requests.get(url=url_itpub,headers?=?headers) ????????????response.encoding?=?'utf-8' ????????????content?=?response.text ????????????#?print(content) ????????????#?Ctrl?+?Alt?+?V:提取变量 ????????????items?=?pattern.findall(content) ????????????#?print(items) ????????????write2file(items) ????????pass ????else: ????????print('请输入数字!!!') ????pass if?__name__?==?'__main__': ????page?=?int(input('请输入需要爬取多少页:')) ????loadHtml(page)
?
? ?代码很简单,后续再优化处理。本文第一篇,因为后续还需要将所有的博客保存成html格式到本地。
About Me
........................................................................................................................
● 本文作者:小麦苗,部分内容整理自网络,若有侵权请联系小麦苗删除
● 本文在itpub( http://blog.itpub.net/26736162 )、博客园( http://HdhCmsTestcnblogs测试数据/lhrbest )和个人weixin公众号( xiaomaimiaolhr )上有同步更新
● 本文itpub地址: http://blog.itpub.net/26736162
● 本文博客园地址: http://HdhCmsTestcnblogs测试数据/lhrbest
● 本文pdf版、个人简介及小麦苗云盘地址: http://blog.itpub.net/26736162/viewspace-1624453/
● 数据库笔试面试题库及解答: http://blog.itpub.net/26736162/viewspace-2134706/
● DBA宝典今日头条号地址: http://HdhCmsTesttoutiao测试数据/c/user/6401772890/#mid=1564638659405826
........................................................................................................................
● QQ群号: 230161599 (满) 、618766405
● weixin群:可加我weixin,我拉大家进群,非诚勿扰
● 联系我请加QQ好友 ( 646634621 ) ,注明添加缘由
● 于 2018-12-01 06:00 ~ 2018-12-31 24:00 在魔都完成
● 最新修改时间:2018-12-01 06:00 ~ 2018-12-31 24:00
● 文章内容来源于小麦苗的学习笔记,部分整理自网络,若有侵权或不当之处还请谅解
● 版权所有,欢迎分享本文,转载请保留出处
........................................................................................................................
● 小麦苗的微店 : https://weidian测试数据/s/793741433?wfr=c&ifr=shopdetail
● 小麦苗出版的数据库类丛书 : http://blog.itpub.net/26736162/viewspace-2142121/
● 小麦苗OCP、OCM、高可用网络班 : http://blog.itpub.net/26736162/viewspace-2148098/
● 小麦苗腾讯课堂主页 : https://lhr.ke.qq测试数据/
........................................................................................................................
使用 weixin客户端 扫描下面的二维码来关注小麦苗的weixin公众号( xiaomaimiaolhr )及QQ群(DBA宝典)、添加小麦苗weixin, 学习最实用的数据库技术。
........................................................................................................................
?
?
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26736162/viewspace-2286553/,如需转载,请注明出处,否则将追究法律责任。
查看更多关于【爬虫】利用Python爬虫爬取小麦苗itpub博客的所有文章的连接地址(1)的详细内容...