On Jan 29, 6:19 am, falcons...@[EMAIL PROTECTED]
wrote:
> I have a long transaction (taking hours) with all tables within the
> transaction
> are tem****ary tables with no log and locked in exclusive mode, thus
> there will be no LOG
> usage and less LOCK usage. Is this scenario will impact the database
> server performace?
>
> Thanks for any reply and consultation.
The best way to get real performance answers is TEST IT!
But think about it. There are always some resources used. You never
defined the performance you are concerned will be impacted. These
transactions takes CPU cycles if nothing else, but I bet they also
takes shared memory, disc space, index space, table space, and others
resources.
You also did not mention which DBMS or platform (OS and hardware). The
question is too generic.
So what is really your problem??
Ed
|
