给Oracle年轻的初学者的几点建议

askMaclean 技术博客文章入口:https://www.askmaclean.com/posts

ORACLE DB 技术学习QQ群号: 171092051

 

服务热线 : 13764045638   QQ号:47079569   邮箱:service@parnassusdata.com

ORACLE PRM-DUL是诗檀软件独立研发的ORACLE数据库灾难恢复软件,其具有全程图形化界面、简单高效等特点。

 

点击下载ORACLE PRM-DUL

点击下载PRM-DUL用户使用手册

【视频教程】点击观看PRM-DUL使用视频

 

 

刘相兵(Maclean Liu):

 

Maclean Liu, 诗檀(上海)软件系统有限公司(ParnassusData Software , Inc.) 联合创始人,联系诗檀软件。

同时Maclean也是上海Oracle用户组(Shanghai Oracle Users Group)的创始人之一。

拥有8年数据库领域从业经验,目前在甲骨文公司中国上海工作,离开Oracle甲骨文中国后创建了诗檀软件公司(ParnassusData Software) 。

所服务的行业包括电信运营商、通讯设备制造商、银行、金融业等。

主要客户包括:

工商银行、中国银行、交通银行、外汇交易中心、中国人寿保险、浦发银行、上海银行、人民银行、银联数据、银商资讯、太平人寿保险

上海电信、上海联通、上海移动、浙江电信、湖北电信、湖北联通、湖北移动、江苏移动、德邦物流、东方航空

Maclean Liu对研究Oracle 内部原理、新特性、高可用和性能调优饶有兴趣,同时撰写了大量Oracle数据库技术相关的专题文章。

Maclean Liu愿意通过网络同大家分享Oracle知识和经验,也愿意在能力范围能帮助大家解决实际工作中遇到的问题。

视角不同,不一样的Oracle!

 

Maclean Liu 的TIMELINE:

 

askmaclean-blogoracle-842x1024

oracle-ace4

oracle_ace3

oracle_ace2

专题 标题 地址
Oracle性能调优 【视频教学:性能优化】Maclean Liu的Oracle性能优化讲座第一回《真正读懂Oracle SQL执行计划》 https://www.askmaclean.com/archives/read-sql-execution-plan.html
【技术分享】开Oracle调优鹰眼,深入理解AWR性能报告  第一讲 https://www.askmaclean.com/archives/awr-hawk-eyes-training.html
【技术分享】开Oracle调优鹰眼,深入理解AWR性能报告  第二讲 https://www.askmaclean.com/archives/awr-tuning-hawk-eyes.html
【AskMaclean技术分享Oracle数据库优化】AWR鹰眼系列AWR报告全面指标分析 https://www.askmaclean.com/archives/awr-tuning-doc.html
【Maclean Liu技术分享】拨开Oracle优化器迷雾探究Histogram之秘 http://t.askmaclean.com/thread-2172-1-1.html
Maclean讲SQL调优精要 http://t.askmaclean.com/thread-2702-1-1.html
Maclean技术分享Oracle数据库优化经验- ADDM DBA http://t.askmaclean.com/thread-2607-1-1.html
Maclean教你读Oracle 10046 SQL TRACE https://www.askmaclean.com/archives/maclean-10046-sql-trace.html
Maclean教你读SQL TRACE TKProf报告 https://www.askmaclean.com/archives/maclean-tech-tkprof-10046.html
Maclean博客Oracle SQL性能优化专题 https://blogs.oracle.com/askmaclean/entry/oracle_sql%E6%80%A7%E8%83%BD%E4%BC%98%E5%8C%96%E4%B8%93%E9%A2%98
Oracle基础学习篇 Maclean的Oracle基础学习攻略 http://t.askmaclean.com/thread-2699-1-1.html
【仍在连载中】maclean liu的oracle学习经历 http://t.askmaclean.com/thread-1485-1-1.html
【Maclean技术分享】学习甲骨文数据库的自由之翼 http://t.askmaclean.com/thread-2560-1-1.html
Oracle学前Unix/Linux基础 https://www.askmaclean.com/archives/video-learn-oracle-unix.html
新来的去学习Oracle前的准备知识 做题目,做完给出成绩 http://www.dbdao.com/dba-road/learn-before-start-oracle/1
【AskMaclean技术分享】Oracle dba必须的技能列表 http://t.askmaclean.com/thread-3256-1-1.html
【技术分享】DBA十大核心竞争力 基于Oracle TRACE的故障诊断 http://t.askmaclean.com/thread-2347-1-1.html
RAC安装篇 Maclean教你用Vbox安装 10g/11g RAC cluster 信息汇总贴 http://t.askmaclean.com/thread-2067-1-1.html
【Maclean Liu技术分享】12c 12.1.0.1 RAC安装教学视频  基于Vbox+Oracle Linux 5.7 http://t.askmaclean.com/thread-2667-1-1.html
 [视频教学]Maclean教你用Vbox在Enterprise Linux 5安装Oracle 10gR2 RAC 10g RAC按照这个装不会有任何问题 http://t.askmaclean.com/thread-891-1-1.html
