随笔分类 -  9I Fudmentl I

摘要:AuditingAuditing is the monitoring of selected user database actions,and is used to:Investigate suspicious database activityGather information about specific database activitiesAuditing can be performed by session or accessby session:用户登陆上来后,发出同类型的SQL语句,oracle只会记录一条.bu access:发出一条sql语句,Oracle就会记录一条. 阅读全文
posted @ 2013-07-26 10:54 ArcerZhang 阅读(215) 评论(0) 推荐(0) 编辑
摘要:SummaryConfiguration Automaitc Undo Management将undo_management设置为auto设置当前的undo tablespaceCreate an UNDO tablespaceProperly size an UND tablespaceObtain undo segment informationlittle demo查看一个事务占用了多少undo block?SQL> create table t2 as select * from all_objects where 1=0;Table created.SQL> select 阅读全文
posted @ 2013-07-16 13:06 ArcerZhang 阅读(279) 评论(0) 推荐(0) 编辑
摘要:log file status解读:CURRENT->表明当前oracle正在往里面写redo log dataINACTIVE->表明当前的日志文件组已经可以被覆盖了、或者可以被archived.表明其已经发生检查点.FAST_START_MTTR_TARGET参数指定了oracle在规定的参数值... 阅读全文
posted @ 2013-07-15 10:51 ArcerZhang 阅读(319) 评论(0) 推荐(0) 编辑
摘要:查看SGA参数信息SQL> show sga;Total System Global Area 3256942592 bytesFixed Size 2217752 bytesVariable Size 1795164392 bytesDatabase Buffers 1442840576 bytesRedo Buffers 16719872 bytesSQL> show parameter SGA_MAXNAME TYPE ... 阅读全文
posted @ 2013-04-29 18:04 ArcerZhang 阅读(139) 评论(0) 推荐(0) 编辑
摘要:1、如何查找3要素信息(IP地址、端口号、服务名)IP地址:ifconfig端口号:view /$ORACLE_HOME/network/admin/listener.ora服务名:以sys用户登陆oracle server后,执行show parameter service查看2、有关Naming Method Configuration相关文件分类 oracle server site file->listener.ora client site file ->tnsnames.ora,slqnet.ora tnsnames.ora文件用于存放数据库连接三元素(IP地址、端口号 阅读全文
posted @ 2013-03-13 09:46 ArcerZhang 阅读(143) 评论(0) 推荐(0) 编辑
摘要:Oracle supports different classes of character encoding schemes:Single-byte character sets7-bit8-bitVarying-width multibyte character setsFixed-width multibyte character setsUnicode(AL32UTF8,AL16UTF16,UTF8)查看数据库中的字符集信息select * from nls_database_parameters;NLS_CHARACTERSET AL32UTF8(主字符集) NLS_... 阅读全文
posted @ 2013-03-11 18:49 ArcerZhang 编辑

点击右上角即可分享
微信分享提示