iteye_5506-CSDN博客

原创 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 105

原创 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 104

原创 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 102

原创 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 263

原创 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 263

原创 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 127

原创 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 118

原创 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 141

原创 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 385

原创 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 79

原创什么是托管代码，非托管代码（.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 103

原创 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 476 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 414

原创 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 116

iteye_5506的博客