Database Administration Questions

ALTER DATABASE DATAFILE <datafile_name> RESIZE <new_size>; 

ALTER TABLESPACE ADD DATAFILE <datafile_name> SIZE <size>

You get this error when you get a snapshot too old within rollback. It can usually be solved by increasing the undo retention or increasing the size of rollbacks. You should also look at the logic involved in the application getting the error message.

Use the buffer cache advisory over a given workload and then query the v$db_cache_advice table. If a change was necessary then I would use the alter system set db_cache_size command.

- Installing and upgrading the Oracle Server and application tools.

- Allocating system storage and planning future storage requirements for the database system.

- Managing primary database structures (tablespaces)

- Managing primary objects (table, views, indexes)

- Enrolling users and maintaining system security.

- Ensuring compliance with Oracle license agreement

- Controlling and monitoring user access to the database.

- Monitoring and optimizing the performance of the database.

- Planning for backup and recovery of database information.

- Maintain archived data on tape

- Backing up and restoring the database.

- Contacting Oracle Corporation for technical support.

ALTER SYSTEM SWITCH LOGFILE;

SQL * DBA - This allows DBA to monitor and control an ORACLE database. SQL * Loader - It loads data from standard operating system files (Flat files) into ORACLE database tables. Export (EXP) and Import (imp) utilities allow you to move existing data in ORACLE format to and from ORACLE database.

In a database table, the category of information is called Field.