数据库生态圈(RDB & NoSQL & Bigdata)——专注于关系库优化(Oracle & Mysql & Postgresql & SQL Server )

https://www.cnblogs.com/lhdz_bj
http://blog.itpub.net/8484829
https://blog.csdn.net/tuning_optmization
https://www.zhihu.com/people/lhdz_bj

导航

我的标签 排序: 自定义 | 博文数 | 标签名

Oracle (114) patch (2) pin (1) 重优化 (1)
SQL (55) parallel (2) physical (1) 重用 (1)
优化 (40) ora-00600 (2) physical (1) 重要 (1)
tuning (38) option (2) para (1) 终止 (1)
调优 (35) optim (2) paging (1) 智能 (1)
12c (31) NTP (2) page (1) 指令 (1)
linux (29) mongodb (2) over (1) 正常 (1)
optimi (24) memory (2) oracle12c (1) 占有 (1)
性能 (24) local (2) oracle10g (1) 展望 (1)
feature (23) library (2) oracle10g (1) 增加 (1)
new (20) level (2) ora2pg (1) 运行 (1)
分析 (20) join (2) ora-07445 (1) 运维 (1)
tun (19) insert (2) OPTIMIZE FOR (1) 运维 (1)
诊断 (19) hiden (2) operation (1) 远程 (1)
server (18) hang (2) openssl (1) 源码 (1)
mysql (18) ground (2) openssh (1) 原理 (1)
performance (17) grid (2) openfiler (1) 元数据 (1)
troubleshooting (16) grant (2) net (1) 游标 (1)
plan (13) global (2) mysqld (1) (1)
新特性 (13) function (2) myisam (1) 用法 (1)
trouble (12) drop (2) my (1) 应用 (1)
rac (12) distri (2) mvcc (1) 隐式结果 (1)
shoot (11) direct (2) MV (1) 异步 (1)
安装 (11) dbcc (2) mutex (1) 一致性 (1)
mongo (10) dataguard (2) MSSQL (1) 要点 (1)
install (10) ctl (2) mount (1) 压缩 (1)
数据库 (10) create (2) monitor (1) 修改 (1)
配置 (10) case (2) monitor (1) 性能分析器 (1)
11g (10) bug (2) mongdb (1) 行锁 (1)
table (9) block (2) mod (1) 信息 (1)
postgres (9) binary (2) MM (1) 心跳 (1)
pg (9) back (2) migration (1) 限制 (1)
index (9) automatic (2) migrate (1) 先导列 (1)
AIX (9) access (2) metalink (1) 系统 (1)
postgresql (8) 字段 (2) meta (1) 误区 (1)
peformance (8) 执行计划 (2) message (1) 物理 (1)
pdb (8) 真谛 (2) mechnism (1) 物理 (1)
cdb (8) 涨势 (2) mechanism (1) 物化视图 (1)
参数 (8) 增强 (2) mechan (1) 文件 (1)
hive (7) 语法 (2) max (1) 未来 (1)
explain (7) 隐藏 (2) materialize (1) 唯一 (1)
DB2 (7) 选项 (2) master (1) 外部表 (1)
config (7) 未归档 (2) map (1) 提示 (1)
索引 (7) 网络 (2) manual (1) 探讨 (1)
管理 (7) 特性 (2) manag (1) (1)
故障 (7) 删除 (2) make (1) 宿主 (1)
分析诊断 (7) 容器 (2) machine (1) 死锁 (1)
optimiz (6) 全局 (2) lvm (1) 双主 (1)
log (6) 启动 (2) lv (1) (1)
lock (6) 内部 (2) lv (1) 刷新 (1)
database (6) (2) local index (1) 数据库设计 (1)
command (6) 精要 (2) live (1) 数据库内 (1)
centos (6) 解析 (2) listener (1) 数据泵 (1)
可插拔 (6) 截断 (2) link (1) 数据 (1)
计划 (6) 脚本 (2) limit (1) 输出 (1)
transaction (5) 交换 (2) latch (1) 手工 (1)
thread (5) 集群 (2) large (1) 收集 (1)
temp (5) 回顾 (2) keepalived (1) 事故 (1)
SQL tuning (5) 缓冲 (2) job (1) 事故 (1)
source (5) 核心 (2) isolation (1) 市场 (1)
process (5) 跟踪 (2) iscsi (1) 实验 (1)
pool (5) (2) iostat (1) 实例 (1)
parameter (5) 复杂 (2) IO (1) 时钟 (1)
open (5) 访问 (2) interface (1) 时间 (1)
network (5) 方法 (2) impdp (1) 失败 (1)
multi (5) 多宿主 (2) impdp (1) 生命 (1)
memo (5) 动态 (2) ILM (1) 设计 (1)
hbase (5) 调整 (2) identity (1) 设备 (1)
hadoop (5) 触发器 (2) hugepage (1) 闪存 (1)
event (5) (2) hid (1) (1)
conf (5) 常用 (2) heat (1) 软件 (1)
cache (5) 查询 (2) heart (1) 容错 (1)
asm (5) 表空间 (2) hdfs (1) 热度图 (1)
日志 (5) (2) hash_area (1) 权限 (1)
内存 (5) 本地 (2) hang住 (1) 全库 (1)
命令 (5) 版本 (2) habase (1) 取样 (1)
快速 (5) 2017 (2) GUI (1) 趋势 (1)
机制 (5) 11.2.0.1 (2) group (1) 区间 (1)
案例 (5) 11.1.0.6 (2) global index (1) 区别 (1)
7 (5) ,配置 (2) general (1) 清理 (1)
wait (4) write (1) FUNC (1) 切换 (1)
view (4) worker (1) full (1) 迁移 (1)
undo (4) workarea (1) ftp (1) (1)
tablespace (4) with (1) FS (1) 批量 (1)
setup (4) wirte (1) flush (1) 盘区 (1)
post (4) win (1) flume (1) 排障 (1)
pluggable (4) webshell (1) flash (1) (1)
path (4) vmstat (1) flag (1) 木马 (1)
mysq (4) VLM (1) fix (1) 模型 (1)
multipath (4) vip (1) file-per-table (1) 明显 (1)
maintenance (4) varchar2 (1) federated (1) 芒果库 (1)
kill (4) validate (1) fdw (1) (1)
hint (4) v$ (1) fast (1) (1)
file (4) user (1) failover (1) 临时表 (1)
DEV (4) use (1) external (1) 临时 (1)
data (4) usage (1) extent (1) (1)
buffer (4) unit (1) execut (1) 联合表 (1)
AWR (4) type (1) exec (1) 连接 (1)
线程 (4) tune (1) exchange (1) (1)
开发 (4) trx (1) enqueue:tx (1) (1)
进程 (4) troubleshoot (1) enqueue (1) 崛起 (1)
海量 (4) tree (1) enq (1) 局部 (1)
工具 (4) trans (1) enhance (1) 静默 (1)
高性能 (4) trace (1) dynamic (1) 解决 (1)
大幅 (4) tip (1) down (1) 结果 (1)
存储 (4) time (1) dns (1) 结构 (1)
11.2 (4) temporary (1) distribute (1) 监听 (1)
version (3) telnet (1) distrib (1) 监控 (1)
upgrade (3) task (1) distinct (1) 计数 (1)
trigger (3) target (1) disctionary (1) 级联 (1)
tool (3) systemctl (1) directive (1) 基石 (1)
system (3) sysaux (1) dictionary (1) 基本操作 (1)
sync (3) syn (1) diag (1) 基本 (1)
spark (3) swtich (1) desktop (1) 机器 (1)
share (3) swap (1) delete (1) 获取 (1)
session (3) suse (1) declare (1) 互相 (1)
root (3) subquery (1) deadlock (1) 互访 (1)
restore (3) sub (1) dbms_sql (1) 夯住 (1)
redo (3) stream (1) dblink (1) 函数 (1)
query (3) stop (1) cursor (1) 归档 (1)
partition (3) ssl (1) CTSS (1) 挂载 (1)
param (3) sqoop (1) count (1) 固定表 (1)
os (3) SQLPA (1) copy (1) 固定 (1)
OPTI (3) spm (1) control (1) 功能 (1)
management (3) split (1) consistent (1) 更新 (1)
manage (3) spid (1) connection (1) 改写 (1)
keep (3) sort_area (1) configure (1) 复制集 (1)
instance (3) software (1) concurrence (1) 复合 (1)
innodb (3) snoop (1) concurr (1) 分页 (1)
guard (3) smon (1) concept (1) 分析器 (1)
explain plan (3) slave (1) composite (1) 分片 (1)
expdp (3) single (1) commit (1) 分配 (1)
disk (3) silent (1) COM (1) 方式 (1)
DG (3) shooting (1) collect (1) 范围 (1)
db (3) shell (1) code (1) 发展 (1)
CPU (3) sharing (1) cnf (1) 二进制 (1)
column (3) shared (1) clone (1) 多线程 (1)
cluster (3) sharding (1) clob (1) 队列 (1)
architecture (3) shar (1) clear (1) 电信 (1)
analyze (3) sga (1) clean (1) 递归 (1)
自动 (3) sftp (1) clause (1) 等待事件 (1)
执行 (3) servive (1) chd (1) 等待 (1)
维护 (3) secu (1) CBO (1) 单位 (1)
同步 (3) scripts (1) cascade (1) 单实例 (1)
视图 (3) SCN (1) call (1) 代码 (1)
事务 (3) scheduler (1) by (1) 代理 (1)
事件 (3) sampl (1) bundle (1) 大小 (1)
使用 (3) safe (1) broker (1) 打开 (1)
升级 (3) rpm (1) bond (1) 搭建 (1)
开源 (3) rowid (1) bind (1) 磁盘 (1)
架构 (3) row (1) beat (1) 创建 (1)
恢复 (3) route (1) bdb (1) 憧憬 (1)
后台 (3) rollback (1) batched (1) 常用命令 (1)
关系库 (3) rh linux (1) batch (1) 常用脚本 (1)
共享 (3) rh (1) basic (1) (1)
高级、 (3) revovery (1) backup (1) 查杀 (1)
概念 (3) revoke (1) background (1) 步骤 (1)
分区 (3) reuse (1) b*tree (1) 不同 (1)
分布式 (3) result (1) b-tree (1) (1)
参考 (3) request (1) auto (1) 补丁 (1)
10g (3) repl (1) asyn (1) 并行 (1)
zookeeper (2) reoptimization (1) archiv (1) 并发 (1)
x$ (2) rename (1) APPROX_COUNT_DISTINCT (1) 表空间组 (1)
wait event (2) reliable (1) appl (1) 标志 (1)
vg (2) ref (1) append (1) 变形 (1)
utility (2) redis (1) analyzer (1) 比较 (1)
update (2) redhat (1) Analytic (1) (1)
unix (2) recurs (1) analy (1) 本质 (1)
undocument (2) recover (1) anal (1) 备份 (1)
udev (2) RDBMS (1) alter (1) 爆满 (1)
truncate (2) rcp (1) alter (1) 保障 (1)
structure (2) queue (1) alived (1) 安全 (1)
store (2) QUERYTRACEON (1) advance (1) 5.7 (1)
storage (2) QUERYTRACEOFF (1) administration (1) 2018 (1)
ssh (2) pv (1) administr (1) 2016 (1)
solaris (2) pv (1) add (1) 2012 (1)
size (2) pump (1) adaptive (1) 11.2.0 (1)
shard (2) PSU (1) acs (1) 11.1.0.7 (1)
run (2) profiler (1) 子句 (1) 10.4 (1)
replica (2) profile (1) 自适应 (1) ,问题 (1)
recovery (2) procedure (1) 字典 (1) ,文件 (1)
read (2) prefix (1) 桌面 (1) ,实例 (1)
proc (2) pralell (1) 注意 (1) ,切换 (1)
priv (2) pq (1) 主备 (1) ,程序 (1)
pmon (2) posgresql (1) 周期 (1) (1)
pl (2) plug (1) 重做 (1)