随笔分类 - 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就会记录一条.
阅读全文
摘要: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
阅读全文
摘要:log file status解读:CURRENT->表明当前oracle正在往里面写redo log dataINACTIVE->表明当前的日志文件组已经可以被覆盖了、或者可以被archived.表明其已经发生检查点.FAST_START_MTTR_TARGET参数指定了oracle在规定的参数值...
阅读全文
摘要:查看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 ...
阅读全文
摘要: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地址、端口号
阅读全文
摘要: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_...
阅读全文