This topic has been archived. It cannot be replied.
-
工作学习 / 学科技术讨论 / 求教：oracle里怎么知道一张表正在被其它的用户访问？谢先
-20061029(makesense);
2007-11-17
(#4063818@0)
-
up
-20061029(makesense);
2007-11-19
(#4068174@0)
-
maybe you can tell us what you really want to do/accomplish?
-xordos(donothing);
2007-11-19
(#4068203@0)
-
alter一张表，要求先查出有没有其它人在访问，如果没有就alter.谢谢指教
-20061029(makesense);
2007-11-19
(#4068273@0)
-
通常是在深更半夜, 月高风黑的时候, 自己动手, 或者schedule个DTS或SCRIPT来做.
-piglet(迪斯尼fan);
2007-11-19
(#4068372@0)
-
那有什么用，可能你查询刚结束，正以为安全呢，新的访问又开始了。修改数据结构时必须停止整个应用，所有用户都下线。相关的视图、存储过程都会失效必须重新编译。
-newkid(newkid);
2007-11-19
(#4068541@0)
-
GUESS, 应该可以直接alter table, oracle 的锁机制WILL ROLLBACK YOUR TRANSACTION IF OTHER APPLICATION IS BLOCKING YOURS
-shanxiren(山西人);
2007-11-19
(#4068573@0)
-
Update usually starts with a read, and holds a timestamp. If during this period the table structure is changed, the timestamp doesn't change and update can go through and insert data into incorrect columns. Same with insert.
-poohbear(毛毛熊);
2007-11-20
(#4069763@0)
-
Try to put a table level lock(select .. for update), or find some thing from v$lock.
-tiantianma(天天骑马);
2007-11-19
(#4068556@0)
-
Find any session using your table, by using Oracle's view: Select sid,username from v$access where owner='your table owner' and
object='your table name'
-jin_ting(jy);
2007-11-21
(#4070726@0)