Oracle International Corporation

Ajay Sethi

Kirk A Bradley

Sameer Shisodia

Ritesh Motlani

Sunil Kumar

Mahantesh Hosmath

Ramesh Bhattiprolu

John Pullokkaran

Gopalaswamy Ramesh

Ravi Murthy

Ashish Thusoo

Bhaskar Ghosh

Chandrasekharan Iyer

Adiel Yoaz

Shashaanka Agrawal

Ritesh Molani

The present invention generally relates to computer software, and more specifically, to a computerized utility for analysis of optimized program files. A method and apparatus for optimized program analysis is disclosed.

Optimized program analysis

A method and apparatus for executing groups of database statements is provided. An indication is included in database statements to indicate whether instructions need to be executed in a particular sequence with respect to one another. In an embodiment, statements that need to be executed sequentially with respect to one another are included in the same bundle. In an embodiment bundles do not need to be executed in any particular order with respect to one another. A mechanism has been presented to enable statements to be executed concurrently by the server. In an embodiment, groups of database statements are sent from a client-side to a server within batches including one set of transmission information for the entire batch. In an embodiment, within a batch there may be one or more bundles. In an embodiment, the bundles are always executed sequentially; however, different bundles within a batch can be executed concurrently.

Specifying parallel or sequential execution of database operations by bundling database statements

Concurrent execution of groups of database statements

Techniques for representing core files generated by a computer operating system upon crash of a computer program in a generic format are disclosed. A generic representation of the core file can be generated and analyzed to help in determining errors in code that occurred which the operating system is unable to handle. The generic representation of core files can be represented in a platform-independent format, for example, generic representation of core files may be represented in an extensible data format.

Representation of core files in a generic format

A method and mechanism for pipelined table functions is disclosed. With pipelining, data from a first table function does not have to be materialized into a complete collection before it is consumed by a succeeding table function. Instead, a producer of data creates a stream of data that is immediately utilized by a consumer of that data. Also disclosed is a method and mechanism for parallel processing of table functions, in which the set of work operated upon by a table function is sub-divided into smaller portions that are assigned to a plurality of table function slaves. Also disclosed is an integration between pipelining and parallelized execution for table functions.

Method and system for pipelined database table functions

A method and system for optimizing the passing of a parameter to a routine is provided. It is determined if any parameters are aliased in a call to a called routine. In the absence of aliases, calling routines passing parameters to called routines using &ldquo;call by reference&rdquo;. Recovery mechanisms are provided, when appropriate, when unhandled exception occur during execution of the called routines. According to the method, a recovery mechanism includes encapsulating the called routine and call statement block with a &ldquo;catch-all&rdquo; exception handler. The response to an otherwise unhandled exception includes restoring the actual parameter using a stored copy of the actual parameter. The restoration is performed by making a handle point to the copy of the actual parameter that was made before execution of the called routine.

Optimizing parameter passing

Growing community of inventors

Bengaluru, India

Ajay Sethi