[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

too many archives are generating by oracle

Posted on 2009-04-23
3
Medium Priority
?
359 Views
Last Modified: 2013-12-19
Experts,

i am getting one problem with my oracle 9.2.0.7 database. we are seeing archives are generating high. it was  not happened in the past.

i have check backup and import operations. i have check the tablespace status.

i could not find the reason for it. could you please help me to find out the problem.

database is running on AIX 5. how do i find top OS processes on AIX?


0
Comment
Question by:pavan27
  • 2
3 Comments
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 24244587
man top
 
0
 
LVL 29

Accepted Solution

by:
MikeOM_DBA earned 2000 total points
ID: 24253002
Also you may want to install statspack (if you havent) and generate a report for the period of time these logs are being written, there you will find out which program/module and SQL is generating these logs.
 
 
0
 
LVL 1

Author Comment

by:pavan27
ID: 24360974
i have generated statspack report. i will update the statspack reports soon
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Suggested Courses
Course of the Month20 days, 2 hours left to enroll

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question