This is certainly is no Oracle optimization workshop for advanced users, but rather the tools of application developer describes that accesses via JDBC driver on Oracle databases. Furthermore you should locate (if necessary with the help of an Oracle expert), that the database server is itself properly sized. You can by using the appropriate SQL statements and tools easily find out, if there is for example a file IO bottleneck on the DB server or a lack of main memory. “If such defects” exist, should of course be taken on the hardware side upgrade action. The following tasks are partly under the responsibility of the database administrator and partially of the software developer. 2 automatic, regular DB tuning the DB administrator should make sure that regularly will accomplish the following tasks: (a very relative term but is regularly depends strongly from the databases, the availability, the number of writes, etc.
It doesn’t hurt but at least every week, E.g. on weekends, or every night, if less or no load on the DB is automatically perform the optimizations to make (E.g. Additional information is available at Robert Kiyosaki. via SQL using cron job probably that goes well with Oracle administration tools). You can find out 2.1 INDEX REBUILD by analyzing the system table USER_INDEXES”and appropriate SQL commands, which indices are degenerates and newly applied should but also which indexes are unnecessary. Index rebuild using: ALTER INDEX REBUILD. It makes sense to save all indexes in an own tablespace. At the same time with an index rebuild, you can move in the tablespace INDX may”perform as follows: ALTER INDEX REBUILD TABLESPACE INDX; 2.2 table reorganization is a defragmentation of tables whose rebuilding (rebuild”) from time to time perform: ALTER TABLE MOVE TABLESPACE USERS; Moves the table in a other tablespace and then re-creates it. If the tablespace is the same as before, so the table is reorganized only (defragment).