What roles, privileges, transactions should we allow the Oracle DBA to use and access. Presuming DEV-PROD. Were moving the DBA role out of the BASIS group. We know all DB.. transactions, plus ST22, and looks like SE11 and SE16 are suggested. Thank you for your help. Software/Hardware used:...
How I can get oracle database experience without joining any firm or institution. Would anybody comment please?
How do i run analyse statistics on oracle 10g and schedule it for sunday at 04:00 am
Oracle DBA, Oracle Statistical Functions, Oracle 10g Statistical Functions
Good day, I try to optimize sqlldr, but don't know how to set the parameters. I am trying to load 21,000,000 records per day, but currently don't manage to load all data in time. The loading is always 1 day behind. I am using conventional loading (I cannot disable indexes before and after...
which tool is most common for database(oracle) administration , instead of OEM?
Hiii, I have created Oracle 10g Primary database where control file locations are as follows: *control_files='P:\oracle\product\10.1.0\oradata\tceng\control01.ctl','C:\oradata\tceng\control02.ct l','E:\oradata\tceng\control03.ctl' Then I have created standby database in standby server where the...
As an Oracle DBA, I have heard and read a lot about RAID 5 and what it can do to database write performance. Now I understand RAID 5 has been improved to the point that all of the things that caused the overhead are now being handled in disk cache, and write times are now close to that of RAID 0+1....


