- 博客(14)
- 收藏
- 关注
原创 DATA PUMP
数据泵 学习心得 (from:http://blog.sina.com.cn/hellohuangqian) ORACLE 10g 开始提供了2个实用的工具以方便导入导出工作.分别是expdp/impdp 先说说我的理解吧,原来的exp/imp工具是属于client/server模式,单线程操作,容易引起i/o瓶颈和操作中断新的datapump 解决了这些问题,datapu...
2010-09-06 12:56:40
113
原创 How to know whether a query is using index or not?
You can use the index monitoring feature to check if indexes are used by an application or not. If u set the MONITORING USAGE property for an index, you can query the v$object_usage to see if the inde...
2010-09-06 05:54:51
109
原创 Oracle 10g Administration
Oracle 10g Administration10g Enhancements· Automatic Storage Management· Data Pump· Grid-enabling Features· Scheduler· Tablespace Administration· Globalization· Installation...
2010-08-22 02:21:48
108
原创 DBA Views
Oracle Dictionary - DBA ViewsSQL> SELECT * FROM DICT WHERE TABLE_NAME LIKE 'DBA_%' ORDER BY TABLE_NAME;TABLE_NAME COMMENTS------------------------------ ---------------------------------------...
2010-08-22 02:02:28
269
原创 answer for question2
1. What are the components of physical database structure of Oracle database?Oracle database is comprised of three types of files. One or more datafiles, two are more redo log files, and one or more...
2010-08-05 02:29:55
266
原创 DBA Interview questions 2
What are the components of physical database structure of Oracle database?What are the components of logical database structure of Oracle database?What is a tablespace?What is SYSTEM tablespace ...
2010-08-05 02:03:09
131
原创 Performance tuning interview questions
Why and when should one tune?One of the biggest responsibilities of a DBA is to ensure that the Oracle database is tuned properly. The Oracle RDBMS is highly tunable and allows the database to...
2010-08-05 01:21:26
125
原创 Proactively Monitoring your Database
Proactively Monitoring your DatabaseA Creating a Tablespace and Table with a Specified TresholdB. Triggering a Tablespace Space Usage AlertC. Setting up Notifications1. Click the Serve...
2010-08-05 01:14:46
145
原创 DBA Interview questions
interview Questions with Answers for Oracle, DBA, and developer candidates[size=large][/size][Hide TOC]1 Introduction2 Questions/Answers2.1 PL/SQL Questions2.2 DBA2.3 SQL/ SQLPlus2.4 T...
2010-08-05 00:57:42
393
原创 LInux Command
[size=large][/size]linux command File Commandsls – directory listingls -al – formatted listing with hidden filescd dir - change directory to dircd – change to homepwd – show curren...
2010-07-12 03:21:17
83
原创 什么是托管代码,非托管代码(.net framework)
Managed CodeManaged Code is code that is written to target the services of the managed runtime execution environment (CLR). The Managed Code is always executed by managed Code runtime environment ra...
2010-06-21 02:51:42
104
原创 function与procedure区别
1. Function is mainly used in the case where it must return a value. Where as a procedure may or may not return a value or may return more than one value using the OUT parameter. 2. Function c...
2010-06-21 02:45:52
480
1
原创 cluster索引和非cluster区别
There are clustered and nonclustered indexes. A clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table can have only one clustered...
2010-06-21 02:28:18
419
原创 create database
using dbca to create a DBselect create database optionspecify type of databasespecify global database name and sidselect featuresselect database operational modespecify options for memor...
2010-06-21 02:05:43
119
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人