flyonok

统计

留言簿(8)

ACE

book

boost

bsd

c study

c++

code download

codeblock

computer clound

Eclipse

embed system

erlang

ET++

gtk

ic card

java

KDE

libevent

linux

linux--MM

mysql

network education

one card

oracle

pcap relation

php

powerbuilder

python

QT

software config

software test

SQL server

UML

wireless

wxwidgets

陈宾

阅读排行榜

评论排行榜

oracle tips

ar

one:svrmgrl move to sqlplus at oracle 10g
two:more instance can use same listener

three:a dictionary managed tablesoace is one whose free space management is done in data dictionary that resides in system tablespace.
where as a locally managed tablespace means the free space for the tablespace is managed with in the tablespace using bitmaps.
locally managed tablespaces gives better performance in comparison to dmt.
but if ur system tablespace is locally managed then other tablespaces r also locally managed.
and in near future oracle may stop supporting dictionary managed tablespaces.

four:emctl start/stop dbconsole;isqlplus start/stop;


 

five:find port of em or isqlplus:$ORACLE_HOME/install/portlist.ini

six:modify sys user password when it's password was lost
alter   user   sys   identified   by   sys;

seven:支持中文字符的数据库,NLS_LANG为  SIMPLIFIED CHINESE_CHINA.ZHS16GBK

eight:--archive
show parameter db_recovery;
select * from V$FLASH_RECOVERY_AREA_USAGE;
archive log list;
show parameter log_archive_start
alter database archivelog;
alter database noarchivelog;
startup nomount;
alter database mount;
alter database open;

posted on 2008-01-18 16:29 flyonok 阅读(286) 评论(0)  编辑 收藏 引用 所属分类: oralce


只有注册用户登录后才能发表评论。
网站导航: 博客园   IT新闻   BlogJava   知识库   博问   管理