Discussions
Categories
- 384.6K All Categories
- 2.5K Data
- 556 Big Data Appliance
- 1.9K Data Science
- 451.4K Databases
- 222.1K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 32 Multilingual Engine
- 561 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 561 SQLcl
- 4K SQL Developer Data Modeler
- 187.5K SQL & PL/SQL
- 21.4K SQL Developer
- 296.9K Development
- 1 Application Development
- 18 Developer Projects
- 140 Programming Languages
- 293.6K Development Tools
- 112 DevOps
- 3.1K QA/Testing
- 646.2K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 193 Java Community Process
- 106 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 21 Java Essentials
- 166 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 206 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 536 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 178 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 236 Portuguese
Database constantly accessing disk
I have an 11.1.0.7 database installed on a Win7 domain PC. I have a local admin account and the database was installed with that account. This is a development environment on my machine; it's not critical for production, but I do use it extensively to support our customers. The database started constantly accessing the disk a couple of days ago when I was importing some data.
What is the best approach to figure out what is causing the problem and then fixing it? Is there some way that I can look at a session and see what's generating all of the disk activity? I'm new to this aspect of DBA activities. I'll appreciate any suggestions.
Answers
-
"The database started constantly accessing the disk a couple of days ago when I was importing some data."
How do you know it wasn't accessing disk few days ago :-)
-
Install statspack, configure for 1/2 hour, see what report says. You sure it's database and not some anti virus or swapping or something? Show SGA, tell us hardware configuration. Is dbconsole running?
-
>Is there some way that I can look at a session and see what's generating all of the disk activity? I'm new to this aspect of DBA activities. I'll appreciate any suggestions.
You have posted NO evidence that the database is the source of the disk activity.
It could just Windows malware running wild.
How do I ask a question on the forums?
-
"The database started constantly accessing the disk a couple of days ago when I was importing some data"
An import will access the disk. So will usage of swap space.
How do you know there is a problem?
-
Thanks for the pointers. I should be able to get all of those things done tomorrow (between customer challenges :-)).
-
Where did you get the information it was Oracle accessing the disks? Did you look in the Windows Resource Monitor to see what processes it is? As stated before, did you look to see if it is your antivirus? I've had issues with antiviruses that are actively "protecting" my systems and I regularly have to request that they exclude Oracle datafiles from the AV's active protection and scans.