All Forums UDA
s90570809 1 post Joined 01/06
21 Feb 2006
Why drop Table need 10 minutes?

Dears:case 1. In batch time (22:00 ~ 09:00) batch jobs drop table used 1 second but after 09:00 user begin use the teradata database drop table used 10 minutes. I used PMON monitor these job no lock and the CPU usage same as the batch time near 2. In batch time batch jobs will not lock dbc.accessrights but the same jobs after 09:00 if lock abc.accessrights then I move hight CPU Job to penalty box let the CPU usage down to 10% during two hours but these batch jobs still lock can't release.Somebody can give me some hints. Thanks!Best RegardsJohnson Yeh

You must sign in to leave a comment.