Code.GeekInterview.com
  I am new, Sign me up!
 
Code Samples Oracle
 

Oracle Database Growth Report


Code ResourceAuthor: Beena  

Difficulty Level: Beginner

Published: 15th Jul 2008   Read: 5370 times  

Filed in: Oracle
Add Comment


 


Oracle Database Growth Report by Month and Year

 


Sample Code
  1. SELECT TO_CHAR(creation_time, 'RRRR Month') "Month",
  2.        SUM(bytes)/1024/1024 "Growth in MB"
  3.   FROM sys.v_$datafile
  4.  WHERE creation_time > SYSDATE-365
  5.  GROUP BY TO_CHAR(creation_time, 'RRRR Month')
  6. /
Copyright GeekInterview.com


Next Article: Function To Convert Amount to Words


 

Latest Code Samples

 

Popular Code Samples

 

Related Code Samples

 

Post Comment


Members Please Login

Name:  Email: (Optional. Used for Notification)

Title:
 
Comment:
Validation Code: <=>  (Enter this code in text box)





Popular Coders

# Coder NameHits
1. jamesravid16273
2. Jim.Anderson8828
3. krishnaindia20078130
4. Mohit Sharma6752
5. Beena5371
6. jainsourabh24062
7. SriramKrishna1856
8. Satheesh1777

Active Coders

Refined Tags

 

Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact  

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape