Code.GeekInterview.com
 
 

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: 14155 times  

Filed in: Oracle
Add Comment


 

 

Sponsored Links


 

 

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

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

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 Your Comment:

Members Please Login
Your Name:*
e-mail ID:(required for notification)*
Image Verification: 
 
 Subscribe    



Popular Coders

# Coder NameHits
1. jamesravid39380
2. krishnaindia200732926
3. Jim.Anderson28666
4. Mohit Sharma20985
5. Beena14156
6. jainsourabh29133
7. Satheesh6002
8. SriramKrishna5009

Active Coders

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

Refined Tags