We create a Reporting database nightly
from the hot backups of a Production Financials 11.0.3 database.
The Reporting database is on its own server (UNIX). There is
a full Oracle and Applications environment on the Reporting server. What
I do as part of the hot backup script, is copy over the
I just did one of those this weekend
(from 8.1.6 to 9.2.0.1). I created an empty 9i database with all
the tablespaces before starting the import. The "full=y" errored
out , but it did create the users before it died. I had to go back
and do schema imports for each user.
Vicki Pierce
Database Ad
We had a weird situation yesterday on
a database that had been upgraded from 8.1.6 to 9.2.0.1 over the weekend.
Suddenly at 10:30 am, after being in production for a day and a half,
93 previously VALID packages, package bodies, triggers and procedures went
INVALID. We have not been able to figur
Thanks for the input, John. I
am primarily concerned about I/O overhead, but I guess that depends on
the level of auditing selected, number of concurrent users, which apps
they are logged into, time of the month, etc.etc...
Vicki Pierce
Database Administration
x2401
John Kanagaraj <[EMAIL P
Does anyone have any statistics about
overhead associated with using the Signon Audit in an 11.0.3/ 8.1.7.4/8.0.6.3
environment. We are using full installs of AP, GL, FA and CE. Size
of the production database is 100G. Can't tell you exactly what we'd
be auditing; we are under siege by Interna
In our shop, the APPS DBA runs traces
as APPS. No one outside of the DBA group has the APPS password. We
use Discoverer and Noetix Views for those users who have to look into the
database outside of the application. Each user logs in as himself;
the DBAs have created roles by business unit and
Try PL/SQL Developer from Allround Automations.
The cost is modest and the tool was developed just for Oracle.
Vicki Pierce
Database Administration
x2401
"Rama, Shreekantha
(K.)" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/13/2003 01:19 PM
Please respond to
[EMAIL PROTECTED]
