oracle
iteye_5506
这个作者很懒,什么都没留下…
展开
-
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 阅读 · 0 评论 -
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 阅读 · 0 评论 -
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 · 146 阅读 · 0 评论 -
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 · 169 阅读 · 0 评论 -
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 · 397 阅读 · 0 评论 -
什么是托管代码,非托管代码(.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 · 106 阅读 · 0 评论 -
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 · 425 阅读 · 0 评论 -
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 阅读 · 0 评论 -
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 · 134 阅读 · 0 评论 -
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 阅读 · 0 评论 -
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 阅读 · 0 评论 -
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 · 286 阅读 · 0 评论