ORACLE - CHECK DATABASE SIZE

TO CHECK DATABASE SIZE, USE THIS SQL IN TOAD OR SQLPLUS :



select ROUND( ( a.data_size + b.temp_size +
c.redo_size + d.cf_size +
e.bct_size)
/1024/1024/1024
) "total_GB_size"
from
( select SUM(bytes) data_size from v$datafile) a,
( select NVL(sum(bytes),0) temp_size from v$tempfile) b,
( select SUM(bytes) redo_size from v$log) c,
( select SUM(block_size*file_size_blks) cf_size from v$controlfile) d,
( select NVL(bytes,0) bct_size from v$block_change_tracking) e


 total_GB_size = 215


select a.data_size+b.temp_size+c.redo_size "total_size"
from ( select sum(bytes)/1024/1024 data_size
from dba_data_files )a,
( select nvl(sum(bytes),0)/1024/1024 temp_size
from dba_temp_files ) b,
( select sum(bytes)/1024/1024 redo_size
from sys.v_$log ) c

Oracle - DISPLAY LOCK ACCOUNT

This is how you select all the LOCKED account in your oracle database :


SELECT username, account_status
FROM dba_users
where account_status = 'LOCKED'

KURSUS COLDFUSION

Saya telah mengendalikan satu kursus Latihan Pembangunan Web Applikasi menggunakan Adobe Coldfusion For Beginners pada 14 dan 15 Disember 2011 dibantu oleh Puan Masita bertempat di Makmal Komputer, Pejabat Teknologi Maklumat, UiTM Shah Alam.

Pembelajaran ada dalam kaedah Virtual Box dengan OS Windows XP untuk memudahkan peserta.

Berminat untuk sebarang kursus Adobe Coldfusion? email saya di hairekahfi@gmail.com

Modul Pembelajaran :

1. UNIT 1: GETTING STARTED WITH COLDFUSION 8
1.1. INSTALLING SOFTWARE AND COURSE FILES
1.2. UNDERSTANDING DYNAMIC WEB PAGES

1.3. INTRODUCING COLDFUSION 8
1.4. EXPLORING DREAMWEAVER CS4

2. UNIT 2: BUILDING COLDFUSION APPLICATIONSLESSON 1: CREATING COLDFUSION VARIABLES
2.2. LESSON 2: DISPLAYING VARIABLE VALUES
2.3. LESSON 3: INCLUDING FILES
2.4. LESSON 4: COMMENTING CODE
2.5. BEST PRACTICES AND SUMMARY
2.6. ON YOUR OWN: VIEWING THE COURSE APPLICATION

3. UNIT 3: PUBLISHING DATABASE CONTENT
3.1. LESSON 1: CONNECTING TO A DATABASE
3.2. LESSON 2: QUERYING A DATABASE TABLE
3.3. LESSON 3: VIEWING DEBUG DATA
3.4. LESSON 4: DUMPING A RECORDSET TO A BROWSER
3.5. LESSON 5: DISPLAYING DATABASE DATA
3.6. LESSON 6: USING THE DYNAMIC TABLE TOOL
3.7. LESSON 7: USING THE RESULTSET STRUCTURE DATA
3.8. LESSON 8: USING COLDFUSION FUNCTIONS
3.9. BEST PRACTICES AND SUMMARY
3.10. ON YOUR OWN: CREATING THE HOME PAGE

4. UNIT 4: BUILDING FORMS WITH COLDFUSION
4.1. LESSON 1: UNDERSTANDING HTML FORMS
4.2. LESSON 2: ENABLING DEBUG OUTPUT
4.3. LESSON 3: SELF-POSTING FORMS
4.4. LESSON 4: DETERMINING FORM SUBMISSION
4.5. LESSON 5: EVALUATING FORM VARIABLES
4.6. LESSON 6: INTRODUCING COLDFUSION FORMS
4.7. BEST PRACTICES AND SUMMARY
4.8. ON YOUR OWN: CREATING A SEARCH FORM
5. UNIT 5: BUILDING SEARCH INTERFACES
5.1. LESSON 1: USING FORM DATA IN DYNAMIC QUERIES
5.2. LESSON 2: PRESERVING FORM DATA
5.3. LESSON 3: CREATING DYNAMIC SQL FOR MULTIPLE SEARCH CRITERIA
5.4. LESSON 4: USING TEXT SEARCHES
5.5. LESSON 5: USING LIST SEARCHES
5.6. BEST PRACTICES AND SUMMARY
5.7. ON YOUR OWN: BUILDING CHECK ORDER STATUS LOGIC

6. UNIT 6: BUILDING A DRILL-DOWN INTERFACE
6.1. LESSON 1: USING DYNAMIC URL PARAMETERS
6.2. LESSON 2: CREATING A DATA DRILL-DOWN
6.3. LESSON 3: CREATING ON-THE-FLY PDF DOCUMENTS
6.4. LESSON 4: DISPLAYING DATA IN A TABBED INTERFACE
6.5. BEST PRACTICES AND SUMMARY
6.6. ON YOUR OWN: DISPLAYING ORDER ITEM INFORMATION

7. UNIT 7: INSERTING NEW DATA
7.1. LESSON 1: BUILDING AN INSERT FORM PAGE
7.2. LESSON 2: VALIDATING COLDFUSION FORMS
7.3. LESSON 3: BUILDING INSERT ACTION LOGIC
7.4. LESSON 4: REDIRECTING PROCESS FLOW
7.5. BEST PRACTICES AND SUMMARY
7.6. ON YOUR OWN: ADDING AN ART PIECE
8. UNIT 8: UPDATING AND DELETING DATA
8.1. LESSON 1: BUILDING AN UPDATE FORM PAGE
8.2. LESSON 2: BUILDING UPDATE LOGIC
8.3. LESSON 3: DELETING RECORDS FROM THE DATABASE
8.4. LESSON 4: IMPROVING SQL SECURITY
8.5. BEST PRACTICES AND SUMMARY
8.6. ON YOUR OWN: UPDATING ART WORK DATA

9. UNIT 9: REUSING TEMPLATES
9.1. LESSON 1: REUSING CODE
9.2. LESSON 2: USING USER-DEFINED FUNCTIONS
9.3. LESSON 3: INTRODUCING COLDFUSION COMPONENTS
9.4. BEST PRACTICES AND SUMMARY
9.5. ON YOUR OWN: CREATE AND USE A CUSTOM TAG

10. UNIT 10: SECURING AN APPLICATION
10.1. LESSON 1: USING THE APPLICATION FRAMEWORK
10.2. LESSON 2: USING APPLICATION VARIABLES
10.3. LESSON 3: PERSISTENT STATE VARIABLES AND WORKING WITH SESSION
10.4. VARIABLES
10.5. BEST PRACTICES AND SUMMARY