From the course: Learning Oracle Database 12c
Join today to access over 25,300 courses taught by industry experts.
Dynamic Performance Views (V$) - Oracle Database Tutorial
From the course: Learning Oracle Database 12c
Dynamic Performance Views (V$)
- [Instructor] Oracle dynamic performance views, why are they called dynamic, well, you'll find out. Here's what Oracle dynamic performance views look like. They all begin with either V$ or GV$, G meaning global, in a clustered database environment. V$ views contain dynamic information, up to the day, up to the moment information about different things going on in the database. What state the instance is in, what kind of sessions are running, what does the memory look like, and so forth. When the database shuts down, the V$ views are gone. And they get reloaded again as soon as the database starts up. Here's a short list of things that end up in V$ views: session information, locking information, if a backup is running, what's the current status, how much memory is being used by the SGA or PGA, what are the current system recession parameters, what sequel is running, and so forth. V$ views typically represent what's in that…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.