Oracle Database Administration

DBMS_OUTPUT oracle package enables you to send output messages from various other PL/SQL program units like stored procedures, packages, triggers etc. DBMS_OUTPUT is primarily used for displaying messages or debug information from a PL/SQL Program. The procedures contained in the DBMS_OUTPUT package include DISABLE, ENABLE, PUT, PUT_LINE, GET_LINE, GET_LINES and NEW_LINE.

Oracle DATE datatype is used to store point-in-time values related to date and time. Oracle date datatype is stored in fixed length field of 7 bytes allows the storing of the year in 4 digit format, month, day, hours, minutes and seconds. Oracle dates are stored in julian era starting from January 1, 4712 BC through December 31, 4172 AD. Dates are defaulted to AD unless the format mask BC is specifically used

Intel Corporation has begun shipping its highest- performing solid-state drive (SSD), the Intel® X-25E Extreme SATA Solid-State Drive, aimed at server, workstation and storage systems. Unlike mechanical drives, the SSDs contain no moving parts and instead feature 50nm single-level cell (SLC) NAND flash memory technology. Systems equipped with these drives will not suffer from the performance bottlenecks associated with conventional drives. By reducing the total infrastructure, cooling and energy costs, SSDs can lower total cost of ownership for enterprise applications by more than five times.

UTL_TCP allows communication with external TCP Services.

UTL_SMTP is designed for sending e-mail over Simple Mail Transfer Protocol (SMTP).

The UTL_RAW package provides SQL functions for manipulating RAW datatypes.

UTL_HTTP allows you to write PL/SQL programs that communicate with Web (HTTP) servers.

UTL_FILE package built into the oracle database allows PL/SQL programs to read and write to an operating system file.

DBMS_UTILITY Package offers the API to support various utility functions of the PL/SQL System.

DBMS_STATS Provides an API into the Optimizer statistics of the Oracle Optimizer