Querying multiple rows from dual
By Granville Bonyata Sometimes it’s useful to have a query that always returns a certain number of rows, such as a report that returns one row for every day of the month. Using DUAL and CONNECT BY allows you to return as many rows as needed. For instance, this query returns one row for every … Read more
Mr Trace
Mr Trace speaks for itself. Cary Millsap and the and Method R created a great add-in to Oracle SQL Developer. It’s called Method R Trace .When you run your PL/SQL code, it automatically turns tracing on and off at the right times, fetches the trace file for you, and presents it in a list right … Read more
Creating 11.2.0.2 using DBCA
DBCA needs to include sizes in G Bytes for Fast Recovery Area.Mb are too small these days.. If you pick Automatic Memory Management DBCA will stop you from using more memory than it is size of tmpfs /dev/shm.That is a good feature but although I specified correct amount of memory database creation failed.After looking … Read more
Oracle 11.2.0.2 Patch Set – New feature and change
Oracle Grid Infrastructure 11.2.0.2 introduces new feature called Redundant Interconnect allowing for Oracle Supplied redundancy for the cluster interconnect.Redundant Interconnect Usage enables load-balancing and high availability across multiple (up to 4) private networks (also known as interconnects).Redundant Interconnect Usage creates a redundant interconnect when you identify more than one interface as private. With this new … Read more
