background preloader

Prad_kr2001

Facebook Twitter

Pradeep KR

Oracle Tablespaces. Create table t_contig_space ( tablespace_name VARCHAR2(30), file_id NUMBER, block_id NUMBER, starting_file_id NUMBER, starting_block_id NUMBER, blocks NUMBER, bytes NUMBER) tablespace uwdata; CREATE OR REPLACE VIEW v_contig_space AS SELECT SUBSTR(tablespace_name,1,20) TABLESPACE_NAME, starting_file_id, starting_block_id, SUM (blocks) sum_blocks, COUNT(blocks) count_blocks, MAX(blocks) max_blocks, SUM (bytes)/1024/1024 SUM_MB FROM tl_contig_space GROUP BY tablespace_name, starting_file_id, starting_block_id; DECLARE CURSOR query IS SELECT * FROM dba_free_space ORDER BY tablespace_name, file_id, block_id; this_row query%ROWTYPE; previous_row query%ROWTYPE; old_file_id PLS_INTEGER; old_block_id PLS_INTEGER; BEGIN OPEN query; FETCH query INTO this_row; previous_row := this_row; old_file_id := previous_row.file_id; old_block_id := previous_row.block_id;

Citibank India Home. Waz-Warez. Geetham Carnatic and Entertainment Source. Rapidshare, Mediafire, Megashares, Full Downloads - WarezUSA. Sign In. CERTIFICATION Home Page. Computer-Based Testing Provider for Certification and Licensure Exams: Pearson VUE. Search Engine for all FileShares: 4Shared Mediafire Rapidshare Hotfile Mediafire Depositfiles Easy-share Turbobit Sharedzilla Gigasize etc. Search Shared Files Easy & Download Fast.

FileCrop - Search and Download Rapidshare Mediafire and Hotfile Files.