Sql Tuning Teknikleri Sunumu

Turkcell Teknoloji 2009 çalıştayı Sql Tuning Teknikleri sunumum

21Subat_Sql_Tuning_Techniques_Presentation [English Content]

Turkcell Teknoloji , Hasan Tonguç Yılmaz ve çalıştayı gerçekleştirmemizde emeği geçen herkese teşekkürler.

Sunumda kullanılan kaynaklar - references
Christian Antognini - Troubleshooting Oracle Performance
optimizermagic.blogspot.com
Oracle Performance Tuning Guide 10.2

Content Management Sunumu

Bireysel eğitim merkezinde
Oracle Akademi Türkiye kapsamında yaptığım
Oracle Spatial , Large Objects , XML DB ve Oracle Text konularını içeren sunumum.

18 Ekim Sunum[English Content]

Sunum yapanlara, yetkililere ve katılımcılara teşekkürler çok keyifli bir gün oldu.

apex upload store as clob

i'll provide a function which i have used in my latest project.This function getting uploaded blob content and converting this to clob.

you know apex file browse item storing uploded content into wwv_flow_files as blob after that developer responsible for storing this content in application spesific tables via fetching from wwv_flow_files

if you need to store your uploded content from apex as clob
you can use this function



FUNCTION uploaded_clob(p_name IN VARCHAR2) RETURN CLOB IS

l_clob_content CLOB;
l_blob_content BLOB;
l_w PLS_INTEGER;
l_d_offset PLS_INTEGER := 1;
l_s_offset PLS_INTEGER := 1;
l_lc PLS_INTEGER := dbms_lob.default_lang_ctx;

BEGIN

dbms_lob.createtemporary(lob_loc => l_clob_content, cache => TRUE);

SELECT *
INTO l_blob_content
FROM (SELECT t.blob_content
FROM wwv_flow_files t
WHERE t.NAME = p_name
ORDER BY created_by DESC)
WHERE rownum < 2;

dbms_lob.converttoclob(dest_lob => l_clob_content,
src_blob => l_blob_content,
amount => dbms_lob.lobmaxsize,
dest_offset => l_d_offset,
src_offset => l_s_offset,
blob_csid => dbms_lob.default_csid,
lang_context => l_lc,
warning => l_w);

RETURN l_clob_content;

END uploaded_clob;


annoying broken images problem after apex installation solved

you decided to upgrade your apex 3.1
everyting fine you executed installation script and then pointed your browser to

localhost:8080/apex

very nice page opened but some images missing and javascript doesntwork

you read some blog posts about this problem and they say execute
@apxldimg script like below

say directory_you_unzipped_apex_zip = d:\apex
@apxldimg.sql directory_you_unzipped_apex_zip -> this is wrong !

when i look inside apxldimg.sql i saw

create directory APEX_IMAGES as '&1/apex/images';

so you should use this script as

parent_directory_you_unzipped_apex_zip = d:\
@apxldimg.sql parent_directory_you_unzipped_apex_zip

after script is loading images to database xml

how to switch between multiple oracle home (version) on same machine

there is a nice tool for switching oracle homes in universal installer
from installed products on environment tab just send up your choise and apply it

installing apex to 11g

i have installed 11g to windows xp, you know apex 3.0 which is coming bundled with 11g , after the installation

i followed this great tutorial provided by oracle
http://www.oracle.com/technology/obe/11gr1_db/install/apexinst/apexinst.htm#o

and successfuly started to use apex

Oracle News Aggregator

i want to share a web site which is new for me and
very nice who want to dive into oracle :D

http://orana.info/