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

Oracle Code Base

 • Compare data in tables of the local Oracle schema
 • Converting Rows to Columns
 • Database Health check
 • Encryt and Decrypt Text messages
 • Function To Convert Amount to Words
 • Oracle Calendar SQL
 • Oracle Database Cold backup Unix
 • Oracle Database Growth Report
 • Partition Management package
 • Report Generator
 • SQL to Find Experience of an Employee
 
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

 ♦ Converting Rows to Columns
 ♦ Oracle Database Growth Report
 ♦ Function To Convert Amount to Words
 ♦ Report Generator
 ♦ Database Health check
 ♦ Oracle Database Cold backup Unix
 ♦ SQL to Find Experience of an Employee
 ♦ Oracle Calendar SQL
 ♦ Partition Management package
 ♦ Encryt and Decrypt Text messages
 

Popular Code Samples

 ♦ Converting Rows to Columns
 ♦ Function To Convert Amount to Words
 ♦ Oracle Calendar SQL
 ♦ Encryt and Decrypt Text messages
 ♦ Oracle Database Growth Report
 ♦ Database Health check
 ♦ Partition Management package
 ♦ SQL to Find Experience of an Employee
 ♦ Oracle Database Cold backup Unix
 ♦ Report Generator
 

Related Code Samples

 » Jasper Report Application
 » Storing Images and PDF Files In Oracle
 » Recover Tables Data from Corrupt MS Access Database
 » Report Generator
 » Database Health check
 » Oracle Database Cold backup Unix
 » Oracle Calendar SQL
 » Compare data in tables of the local Oracle schema
 

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

# Coder NameCodes
1. jamesravid3
2. Mohit Sharma2
3. Satheesh1
4. jainsourabh21
5. SriramKrishna1
6. krishnaindia20071
7. Beena1
8. Jim.Anderson1

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