For how many years have you been working
with physical servers that are starving your database of the memory
necessary to deploy important new performance features such as the Result
Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and
Full Database Caching? Too long? Contact me to learn how to improve all
queries ... not just some queries.
This package is a PL/SQL package implementing Simple
Oracle Document Access (SODA). SODA allows you to use the Oracle Database
as a NoSQL document store. The core abstraction provided by SODA is that
of document collections. The DBMS_SODA package allows you to create, list,
and delete document collections from PL/SQL, and to perform CRUD (create,
replace, update, delete) operations on documents.
All DDL functions are encapsulated within this package.
TYPE soda_collection_t ...;
TYPE soda_collName_list_t ...;
Owned by SYS with EXECUTE granted to PUBLIC
The Library's recommendation is that you revoke EXECUTE from PUBLIC.
Everybody with a valid userID does not need to be able to drop