here's a formula to calculate average length from metalink Note:10640.1
Table size increases proportionally with the number of rows in the table assuming average row length remains constant. While the DBA Guide provides a formula for calculating table size, it may not be as accurate as the...
hi, wouldn't you want your test instance to mirror your PROD instance? one suggestion I have is to configure your HP SA7200 to direct traffic on a certain port that you choose for test to load balance between the test servers. for example, we are running Cisco Local Directors and have...
Here's what metalink says:
Fnd_File package need to be used only in a stored procedure/Package. If you are using anonymous block(declare..begin..end) use dbms_output.put_line package
I think it may have something to do with this part of the query.
and exists (select b.pernr from ads_transfer_assign b
where a.pernr = b.pernr...
and not exists (select c.pernr from ads_transfer_assign c
where a.pernr = c.pernr...
since they are hitting the same tables they are cancelling...
it depends. what type of backup do you want to do? do you have mirrored disks?
Having OPS implies that you are using some sort of disk array (unless you're on linux and can implement OPS on a single node). If your tape backup device is on one of the servers, that server will handle all the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.