| |
You are here: Experts > Computing/Technology > Oracle > Oracle > Active sesions Problem
Oracle - Active sesions Problem
Expert: Peter Choi - 11/3/2009
Question
Hi Peter,
we are using 10g server, Every day from 10Pm to 11Pm Active sessions are increasing and effecting our application posting speeds,Could u help me
1.why it is happening everyday at 10Pm.
2.is there any effect in Oracle performance due to
active sessions
3.Please explain how it will effect the performance and
cleare information regrding Active sessions
If had attached pic,if you need any information mail me..
Answer
Hi Kaylan,
Do you have any batch processing scheduled to run at or around 10PM? By scheduled batch process, it could include bulk loads, bulk updates, database backups, exports, RMAN, etc.
If you only have one (or two) scheduled activity, that in itself should not be of great concern. If there are many (10<) end-users who need or are reporting latency during that time, then it may need to be looked at to alleviate their performance issues.
If this was occurring during your peak business hours, that would be of higher concern and priority.
If you are using DBMS_JOBS to schedule database process, that may be the first place that I would look at (also accessible via Oracle Enterprise Manager under scheduled jobs). If you're on a Unix/Linux system, take a look at the CRON jobs owned by the database user (usually "oracle"). If you're on a MS-Windows system, take a look at the Windows task scheduler for any scheduled process.
Hope this helps.
Peter
Add to this Answer Ask a Question
|
|
)