Life is too short to be little

There are several versions for Flash Chart 2 contributed by different programmers. We can just pick from one from the list:

http://teethgrinder.co.uk/open-flash-chart-2/downloads.php

To incorporate Open Flash Chart into a java project, we can simply utilize the open source project jofc2. The jar can be downloaded from google. If maven/Ivy is used, we can simple add the dependency:
        <dependency>
            <groupId>jofc2</groupId>
            <artifactId>jofc2</artifactId>
            <version>1.0.1-SNAPSHOT</version>
        </dependency> 

And we need to add the repository reference:

        <repository>
            <id>jofc2.maven.repo</id>
            <name>JOFC2 GoogleCode.com Snapshot Repository</name>
            <url>http://jofc2.googlecode.com/svn/repository/snapshots/</url&gt;
        </repository> 

jofc2 includes a lot of APIs to build different kind of Chart objects, which can be used to generate the json string for Open Flash Chart2. To embed the chart into the page, we can simply use the following javascript:

swfobject.embedSWF(
    “/pathTo/open-flash-chart.swf”,
    “chartDiv“, “chartWidth“, “chartHeight“, “9.0.0”,
    “expressInstall.swf”,
    {“data-file”:”/flash-chart/json-chart-data“}
);
<div id=”chartDiv“></div>

If your data url includes Asian characters which needs to be encoded using UTF8, there will be some problem even you change the browser settings to encoding path/parameters using utf8(Windows). The reason is that, flash viewer sdk does NOT get the settings from browsers to encoding the URLs, they get the settings from Regional Options settings in control panel(windows). There is a workaround for this, that is to repaint the chart with asynchronized javascript call:

var swf = document.getElementById(‘chartDiv‘);
swf.reload(“/flash-chart/JSON图像数据”);

This time, it will work properly as the URL is loaded with javascript which will use the browser settings.

The most efficient/effective way to defrag/shrink a big tablespace in oracle is to migrate the tables/indexes to new tablespaces.

Here below are the steps:
1) Login with dba account and create new tablespaces for the database user.
Sample SQL:

create tablespace APP_TB2 datafile ‘/opt/oracle/storage/APP_TB2.dbf’ size 256m autoextend on next 128m maxsize unlimited;

2) Login with the db owner username/password

2.1) Migrate the tables

Generate the table migration script

spool /tmp/username/moveTables.sql

select ‘alter table ‘ || SEGMENT_NAME || ‘ move tablespace APP_TB2;’
FROM dba_Segments a,
dba_data_files b
WHERE b.file_id=a.relative_fno
and a.tablespace_name=‘APP_TB’ and segment_type=‘TABLE’
order by FILE_NAME,segment_name;

spool off;

2.2) Migrate the Indexes

Generate the index migration script

spool /tmp/username/MoveIndex.sql
select ‘alter index ‘ || SEGMENT_NAME || ‘ rebuild tablespace APP_TB2;’
FROM dba_Segments a,
dba_data_files b
WHERE b.file_id=a.relative_fno
and a.tablespace_name=‘APP_TB’ and segment_type=‘INDEX’
order by FILE_NAME,segment_name;
spool off;

2.3) Migrate the LOB/LOBSegments if possible

spool /tmp/username/MoveLob.sql
select ‘ALTER TABLE ‘ || table_name || ‘ move lob(‘ || COLUMN_NAME || ‘) STORE AS (TABLESPACE APP_TB2);’
from dba_tab_columns
where owner=‘APP_TB’ and data_type=‘CLOB’;
spool off;

3) check if anything missing in the original tablespace

set lin 300
col owner format A26
col segment_name format A26
col segment_type format A26
col tablespace_name format A26
col relative_fno format 99999
col file_name format A50

SELECT owner, segment_name, segment_type,a.tablespace_name, a.relative_fno, b.file_name
FROM dba_Segments a,
dba_data_files b
WHERE b.file_id=a.relative_fno
and a.tablespace_name=‘TB_APP’
order by FILE_NAME,segment_name;

4) Never forget to change the default tablespace of the user to the new one

ALTER USER <userName> default tablespace TB_APP2;

5) change tablespace offline

alter tablespace APP_TB offline;

There are 4 kinds of partitioned tables in oracle.
http://download.oracle.com/docs/cd/B10500_01/server.920/a96524/c12parti.htm

If you see the size of your table exceeds 2G, you can consider to convert it to a partitioned table. Here below is the method to check the table size in oracle:

COLUMN TABLE_NAME FORMAT A32
COLUMN OBJECT_NAME FORMAT A32
COLUMN OWNER FORMAT A10
SELECT owner, table_name, TRUNC(sum(bytes)/1024/1024) Meg
FROM
(SELECT segment_name table_name, owner, bytes
FROM dba_segments
WHERE segment_type = ‘TABLE’
UNION ALL
SELECT i.table_name, i.owner, s.bytes
FROM dba_indexes i, dba_segments s
WHERE s.segment_name = i.index_name
AND s.owner = i.owner
AND s.segment_type = ‘INDEX’
UNION ALL
SELECT l.table_name, l.owner, s.bytes
FROM dba_lobs l, dba_segments s
WHERE s.segment_name = l.segment_name
AND s.owner = l.owner
AND s.segment_type = ‘LOBSEGMENT’
UNION ALL
SELECT l.table_name, l.owner, s.bytes
FROM dba_lobs l, dba_segments s
WHERE s.segment_name = l.index_name
AND s.owner = l.owner
AND s.segment_type = ‘LOBINDEX’)
WHERE owner in UPPER(‘&owner’)
GROUP BY table_name, owner
HAVING SUM(bytes)/1024/1024 > 10 /* Ignore really small tables */
ORDER BY SUM(bytes) desc;

Here below are the steps to convert a big table into a partitioned table:
1) create corresponding tablespaces for the partitioned table which resides in different datafiles beforehand.
2) if you have a table named “BIG_TABLE”, create a table BIG_TABLE_TMP with the simiar definition as BIG_TABLE but with a suitable partition strategy.

Sample:
CREATE TABLE BIG_TABLE_TMP
(
ID NUMBER(19) NOT NULL,
VERSION NUMBER(10),
DAY_ID VARCHAR2(255 CHAR),
PRIMARY KEY(ID)
)
PARTITION BY RANGE (DAY_ID)
(
PARTITION BIG_TABLE_20090101 VALUES LESS THAN (‘2009-01-01’) TABLESPACE BIG_TABLE_20090101,
PARTITION BIG_TABLE_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE BIG_TABLE_OTHER
);
3) Migration the data
insert into BIG_TABLE_TMP select * from BIG_TABLE;
commit;
4) verify the data, check if the row count is the same
select count(1) from BIG_TABLE_TMP;
select count(1) from BIG_TABLE;
5) drop the original table
truncate table BIG_TABLE;
drop table BIG_TABLE;
6) rename the partition table
alter table BIG_TABLE_TMP rename to AD_SHOW;
6) add original constraints to the new table

7) add original indexes to the new table

8) verify the partitions
exec dbms_stats.gather_table_stats(‘&amp;owner’,‘BIG_TABLE’);
select partition_name, num_rows from user_tab_partitions where table_name = ‘BIG_TABLE’;