【视频教学】Maclean教你用Vbox在Linux 5安装Oracle 11gR2 RAC 11g RAC按照这个装不会有任何问题 http://t.askmaclean.com/thread-1061-1-1.html
【视频教学】Maclean教你用Vbox在Linux 6.3上安装Oracle 11gR2 RAC 11g RAC按照这个装不会有任何问题 http://t.askmaclean.com/thread-2007-1-1.html
DataGuard Standby篇 【Maclean Liu视频技术分享】11g ocm考纲复习Active Data Guard http://t.askmaclean.com/thread-2530-1-1.html
11g/12c新特性 升级到11g 必备工具:一张列表帮助你摆脱升级11gR2带来的烦恼 http://t.askmaclean.com/thread-1642-1-1.html
Maclean 研究12c新特性篇,Oracle Database 12c新特性汇总页面 https://blogs.oracle.com/askmaclean/entry/oracle_database_12c%E6%96%B0%E7%89%B9%E6%80%A7
other Maclean 的Oracle数据恢复专题 https://blogs.oracle.com/askmaclean/entry/oracle%E6%95%B0%E6%8D%AE%E6%81%A2%E5%A4%8D%E4%B8%93%E9%A2%98
关于Maclean 个人的介绍 https://www.askmaclean.com/know-maclean-liu
https://blogs.oracle.com/askmaclean/
以上部分视频的下载地址 http://www.dbdao.com/streams

 

11g ocm 相关博文:

 

数据库恢复的配置 https://www.askmaclean.com/archives/11g-ocm-student-guide-backup-restore.html
配置备份的规范 https://www.askmaclean.com/archives/dbdao-11g-oracle-ocm-2.html
使用RMAN创建备份 https://www.askmaclean.com/archives/oracle-11g-ocm-rman.html
使用RMAN执行恢复 https://www.askmaclean.com/archives/oracle-11g-ocm-master-rman-restore.html
SPA https://www.askmaclean.com/archives/oracle-11g-ocm-spa.html
SQL执行计划管理 https://www.askmaclean.com/archives/oracle-11g-ocm-spm.html
grid control 架构 https://www.askmaclean.com/archives/oracle-11g-ocm-grid-control-architecture.html
grid control 安装 https://www.askmaclean.com/archives/oracle-11g-ocm-grid-control-install.html
配置EMGC https://www.askmaclean.com/archives/oracle-11g-ocm-setemgc.html
Oracle Data Guard 介绍 https://www.askmaclean.com/archives/oracle-11g-ocm-dg.html
使用SQL和RMAN命令来创建一个物理备库 https://www.askmaclean.com/archives/oracle-11g-ocm-create-dg.html
oracle Data Guard Broker:概述 https://www.askmaclean.com/archives/oracle-data-guard-broker.html
配置 DataGuard 保护模式 https://www.askmaclean.com/archives/oracle-11g-ocm-data-mode.html
grid 安装 https://www.askmaclean.com/archives/oracle-11g-install-grid.html
管理Oracle 集群 https://www.askmaclean.com/archives/oracle-11g-ocm-manage-clusterware.html
RAC数据库安装 https://www.askmaclean.com/archives/oracle-11g-ocm-rac-install.html
数据库安全与审计 https://www.askmaclean.com/archives/oracle-11g-ocm-audit.html
物化视图和分区表 https://www.askmaclean.com/archives/oracle-11g-ocm-materializedview.html
并行和传输表空间 https://www.askmaclean.com/archives/oracle-11g-ocm-parallel.html
SQL*Loader和外部表 https://www.askmaclean.com/archives/oracle-11g-ocm-sqlloader.html
手动建库和基本数据库管理 https://www.askmaclean.com/archives/oracle-11g-ocm-createdatabase.html

 

