What keeps the automotive supply chain turning smoothly? Database performance.
What makes it grind to a halt? Delayed database response.
Anji Logistics serves automotive and parts manufacturers across China, delivering up to 6.4 million automobiles and 100 million automotive parts per year. Maintaining that kind of volume depends on ensuring that orders are received in its transportation management system less than three minutes after its automotive partners place them.
Anji Logistics can’t spare the time for delays anywhere in its Oracle back end, so it monitors database performance with Foglight for Oracle. Its IT personnel now receive alerts from Foglight, helping them trim resolution time from two hours down to less than 30 minutes and reducing the number and duration of delays in inbound orders.
Minutes matter, and Anji Logistics is saving them.
As a DBA, you’ve probably seen your responsibilities grow beyond keeping servers running. You’re likely responsible for ensuring the integrity and availability of data, especially in this era of big data. The smarter the tools you choose, the fewer time-consuming manual tasks you’ll have, the higher service levels you’ll maintain and the sooner you’ll see which applications and users are impacted by a database issue.
Foglight for Oracle includes Performance Investigator (PI), which gives you insight into areas like database resources, workload analytics and change tracking. PI is designed to give you a complete picture of your environment so you can find and fix performance issues before they put your database at risk.
PI’s capabilities help you keep your database environment running strong:
The IT personnel at Anji Logistics are able to monitor their Oracle database hit ratio, session conversations, login user status and usage in the shared pool and redo log, database memory, and database CPU. Read the case study, Logistics firm speeds up supply chain efficiency with performance monitoring, to see how the automotive supplier is using Foglight for Oracle to support its efficient warehouse processes.
About John Maxwell
John Maxwell leads the Product Management team for Foglight at Dell Software. Outside of work he likes to hike, bike, and try new restaurants.
View all posts by John Maxwell |
Very interesting and useful information for me! Thanks a lot...