How to Compress an Oracle Database for WAN Traffic
The Oracle PL/SQL language lets you compress tables with your queries, so you can compress the data when the user queries data from the server over a WAN connection. A WAN connection is slower than a standard local hardwired connection, so compressing the data as it transfers makes your applications faster for your users. You use the "compress" statement with your queries to compress the data.
Other People Are Reading
Instructions
-
-
1
Open the Enterprise Manager software from the Windows program menu on a computer that has a connection to the Oracle database.
-
2
Log in to your server when you are prompted for your username and password. Open the PL/SQL editor to view your stored procedures.
-
-
3
Right-click your procedure and select "Modify" to view the code for the stored procedure. Locate your "select" statement, which is the statement that retrieves data for the applications.
-
4
Add the compress statement after the query. The following code compresses the returned values:
DEFAULT COMPRESS;
-
5
Click the "Save" button and click "Execute" to run the procedure and test the new code.
-
1
