Re: guide on impact of system

Enterprise Edition or Standard Edition of the Oracle database server software?

Some types of operations can be performed online with Enterprise edition that are "offline" operations in Standard edition, such as moving tables, rebuilding indexes.

So I'd first segregate things from "requires exclusive access" (meaning, concurrency) from "will put a load on the database server resources" (meaning, will increase the response time for other users).

Next time you perform the activities in question, log usage via v$sesstat, sqlplus autotrace, timing and possibly a session trace/tkprof. Operating system statistics may also be helpful, in terms of cpu usage, disk io and service times. As you did not indicate the server operating system I'll leave this out.

As the amount of resources required to perform task T1 is roughly proportional to the number and size of the segments affected and number of rows of interest - each task will "impact performance" differently. So this really depends upon what you are in fact doing.

There are features such as resource management (in 9.2 Enterprise Edition) that can be used to "nice" a session.

Truncates are very fast, unless someone has a row exclusive lock on the table, in which case a truncate is very slow as is would either be blocked or fail (ora-54).

How about if you spend some time on the test database/test server for this database and test these tasks out in your environment? If you don't have a test environment, build one.

-bdbafh Received on Thu Apr 27 2006 - 14:18:49 CDT