11g OCP 考试题库中英分析:

【诗檀学院】Oracle 11g OCP-051考试题库中英文对照详解

【诗檀学院】Oracle 11g OCP-052考试题库中英文对照详解

【诗檀学院】Oracle 11g OCP-053考试题库中英文对照详解

 

Oracle (OTN) Discussion Forum User Profile:https://community.oracle.com/people/LiuMaclean(%E5%88%98%E7%9B%B8%E5%85%B5)

微博 : http://weibo.com/liumaclean

He is very influential person in Oracle Database community in China and Asia-Pacific. He would like to answer Questions Posted on both OTN and other Oracle Forum, till now he had answered about 4000 Oracle Database Questions on internet.

  1. Maclean has been very active with the community and setup a Q&A section on his blog, amazingly 4000+ Oracle RDBMS questions had been answered by him.
  2. Maclean published several introduction videos about Oracle technology to the internet and they are widely watched by Chinese audience.
  3. Active Shanghai Oracle User Group field activities participant and organizer.
  4. A qualified evangelist for Oracle 12c and Exadata products.
  5. Have a special passion on Oracle database related products, eager to share his Oracle knowledge with the community every day.

 

Oracle 相关博客: https://www.askmaclean.com/Ask Maclean Oracle 技术论坛http://t.askmaclean.com/  超过2200名邀请会员
发表的白皮书或专题 《深入理解Oracle SQL执行计划》中文http://t.askmaclean.com/forum.php?mod=attachment&aid=MjQ4MnxmMjYzODY1MXwxMzk4Nzc2MjAxfDF8MzIzNw%3D%3D《Oracle Histogram直方图的秘密》in Chinesehttp://www.slideshare.net/liumaclean/maclean-liuoracle-cbohistogram-0321《Oracle Database tuning: Hawk Eyes on AWR I》http://t.askmaclean.com/forum.php?mod=attachment&aid=MTU2M3w0MWUwMGM4NXwxMzg0MDAyNzUzfDJ8MjA4Ng%3D%3D《Oracle Database tuning: Hawk Eyes on AWR II》http://t.askmaclean.com/forum.php?mod=attachment&aid=MTczMnwwZjBhY2M0YXwxMzg0MDAyMzgyfDJ8MjIzOQ%3D%3D《Know more about Oracle Latch from 9i》https://www.askmaclean.com/archives/oracle-latch.html《Oracle Database 12c New Features》https://www.askmaclean.com/archives/12c-new-feature-summary.html《know more about Oracle Mutex》http://www.slideshare.net/liumaclean/maclean-liuoraclemutex《Oracle Background Process SMON: Something you don’t know》http://www.slideshare.net/liumaclean/smon《Essential oracle security internal for dba》 http://www.slideshare.net/liumaclean/essential-oracle-security-internal-for-dba-13569701《Oracle SQL tuning Essentials》http://t.askmaclean.com/forum.php?mod=attachment&aid=MjA5N3w0Yjk5ZmQwZXwxMzczODgyNDQyfDJ8MjcwMg%3D%3D《Oracle Tuning: An ADDM DBA》http://t.askmaclean.com/forum.php?mod=attachment&aid=MjAyNHxhNzYxNTU2YXwxMzcyMDYzNTY0fDJ8MjYwNw%3D%3D《Know more about Enqueue Deadlock Detection》https://www.askmaclean.com/archives/know-more-about-enqueue-deadlock-detection.html《MINSCN AND Cache Fusion Read Consistent》https://www.askmaclean.com/archives/minscn%E4%B8%8Ecache-fusion-read-consistent.html《Index Cluster factor can slowdown your delete》Who pulls the background process dbwr’s trigger? https://www.askmaclean.com/archives/who-pulls-the-background-process-dbwrs-trigger.html《Oracle AWR Statistics Explained》《Something About RAC Brain Split》http://www.slideshare.net/liumaclean/oracle-rac-brain-split-resolution

 

