ORACLE 11G DBA course given in English.
This course is aim to train the great DBA with good English speaking.
In recent years, more demands of Oracle DBA, but most of Senior DBAs are required to speak good English.
English has become the great barrier for more peoples in their career development, you must have the deep feeling about it if you work in the foreign company.
In IT English course, Learning IT knowledge in English just like killing two birds with one stone, not only it can help you to master of Professional IT English terminologies as soon as possible, but it can help you to take the reins of IT technology, enjoy yourself to listen to the Professional English IT lectures.
Therefore, Oracle 11G DBA courses come to you at the right time, this is for those who has the basic English background and willing to be the Professional Oracle DBA.
Requirements: good English listening, no need of Database or relevant computer experience.
First 10 registers could get the discount, please contact me as soon as you can.
Of course, you can cancel your membership at any time. There is no risk. Try my VIP Program for you and speak English confidently, grow more successful and become a true DBA.
Learn path:
1.The SQL introuduction
2.PLSQL introuduction
3.Database Architecture
4.Backup and Recovery
5.Performance Tuning
6.High availability
And also provide the On demand course per the customer requirements.
For more information, please contact me by MSN
baiwentao@hotmail.com
相关文档：
本视图包括Shared pool中SQL语句的完整文本，一条SQL语句可能分成多个块被保存于多个记录内。
V$SQLTEXT中的常用列
HASH_VALUE：SQL语句的Hash值
ADDRESS：sql语句在SGA中的地址
SQL_TEXT：SQL文本。
PIECE：SQL语句块的序号
V$SQLTEXT中的连接列
Column View ......
Oracle OFS FS10755 报错问题的解决方法
在某些情况下，重装或重配 OFS 时，比如验证群集，或移动群集组时，会报 FS10755 错， 错误信息如下：
Oracle OFS error - FS10755: Error Creating the OracleFsWorker COM object After Oracle OFS installed, the verification could not pa ......
--获取两时间的相差豪秒数
select ceil((To_date('2008-05-02 00:00:00' , 'yyyy-mm-dd hh24-mi-ss') - To_date('2008-04-30 23:59:59' , 'yyyy-mm-dd hh24-mi-ss')) * 24 * 60 * 60 * 1000) 相差豪秒数 from DUAL;
/*
相差豪秒数
----------
86401000
1 row selected
*/
--获取两时间的相差秒数
select ce ......
数据字典dict总是属于Oracle用户sys的。
1、用户：
select username from dba_users;
改口令
alter user spgroup identified by spgtest;
2、表空间：
select * from dba_data_files;
select * from dba_tablespaces;//表空间
select tablespace_name,sum(bytes), sum(b ......
今天在网上乱逛，看到一篇不错的文章，关于ORACLE密码文件的，理论学习+个人实践，呵呵，复制过来，方便以后学习。
===============================================================================
理论部分
Oracle关系数据库系统以其卓越的性能获得了广泛的应用，而保证数据库安全性是数据库管理工作的重要内容。本 ......
