- 3,727,079 Users
- 2,245,318 Discussions
- 7,852,571 Comments
Forum Stats
Discussions
Howdy, Stranger!
Categories
- 380.8K All Categories
- 16 Data
- 362.2K Big Data Appliance
- 7 Data Science
- 2.3K Databases
- 670 General Database Discussions
- 3.7K Java and JavaScript in the Database
- 32 Multilingual Engine
- 499 MySQL Community Space
- 8 NoSQL Database
- 7.7K Oracle Database Express Edition (XE)
- 2.8K ORDS, SODA & JSON in the Database
- 424 SQLcl
- 68 SQL Developer Data Modeler
- 185.2K SQL & PL/SQL
- 21.1K SQL Developer
- 2.7K Development
- 3 Developer Projects
- 32 Programming Languages
- 135.9K Development Tools
- 18 DevOps
- 3K QA/Testing
- 381 Java
- 15 Java Learning Subscription
- 14 Database Connectivity
- 72 Java Community Process
- 2 Java 25
- 13 Java APIs
- 141.2K Java Development Tools
- 14 Java EE (Java Enterprise Edition)
- 153K Java Essentials
- 135 Java 8 Questions
- 86.2K Java Programming
- 270 Java Lambda MOOC
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 18 Java SE
- 13.8K Java Security
- 4 Java User Groups
- 22 JavaScript - Nashorn
- 18 Programs
- 156 LiveLabs
- 36 Workshops
- 11 Software
- 5 Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 4 Deutsche Oracle Community
- 17 Español
- 1.9K Japanese
- 4 Portuguese
How to monitor hourly application user statistics (data throughput) in Oracle database?
ProDBA
Member Posts: 105 Blue Ribbon
in SQL & PL/SQL
We have a requirement to collect the user related statistics of different application users. Which means that, for example, user A performed X number of SELECT statements against the database within past hour, and these statements caused Y GB of data reads and Z GB of data writes.
We know that Oracle automatically collects AWR snapshots every hour.
Can we obtain this information from these snapshots? And how?
Or any suitable method will be thoroughly appreciated.
Tagged: