-
编辑 删除
Performance view V$SEGSTAT and V$SEGMENT_STATISTICS.
This view has a lot more columns and is more descriptive with respectto the object identification. In addition to columns like the mainview, it also references the names of the tablespace, the objec...
-
编辑 删除
Redhat 5 Oracle10g安装问题
在Redhat5下安装Oracle 10g时出错Exception java.lang.UnsatisfiedLinkError: /tmp/OraInstall2008-08-14_10-45-36AM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or ...
-
编辑 删除
Explain Plan
explain plan set statement_id = 'x' into plan_table for <<YOUR CODE HERE. DON'T FORGET THE ";">> select lpad(' ',2*level) || operation operations,options,object_name from plan_table where statement...
-
编辑 删除
TBS Space
select a.name, b.total_kb, b.total_kb - a.free_kb used_kb, a.free_kb, a.free_kb/b.total_kb*100 per_free from (select dfs.tablespace_name name, ...
-
编辑 删除
Literal SQL is not shared in PL/SQL block
Article-ID: Note 285447.1Circulation: PUBLISHED (EXTERNAL)Folder: ST.Server.Performance.DatabaseTopic: Tuning Shared PoolTitle: Literal SQL is not ...
-
编辑 删除
Partition Change-Tracking Without MV Logs
Fortunately, in Oracle Database 10g Release 2, PCT works without the need for MV logs. Let's see this in action. First, confirm that there is no MV log on the table ACCOUNTS.SQL> select * 2 ...
-
编辑 删除
PARALLEL_THREADS_PER_CPU
Property DescriptionParameter type IntegerDefault value Operating system-dependent, usually 2Modifiable ALTER SYSTEMRange of values Any nonzero numberNote:This parameter applie...
-
编辑 删除
9.2.0.6在Veritas 4.1上的bug
You may find errors in alert.log file when you using Veritas 4.1 on SunOS 5.9 with Oracle 9.2.0.6 if you shutdown database with Cluster at Jun 14 01:29:19 2008Errors in file /ora92nwk/ora9i/app/oracl...
-
编辑 删除
Oracle Streams - UpStream with RMAN duplicate DB (Continued)
由于有字节限制,上一个日志不完整,接上一个日志: we can see APPLY and CAPTURE process are started on both database because we configured the bi_directional=true.15. Test DML and DDL in ...
-
编辑 删除
show the CPU usage per session
col username format a15select distinct a.sid, d.username, a.value "total CPU",b.value "Parse CPU",c.value "ecursive CPU",a.value - b.value - c.value "other CPU" from v$sesstat a, v$sesstat b, v$sessta...
