- 博客(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 135
原创 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 134
原创 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 132
原创 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 294
原创 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 287
原创 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 153
原创 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 149
原创 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 170
原创 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 399
原创 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 106
原创 什么是托管代码,非托管代码(.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 107
原创 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 519 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 426
原创 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 141
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人