c*****d
发帖数: 6045 | 1 举个例子,ora-00054是这样发生的
session A:
update scott.dept set loc='beijing';
然后不commit也不rollback
session B:
alter table scott.dept drop column dname;
ORA-00054: resource busy and acquire with NOWAIT specified
truncate table scott.dept;
ORA-00054: resource busy and acquire with NOWAIT specified
li
NOWAIT
from
hi
pac
t
d |
|
c*****d
发帖数: 6045 | 2 想追踪什么语句导致ora-00054,可以这么做
alter system set events='54 trace name errorstack forever, level 10'
这样当发生ora-00054的时候,会在udump目录产生一个trace文件
比如下面的的这个trace文件说明是truncate操作导致ora-00054
********************************************************
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = #############
System name: Linux
Node name: #############
Release: 2.4.20-8smp
Version: #1 SMP Thu Mar 13 17:45 |
|
u****n
发帖数: 7521 | 3 李嘉诚蝉联香港富豪榜首 百丽主席晋升十强
据港媒报道，《福布斯》公布香港富豪榜，随着香港经济复苏，全港首40位富豪总
资产值约1.27万亿港元，较前年上升20.7%，整体虽仍未回到08年金融海啸前1.39万亿
元高位，但部分富豪身家已回复海啸前水平。
长实(00001)主席李嘉诚继续蝉联榜首，女装皮鞋百丽国际(01880)主席邓耀首次打
入富豪榜十大。
郭氏兄弟资产增重上第2位
《福布斯》以去年12月17日的公司股价和兑换率计算各富豪资产，富豪榜未算大执
位，近期长和系股价上扬，李嘉诚以身家1,872亿元，继续做大中华首富，新地(00016)
郭氏兄弟的资产值1,560亿元，重上第 2位，恒地(00012)主席李兆基紧接其后，资产值
1,521亿元屈居第3.
赌王财产仍缩水65% 排名13
但对比08年金融海啸前《福布斯》公布的排行榜，三大富豪仍未收复失地，李嘉诚
身家差距最大，现时总资产值仍较海啸前少25%，排名第4的新世界发展(00017)主席郑
裕彤追得最多，现时总资产值仍较海啸前少4.3%。
海啸前排行第5的“赌王”何鸿燊，身家仍缩水65%，排行 13位。其余大部分富豪
而越过... 阅读全帖 |
|
t****d
发帖数: 3204 | 4 你这个配置MSRP顶多47-48k，哪来的49-51？
你去问lease价钱必须先选好车，然后把价格谈下来，再算lease payment
如果是47k MSRP的Q5，10%off+1500 rebate大概就是40500的sales price，然后加上其
他费用，大概就是42000-43000的出门价
按55%残值，0.00054 money factor自己算，大概就是550一个月，出门只付第一个月的
lease payment |
|
发帖数: 1 | 5 刚在SwedeSpeed看到的,大概$9150 Off
12月份估计可以到$10000 off
2018 XC 90 R Design T6 in Bursting Blue
3years/12k
MSRP: 70,450
Selling Price after discounts and incentives: 61,300 (13.5% off)
MF: .00104 (.00054 after 10 MSDs)
Residual: 57%
Acq Fee: 695 (paid up front)
1830.69 due (0 down, inception, 1st month, dmv tags)
Sales Tax: 9% rolled in
Incentives: 3000
No A-Plan
No Costco
700/month
http://forums.swedespeed.com/showthread.php?292529-US-Prices-Paid-Lease-Figures/page14 |
|
d****n
发帖数: 1637 | 6 看了下楼主的《剑指Offer——名企面试官精讲典型编程题》
第７章，第一个实例简直就是面试官装B的一个实例。
说什么atoi 返回０的时候也可能是错误，会设置一个全局变量。
根本就是瞎扯。或者说最近的ｌｉｂｃ里面根本没有提。害的我找了一圈
###############man 3 atoi :############
DESCRIPTION
The atoi() function converts the initial portion of the string
pointed to by nptr to int. The behaviour is the same as
strtol(nptr, (char **)NULL, 10);
except that atoi() does not detect errors.
###############atoi.c###################
00001 /*
00002 * This file is shared between libc and the kern... 阅读全帖 |
|
P**H
发帖数: 2272 | 7 数据说明，5/31-6/1日行业的Market Value%变化
今天Drug Manufacturers - Major在大盘中的比例上升了0.3%
General Entertainment在大盘中的比例下降了0.11051%
自己看今天的资金流向
Industry Change(%)
********************************
Drug Manufacturers - Major 0.32213
Industrial Electrical Equipment 0.24029
Gold 0.18969
Management Services 0.16556
Property & Casualty Insurance 0.10720
Drugs Wholesale 0.04800
Semiconductor - Integrated Circuits 0.04767
Aluminum 0.04370
Application Software 0.03796
Technical Services 0... 阅读全帖 |
|
r*t
发帖数: 34 | 8 An urgent problem, thanks a lot if anybody can help!!!
I have several parallel processes like this:
my_program parameter1 &
my_program parameter2 &
...
my_program parametern &
In most of time, it runs as expected, but sometime it do give me an error li
ke this:
"Truncating table TABLE_A, ORA-00054: resource busy and acquire with NOWAIT
specified"
I am very positive that I have already removed all the truncation codes from
my program, but I still have this kind of error. Could anybody give me a h |
|
v*****r
发帖数: 1119 | 9 可以保证，in your case, before committing the delete, test_delete table will
be locked against any DDL change. If you try anything that might change
rowid, you will be greeted with error message:
ORA-00054: resource busy and acquire with NOWAIT specified |
|
w****n
发帖数: 266 | 10 这是一个log table， 几乎每分钟都在写记录， 很难找到固定的open window。 ETL
job是每天12点半删除历史记录， 现在连续几天报错，说系统忙
ORA-00054: resource busy and acquire with NOWAIT specified or timeout
expired
历史数据不多。 |
|
r*t
发帖数: 34 | 11 【 以下文字转载自 Database 讨论区 】
发信人: rgt (一脸无辜), 信区: Database
标 题: Oracle求助，thanks!!!
发信站: BBS 未名空间站 (Sun Oct 26 16:07:18 2008), 转信
An urgent problem, thanks a lot if anybody can help!!!
I have several parallel processes like this:
my_program parameter1 &
my_program parameter2 &
...
my_program parametern &
In most of time, it runs as expected, but sometime it do give me an error li
ke this:
"Truncating table TABLE_A, ORA-00054: resource busy and acquire with NOWAIT
specified"
I am very positive that I |
|
|
w******e
发帖数: 1187 | 13 http://www.ophthalmology.theclinics.com/article/S0896-1549(06)00054-X/abstract
Ranibizumab: Phase III Clinical Trial Results
Philip J. Rosenfeld, MD, PhD'Correspondence information about the author MD,
PhD Philip J. RosenfeldEmail the author MD, PhD Philip J. Rosenfeld, Ryan M
. Rich, MD, Geeta A. Lalwani, MD
ophthalmology clinics of north america
September 2006Volume 19, Issue 3, Pages 361–372
email: [email protected]/* */
非常感谢！ |
|
