SELECT U.TABLESPACE_NAME AS "TableSpace"
         , SUM(U.BYTES) / 1024000 AS "Size (MB)"
         , (SUM(U.BYTES) - SUM(NVL(F.BYTES,0))) / 1024000 AS  "Used (MB)"
         , TRUNC(100 - (SUM(NVL(F.BYTES,0)) / SUM(U.BYTES)) * 100,2) "Used (%)"
         , (SUM(NVL(F.BYTES,0))) / 1024000 "Free (MB)"
         , TRUNC((SUM(NVL(F.BYTES,0)) / SUM(U.BYTES)) * 100,2) "Free (%)"
  FROM DBA_FREE_SPACE F, DBA_DATA_FILES U
 WHERE F.FILE_ID(+) = U.FILE_ID
 GROUP BY U.TABLESPACE_NAME
 ORDER BY U.TABLESPACE_NAME;

SYSTEM 계정으로 실행해야 함.
해당 테이블 스페이스의 모든 블럭들을 합산하여 계산.

'Source Storage > DataBase' 카테고리의 다른 글

MS-SQL Convert 함수  (0) 2010.04.22
오라클 테이블 스페이스 사용량 분석  (0) 2010.03.29
오라클 사용자 관리하기  (0) 2008.09.08
Oracle Table Partitioning  (0) 2008.04.22
ORACLE HINT RULE  (0) 2008.04.04
ORACLE TABLE INDEX RULE  (0) 2008.03.27
Log Parser 2.2

Brief Description
Log parser is a powerful, versatile tool that provides universal query access to text-based data such as log files, XML files and CSV files, as well as key data sources on the Windows® operating system such as the Event Log, the Registry, the file system, and Active Directory®.

Overview

Log parser is a powerful, versatile tool that provides universal query access to text-based data such as log files, XML files and CSV files, as well as key data sources on the Windows® operating system such as the Event Log, the Registry, the file system, and Active Directory®. You tell Log Parser what information you need and how you want it processed. The results of your query can be custom-formatted in text based output, or they can be persisted to more specialty targets like SQL, SYSLOG, or a chart.

Most software is designed to accomplish a limited number of specific tasks. Log Parser is different... the number of ways it can be used is limited only by the needs and imagination of the user. The world is your database with Log Parser.

System Requirements

  • Supported Operating Systems: Windows 2000; Windows Server 2003; Windows XP Professional Edition

Log Parser Examples

Search for Data

Search for the logons of a specific user among the events in the Windows Event Log:

C:\>LogParser "SELECT TimeGenerated, SourceName,
EventCategoryName, Message INTO report.txt FROM Security WHERE
EventID = 528 AND SID LIKE '%TESTUSER%'" -resolveSIDs:ON

And obtain results in a text file formatted as desired:

사용자 삽입 이미지

Create Reports

Create custom-formatted HTML reports:

사용자 삽입 이미지

Calculate Statistics

Calculate the distribution of the HTTP response status codes from your IIS log files:

C:\>LogParser "SELECT sc-status, COUNT(*) AS Times INTO Chart.gif
FROM <1> GROUP BY sc-status ORDER BY Times DESC" –
chartType:PieExploded3D -chartTitle:"Status Codes"

And produce a chart formatted as desired:

사용자 삽입 이미지

---------------------------------
MS에서 만든 IIS 로그용 분석 프로그램... 쿼리를 이용해서 로그를 만드는거 같은데... 이게 웹에서 컨트럴이 가능하다면.... 좋겠구만.. 암튼 좀 더 봐야 할듯.. 웹컨트럴과 웹에서 그래픽등의 출력만 지원한다면 .. 좋.겠.다.
DOWNLOAD LINK  EXAMPLES LINK

'Source Storage > Programming' 카테고리의 다른 글

ASP Dictionary Object  (0) 2008.04.07
Microsoft Log Parser 2.2  (0) 2008.03.28
Windows Server 2008 Release  (0) 2007.10.02
JavaScript String Object  (0) 2007.07.31
날이면 날마다 까먹는 정규식 구성요소 (RegExp)  (0) 2007.04.18
HTML 특수문자 코드표  (0) 2007.03.21

+ Recent posts