I have a scriipt which creates tables and indcies at startup, basicallu all DDL's. There are many archive redo generated. I am using Oracle 10g. What could be the reason ?
Thanks very much.
(Also how do I know what is going on, that is creating so much redo without any DML ?)
Working with Network Access Control Lists in Oracle 11g (part 1)
Part 2: http://www.e-e.com/A_9074.html
So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
How to Create User-Defined Aggregates in Oracle
Before we begin creating these things, what are user-defined aggregates? They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…