Oracle very slow

[jmcandido]

Environment information:
* Oracle version: Oracle Database 10g Release 10.2.0.3.0 - Production
* Operating system: Windows Server 2003 R2 Dual Core 2,70GHz 8,00GB RAM.

Good morning everyone, we have a database running in the environment described above, some time we are noticing that the system has been very slow, at times of the day is almost stopped, the processes very time-consuming.
I have a note on the windows monitoring that processor and memory are little used, in compensation the read disk usage levels are all 100%.
I still do not know if it can be some Oracle configuration, some project process (system) or something on the server (Windows)
would like your help to help you assist Oracle to find out if slowness is something in Oracle, or if I get to look for things in Windows.
Thank you.

[elidias7]

Oops!

By the Oracle basic administration would be interesting to check the memory parameters, indices, query's, etc.

is complicated to speak what is so ....................

Hugs,

[ecalvetti]

JMcandido,

For the low information, I would say for you to proceed as follows:

1) Make a rebuild of the indexes.

2) Generate statistics.

I believe this can solve your problem.

The suggestion is you schedule for every Sunday, in the Windows Schedule, something that shoots the following command:

Select all

c:\manutencao\rebuild.bat instancia_bco schema_bco

in the rebuild.bat file quoted in the Schedule, you can place:

Select all

set ORACLE_SID=%1 
set OWNER_BCO=%2 
set DIRTRAB=c:\manutencao 
 
sqlplus / as sysdba @%DIRTRAB%\index.sql 
 
del /q /f %DIRTRAB%\rebuild_%ORACLE_SID%_%OWNER_BCO%.sql 
 
exit 

in the file index.sqlquoted in




After rotating this, you have done the recturbation of the indexes that may be shot And generated statistics that impact directly on database performance.

Any questions just ask, we are there!

Hugs,

Ewerton Calvetti
OCA - Oracle Certified Associates
ITIL Foundation