|
Database Administrators spend countless hours troubleshooting SQL statements that have taken upon a new life after a simple system or environment change. Oracle 11G SQL Performance Analyzer provides a solution to this never ending regressive statement issues. This new feature of Oracle 11G allows the database administrator to get a granular view of the impact to sql execution plans and statistics due to environment changes and the best part is that it completely automates the impact analysis process of extremely large SQL workloads
|
|
Oracle today introduced Oracle(r) Database 11g, the latest release of the world's most popular database. With more than 400 features, 15 million test hours, and 36,000 person-months of development, Oracle Database 11g is the most innovative and highest quality software product Oracle have ever announced.
|
|
The Oracle DBMS_LOB package provides subprograms to operate on BLOBs, CLOBs, NCLOBs, BFILEs, and temporary LOBs. You can use DBMS_LOB package to access and manipulation specific parts of a LOB or complete LOBs. DBMS_LOB can read and modify BLOBs, CLOBs, and NCLOBs; it provides read-only operations for BFILEs. The bulk of the LOB operations are provided by this package. When you are coding SQL for lobs (clobs & blobs) in oracle make sure that you use the dbms_lob package where appropriate. ie. instead of doing this: substr(myclob,10) do this: dbms_lob.substr(myclob,10).
|
|
The DBMS_PIPE package lets two or more sessions communicate in the same instance. Oracle pipes are similar in concept to the pipes used in UNIX, but Oracle pipes are not implemented using the operating system pipe mechanisms. Information sent through Oracle pipes is buffered in the system global area (SGA). All information in pipes is lost when the instance is shut down. One of the most useful aspects of Oracle pipes is that pipe communication is asynchronous: you need not COMMIT a transaction in order to initiate pipe-related activity. You can send a message through and receive a message from a pipe at any time. Indeed, more than one session can read or write to the same pipe. Depending upon your security requirements, you may choose to use either a public or a private pipe.
|
|
Oracle PL/SQL limits your ability to call a DDL statement directly from a PL/SQL Program. In order to use the DDL statements such as CREATE TABLE, DROP TABLE, and ALTER TABLE, we should use the DBMS_DDL package. This package was provided by Oracle to enable an Oracle developer to perform its DDL statement. Procedures contained in this package are ALTER_COMPILE, ANALYZE_OBJECT, SET_TRIGGER_FIRING_PROPERTY, ALTER_TABLE_REFERENCEABLE, ALTER_TABLE_NOT_REFERENCEABLE. This package also consists a function IS_TRIGGER_FIRE_ONCE.
|
|
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>
|
| Results 36 - 40 of 69 |
