Chapter 12. Managing the Database
PL/SQL is not just for developers. Database administrators (DBAs) use and are impacted by PL/SQL every day, and rely on scripts, supplied packages, and utilities to manage the database. In this chapter, we focus on Oracle supplied packages that are of particular interest to DBAs. The following topics are discussed:
Database performance management
Moving OS files from within the database
File compression
Exporting and importing data while using filters
Securing your applications with encryption
You will want to download this chapter's code, including the user creation script and seed data, from the Oracle Press web site, or from www.PLSQLBook.com.
Database Performance
Performance tuning is an area looked upon by many as ...
Get Expert Oracle PL/SQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
