|
# 1613
kiki
|
|
|
 To: eygle
盖兄，是不是library cache pin这个latch在发生严重争用的时，不仅引发latch free事件，而且引发library cache pin事件啊？
还有，有无办法跟踪到执行一条sql语句顺序地持有和释放哪些latch呢，谢谢。
From: kiki
2005.09.20 04:48
|
|
|
|
|
 To: kiki
[COLOR=blue]
latch free是个等待事件，只要进程因latch而处于等待，就会记录latch free，所以latch free只是真实状态的一种反映而已。
latch的顺序可以知道，但是很难跟踪。
[/COLOR]
From: eygle
2005.09.20 07:22
|
|
|
|
|
# 1610
John
|
|
|
 To: eygle
你就会欺负lala弟弟，游泳池怎么会有鲨鱼呢？
正确的解释是：当你吃了鲨鱼肉以后，你就有了鲨鱼的特性，容易长出鱼尾巴。所以呢，吃完了鲨鱼肉是不可以游泳的。lala小弟，明白了吗？
From: John
2005.09.20 04:15
|
|
|
|
|
# 1609
John
|
|
|
 To: aloe
恕俺直言，鲨鱼认为你也很好吃！
From: John
2005.09.20 04:06
|
|
|
|
|
# 1607
adam830
|
|
|
 To:
[COLOR=blue]开会...[/COLOR]
完整报错：
Error in writing to directory
C:\Docume~1\ADMINI~1\LOCALS~1\Temp\OraInstall2005-9-20_06-25-03PM
Please ensure that this directory is writable and has at least 32MB of disk space. Installation cannot continue.
我是在WINDOWS 2003 下安装的，仅仅点击[开始安装]等会便出错了。在一台2000的笔记本上安装无误。空间绝对够，并且是管理员身份。
PS： 深浅 ？？
From: adam830
2005.09.20 03:37
|
|
|
|
|
# 1606
verafxh
|
|
|
 To:
鲨鱼丸很好吃的～
食欲
From: verafxh
2005.09.20 02:44
|
|
|
|
|
# 1605
adam830
|
|
|
 To: eygle
去哪里了？老师
From: adam830
2005.09.20 01:05
|
|
|
|
|
To: adam830
[COLOR=blue]开会...[/COLOR]
From: eygle
2005.09.20 02:00
|
|
|
|
|
# 1603
andy
|
|
|
To: eygle
请问新创建的回滚段怎么指定在当前大事务操作，我现在创建成功了回滚段，物化视图中我也指定了，可是还报
ORA-01562:failed to extend rollback segment number 5
ORA-01628:max#extents(200) reached for rollback segment RDBS09
ORA-06512:at "sys.dbms_snapshot_utl",line 168
ORA-06512:at "sys.dbms_snapshot",line 794
ORA-06512:at "sys.dbms_snapshot",line 851
ORA-06512:at "sys.dbms_irefresh",line 683
ORA-06512:at "sys.dbms_refresh",line 195
ORA-06512:at line 2
CREATE ROLLBACK SEGMENT "VIEW_PRODUCT"
TABLESPACE "VIEWDATAUNDO"
STORAGE ( INITIAL 100M NEXT 100M OPTIMAL 200M MINEXTENTS 50
MAXEXTENTS 200)
ALTER ROLLBACK SEGMENT "VIEW_PRODUCT" ONLINE
SQL> SET TRANSACTION USE ROLLBACK SEGMENT "VIEW_PRODUCT";
事务处理集。
难道回滚段还不够大吗？
From: andy
2005.09.20 00:47
|
|
|
|
|
To: andy
[COLOR=blue]
select segment_name,max_extents,tablespace_name from dba_segments where segment_name like '%RDBS%';
[/COLOR]
From: eygle
2005.09.20 02:34
|
|
|
|
|
# 1601
lily
|
|
|
 To: EYGLE
哇神奇老虎竟然变成了人：P
From: lily
2005.09.20 00:12
|
|
|
|
|
 To: lily
[COLOR=blue]厉害吧[/COLOR]
From: eygle
2005.09.20 02:01
|
|
|
|
|
eygle.com
我要留言
回复
编辑
