查詢資料量大的Table

select * from dba_segments s, dba_tables t
where s.owner = t.owner 
and   s.SEGMENT_NAME = t.TABLE_NAME
and   s.OWNER not in  ('SYS', 'SYSTEM')
order by bytes desc;

下載檔案

//利用 java.net.URLEncoder.encode 把檔名轉成中文，避免下載時產生亂碼
response.setHeader("Content-Disposition","attachment; filename=" + java.net.URLEncoder.encode(request.getParameter("key"),"utf-8"));