This is a bug of oracle. If gather schema takes much time it doesn't complete the full operation and WRI$_OPTSTAT_HISTHEAD_HISTORY keeps up growing. It exhausts the SYSAUX tablespace. Oracle recommends a patch to be applied to resolve the above problem. But, in our case there is some
How to move a table to a tablespace with higher block size
For improving performance we need to move table to a different tablespace with higher block size. Higher blocksize increase the performance of select query tremendously. The following short article shows the process of creating the higher block tablespace and moving the table to it.
How to delete tempfile in temporary tablespace in Oracle database
First identify the temporary tablespace and corresponding datafiles issueing following command.
ORA-27123 error during oracle database start
Issue
While starting the oracle database 10g [10.1.0.5.0], we get the following error.
ORA-27123: unable to attach to shared memory segment
While starting the oracle database 10g [10.1.0.5.0], we get the following error.
ORA-27123: unable to attach to shared memory segment
How to delete tempfile in temporary tablespace in Oracle database
First identify the temporary tablespace and corresponding datafiles issuing following command.
Subscribe to:
Posts
(
Atom
)