Skip to content

Commit 581f01c

Browse files
committed
update
1 parent c9fa4eb commit 581f01c

File tree

1 file changed

+34
-10
lines changed

1 file changed

+34
-10
lines changed

DB学习之路.md

Lines changed: 34 additions & 10 deletions
Original file line numberDiff line numberDiff line change
@@ -118,30 +118,46 @@
118118
* http://docs.oracle.com/en/bigdata/
119119

120120
* dbms_lob.substr[DBMS_LOB -> SUBSTR]: http://docs.oracle.com/database/122/ARPLS
121+
121122
* lsnrctl的用法[Configuring the Network Environment -> lsnrctl]: http://docs.oracle.com/database/122/ADMQS
123+
* 配置系统环境变量[Getting Started with Database Administration -> Configuring the Operating System Environment Variables]: http://docs.oracle.com/database/122/ADMQS
124+
122125
* "on delete cascade" 和 "on delete set null" 的差别[Common SQL DDL Clauses -> constraint -> on delete]: http://docs.oracle.com/database/122/SQLRF
126+
* TRUNC (date)[Functions -> TRUNC (date)]: http://docs.oracle.com/database/122/SQLRF
127+
* SYS_CONTEXT[Functions -> SYS_CONTEXT]: http://docs.oracle.com/database/122/SQLRF
128+
* ALTER SEQUENCE[SQL Statements: ALTER MATERIALIZED VIEW to ALTER SYSTEM -> ALTER SEQUENCE]: http://docs.oracle.com/database/122/SQLRF
129+
123130
* Database Error Messages: http://docs.oracle.com/database/122/ERRMG
131+
124132
* 开启和关闭数据库[Starting Up and Shutting Down]: http://docs.oracle.com/database/122/ADMIN
133+
* ADR[Managing Diagnostic Data -> Automatic Diagnostic Repository (ADR)]: http://docs.oracle.com/database/122/ADMIN
134+
* 归档日志[Managing the Redo Log]: http://docs.oracle.com/database/122/ADMIN
135+
* 为系统用户指定密码[Creating and Configuring an Oracle Database -> Protecting Your Database: Specifying Passwords for Users SYS and SYSTEM]: http://docs.oracle.com/database/122/ADMIN
136+
* Managing Oracle Enterprise Manager Database Control: http://docs.oracle.com/database/122/ADMIN
137+
125138
* LOBs类型说明[Using SQL Data Types in Database Applications -> Representing Large Amounts of Data]: http://docs.oracle.com/database/122/ADFNS
139+
126140
* 端口配置[Managing Oracle Database Port Numbers]: http://docs.oracle.com/database/122/LADBI
127-
* 配置系统环境变量[Getting Started with Database Administration -> Configuring the Operating System Environment Variables]: http://docs.oracle.com/database/122/ADMQS
141+
128142
* 环境变量[Administering Oracle Database -> Oracle Database Environment Variables]: docs.oracle.com/database/122/UNXAR
129-
* ADR[Managing Diagnostic Data -> Automatic Diagnostic Repository (ADR)]: http://docs.oracle.com/database/122/ADMIN
130-
* 归档日志[Managing the Redo Log]: http://docs.oracle.com/database/122/ADMIN
143+
131144
* 设置国际化支持环境变量[Setting Up a Globalization Support Environment]: http://docs.oracle.com/database/122/NLSPG/
145+
132146
* 逻辑存储结构[Logical Storage Structures]: http://docs.oracle.com/database/122/CNCPT/
147+
133148
* SQL*Loader[SQL*Loader Concepts]: http://docs.oracle.com/database/122/SUTIL
134149
* ADRCI: ADR Command Interpreter: http://docs.oracle.com/database/122/SUTIL
150+
* Using LogMiner to Analyze Redo Log Files: https://docs.oracle.com/database/122/SUTIL
151+
135152
* 数据库网络服务全部内容: http://docs.oracle.com/database/122/NETRF
136153
* JDBC数据源配置[Data Sources and URLs]: http://docs.oracle.com/database/122/JJDBC
154+
137155
* 预置账户[Securing the Database Installation and Configuration -> Predefined User Accounts Provided by Oracle Database]: http://docs.oracle.com/database/122/TDPSG
138-
* 为系统用户指定密码[Creating and Configuring an Oracle Database -> Protecting Your Database: Specifying Passwords for Users SYS and SYSTEM]: http://docs.oracle.com/database/122/ADMIN
139-
* Managing Oracle Enterprise Manager Database Control: http://docs.oracle.com/database/122/ADMIN
156+
140157
* [Gathering Database Statistics -> Generating an AWR Report Using the Command-Line Interface]: http://docs.oracle.com/database/122/TGDBA
141-
* TRUNC (date)[Functions -> TRUNC (date)]: http://docs.oracle.com/database/122/SQLRF
142-
* SYS_CONTEXT[Functions -> SYS_CONTEXT]: http://docs.oracle.com/database/122/SQLRF
143-
* ALTER SEQUENCE[SQL Statements: ALTER MATERIALIZED VIEW to ALTER SYSTEM -> ALTER SEQUENCE]: http://docs.oracle.com/database/122/SQLRF
158+
144159
* / (slash)[SQL*Plus Command Reference -> / (slash)]: http://docs.oracle.com/database/122/SQPUG
160+
145161
* CRSCTL/SRVCTL: https://docs.oracle.com/database/122/CWADD
146162