《11g New Feature: Online Hot Patching》http://www.slideshare.net/liumaclean/11g-online-patching

《Know more about Oracle Critical Patch Update》http://www.slideshare.net/liumaclean/oracle-critical-patch-update

网络会议与视频分享

  1. 《How to Learn Oracle Database: Wings of liberty》  https://zcdn.askmaclean.com/%E5%AD%A6%E4%B9%A0%E7%94%B2%E9%AA%A8%E6%96%87%E6%95%B0%E6%8D%AE%E5%BA%93%E7%9A%84%E8%87%AA%E7%94%B1%E4%B9%8B%E7%BF%BC-%E4%B8%8EOracle%E7%9A%84%E4%B8%96%E7%95%8C%E7%9B%B8%E8%BF%9E%E6%8E%A5.mp4
  2. 《Install 11gR2 RAC Using VirtualBox Best Practice》http://www.tudou.com/programs/view/xAOpQowNlU0/
  3. 《Install 10gR2 RAC Using VirtualBox Best Practice》http://t.askmaclean.com/thread-891-1-1.html
  4. 《Install 12.1.0.1 RAC Using VirtualBox Best Practice》http://www.tudou.com/programs/view/rPYR4H6GKZ8/?bid=03&pid=02&resourceId=78129035_03_05_02
  5. 《Oracle Database tuning: Hawk Eyes on AWR I》 https://zcdn.askmaclean.com/%E3%80%90Maclean%20Liu%E6%8A%80%E6%9C%AF%E5%88%86%E4%BA%AB%E3%80%91%E5%BC%80Oracle%E8%B0%83%E4%BC%98%E9%B9%B0%E7%9C%BC%EF%BC%8C%E6%B7%B1%E5%85%A5%E7%90%86%E8%A7%A3AWR%E6%80%A7%E8%83%BD%E6%8A%A5%E5%91%8A.mp4
  6. 《Oracle Database tuning: Hawk Eyes on AWR I》 https://zcdn.askmaclean.com/oracle%20awr%20hawk%202.mp4
  7. 《Oracle数据库的保护之手》  http://v.youku.com/v_show/id_XODc3MDIwOTQ0.html
  8. Oracle COE team的数据库优化诊断课程  http://ke.qq.com/cgi-bin/courseDetail?course_id=79462
  9. Oracle课程体系与就业前景 https://zcdn.askmaclean.com/Oracle%E8%AE%A4%E8%AF%81%E4%BD%93%E7%B3%BB%20%E8%AF%BE%E7%A8%8B%E4%BD%93%E7%B3%BB%20%E5%B0%B1%E4%B8%9A%E5%89%8D%E6%99%AF.mp4
  10. 升级到Oracle 12c的新式武器 upgrade to oracle 12c new features: http://i.sinobasedm.com/webcast/site/vod/play-5a30a95f89b94aceb8cef93b856aa86f

会议演讲

    1. SHOUG Forum COLLABORATE 14: 《Oracle Database 12c New Feature:Information Lifecycle Management ILM and Storage Enhancements》  https://www.askmaclean.com/archives/12c-ilm.html
    1. SHOUG Forum COLLABORATE 13 : 《Oracle Database 12c New Feature:12c Pluggable Database Container Database》  https://www.askmaclean.com/archives/pluggable-container-db-12c.html
    1. Orcl-Con 2014 :http://f.shoug.info/?/question/16    《oracle数据库的保护之手》
    1. Oracle ACS 技术研讨会: 《Oracle Tuning: An ADDM DBA》http://t.askmaclean.com/forum.php?mod=attachment&aid=MjAyNHxhNzYxNTU2YXwxMzcyMDYzNTY0fDJ8MjYwNw%3D%3D
  1. 2015 china oracle database conference: https://www.askmaclean.com/archives/90-gen-oracle-meeting.html   ,  《oracle可视化和智能调优》  –  《 oracle visual and addm tunning》

Leave a Reply

Your email address will not be published. Required fields are marked *

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569