oracle
关注
分享
扫一扫
iteye_5506
这个作者很懒，什么都没留下…
展开
专栏收录文章
- 默认排序
- 最新发布
- 最早发布
- 最多阅读
- 最少阅读
-
DBA Views
Oracle Dictionary - DBA Views SQL> SELECT * FROM DICT WHERE TABLE_NAME LIKE 'DBA_%' ORDER BY TABLE_NAME; TABLE_NAME COMMENTS ------------------------------ ---------------------------------------...原创 2010-08-22 02:02:28 · 333 阅读 · 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 · 181 阅读 · 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 · 171 阅读 · 0 评论 -
Proactively Monitoring your Database
Proactively Monitoring your Database A Creating a Tablespace and Table with a Specified Treshold B. Triggering a Tablespace Space Usage Alert C. Setting up Notifications 1. Click the Serve...原创 2010-08-05 01:14:46 · 203 阅读 · 0 评论 -
DBA Interview questions
interview Questions with Answers for Oracle, DBA, and developer candidates [size=large][/size] [Hide TOC] 1 Introduction 2 Questions/Answers 2.1 PL/SQL Questions 2.2 DBA 2.3 SQL/ SQLPlus 2.4 T...原创 2010-08-05 00:57:42 · 443 阅读 · 0 评论 -
什么是托管代码，非托管代码（.net framework)
Managed Code Managed 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 · 129 阅读 · 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 · 551 阅读 · 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 · 486 阅读 · 0 评论 -
create database
using dbca to create a DB select create database option specify type of database specify global database name and sid select features select database operational mode specify options for memor...原创 2010-06-21 02:05:43 · 167 阅读 · 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 · 170 阅读 · 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 · 155 阅读 · 0 评论 -
Oracle 10g Administration
Oracle 10g Administration 10g Enhancements · Automatic Storage Management · Data Pump · Grid-enabling Features · Scheduler · Tablespace Administration · Globalization · Installation...原创 2010-08-22 02:21:48 · 160 阅读 · 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 · 318 阅读 · 0 评论