To get the underlying objects that make up the DBA_ views query the DBA_VIEWS view.
SQL> Select view_name, text From DBA_VIEWS where view_name like 'DBA%';
Thanks
My Favourite Blogs
Visits
Archive
-
▼
2009
(120)
-
▼
July
(29)
- TkProf
- Event 10046 Tracing (Other's session)
- Event 10046 Tracing
- Event 10046 Levels
- Tracing other's session
- Tracing other's session in 10g
- Tracing own session
- Autotrace
- Hit Ratio in Oracle 10g
- Rollback Segment Wait to Get Ratio
- Database Wait Time to CPU Time Ratio
- Chained Row Ratio
- Latch Hit Ratio
- Execute to Parse Ratio
- Parse CPU to Parse Elapsed
- Soft Parse Ratio
- Pin Hit Ratio
- Get Hit Ratio
- Dictionary Cache Hit Ratio
- Library Cache Reload Ratio
- Library Cache Hit Ratio
- In (PGA) Memory Sort Ratio
- Buffer and Redo Nowait Ratio
- Buffer Cache Hit Ratio
- Hit Ratio Script
- AWR Basic Info
- Basic database Info
- DBA Views
- V$ Views
-
▼
July
(29)
Followers
Labels
- Performance Tuning
- ASM
- Hit Ratio Analysis
- Flashback Recovery
- SQL
- Wait Events
- Undo Tablespace
- 10g Features
- Errors
- Backup
- Tracing
- RAC
- Miscellaneous
- FRA
- RMAN
- Recovery
- SQL Scripts
- Temporary Tablespace
- Data Pump
- Installation
- OEM
- Parameters
- Shrink
- Utilities
- ADDM
- Architecture
- TSPITR
- Unix
- AWR
- High Availability
- Latch
- Network
- Privilege
Oracle Database Administration. Copyright 2008 All Rights Reserved Revolution Two Church theme by Brian Gardner Converted into Blogger Template by Bloganol dot com
1 comment:
I heartily thank you for sharing this query to see all the DBA views. I also wanted to request for sharing some more information on the concept of DBA views i.e how such views are created and what are the main types. Please do provide me with all these details in your next posts.
Post a Comment