147163
* Oracle SQL Handler:http://www.heartblue.cn/
@@ -203,8 +219,15 @@
203219
* 【ASM】SYSASM 角色: https://yq.aliyun.com/articles/28404
204220
* rac节点无法启动ORA-29702的问题及分析: http://blog.itpub.net/23718752/viewspace-1158618
205221
* ORACLE RAC 的启动和关闭顺序: http://blog.itpub.net/29634949/viewspace-1269073/
206-
207-
222+
* Oracle RAC中public ip, private ip, vip, scan ip的概念: 《Oracle RAC 11g实战指南》 2.2 3.1.3 3.2.4章节
223+
* 深入了解 Oracle Flex ASM 及其优点(了解性知识):<http://www.oracle.com/technetwork/cn/articles/database/flexasm-flexcluster-benefits-odb12c-2177371-zhs.html>
224+
* oracle数据库备份删除操作:<http://www.blogjava.net/wangxinsh55/archive/2010/11/05/337300.html>
225+
* Oracle关闭和开启归档日志: <http://oma1989.iteye.com/blog/1469744>
226+
* oracle数据库自动提交事务(autocommit)为OFF,但事务自动提交了: <http://blog.sina.com.cn/s/blog_68fe7e150100z7tn.html>
227+
* statspack安装使用 和 report 分析: <http://blog.csdn.net/tianlesoftware/article/details/4682329>
228+
* 【性能调优】Oracle AWR报告指标全解析: <http://www.askmaclean.com/archives/performance-tuning-oracle-awr.html>
229+
* Oracle Trace文件生成及查看: http://blog.csdn.net/weiwenhp/article/details/6932835
230+
* Oracle 10g Audit(审计) --- 记录登录用户在Oracle中的所有操作: <http://blog.csdn.net/ryb7899/article/details/5413720>
208231

209232
## oracle疑难问题排查集:
210233

@@ -586,6 +609,7 @@ Oracle提供了两种验证方式,一种是OS验证,另一种密码文件验
586609
* actian: http://www.actian.com/
587610
* Apache Derby: http://db.apache.org/derby/
588611
* BlinkDB: http://blinkdb.org/
612+
* H2 Database Engine: http://www.h2database.com/html/main.html
589613
590614
# 数据模型
591615

0 commit comments

Comments
 (0)