VMCD.ORG

Focus on database mail:ylouis83#gmail.com

Resource Manager (2)

Posted by admin on 9th September 2012

对于需要使用资源控制的应用,oracle提出了resource manager这一解决方案,针对不同的schema,Oracle提供不同的资源等级,但是这种资源的分配其实本身就存在一定的资源消耗,当大量的session涌入数据库的时候,oracle需要消耗一定数量的cpu去重新分配资源的调级,此时就[......]

Read more

Tags:
Posted in Oracle Experience | No Comments »

data_object_id

Posted by admin on 24th October 2011

xxx_objects.data_object_id differs from object_id after

* truncate table (or alter table truncate partition), unless table/partition is empty
*[......]

Read more

Tags:
Posted in Oracle Experience | 1 Comment »

datafile Checkpoint cnt

Posted by admin on 24th October 2011

通过dump datafile header 发现每个Checkpoint cnt不同

大致原因如下:

1.tablespace 建立的时间不同 现在我们新建一个tablespace ->liu datafile->liu01.dbf

DATA FILE #10:
(name #[......]

Read more

Tags:
Posted in Oracle Experience | 2 Comments »