O'Reilly logo

Expert Oracle PL/SQL by Michael McLaughlin, Ron Hardman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required