Whoever Resembles a People is One of Them. He is not one of us who resembles other than us,
nor who resembles the Jews nor the Christians.(jami-at-tirmidhi-vol-5-ahadith-2695)
O you who believe (who wish to reach ALLAH C.C. before death)! Do not take my and
your enemies for friends!
And although they have denied what has come to you
from the Truth, you still love them (treating them as your friends).
If you go forth to struggle hard in My Way, seeking My Pleasure, (then why) you manifest
love to them and share with them your secrets.
And I know what you conceal and what you manifest. And whoever of you does that, then he
indeed has gone astray from the right Way. 60/Al-Mumtahanah-1
They are driving out the Messenger and yourselves from your land because you
believe in ALLAH C.C., your Lord.
Recite (read and explain to others) that which has been revealed to you of the Book
and keep up the Prayer.
Surely the Prayer keeps away from Al-Fahsh (to do what ALLAH C.C. prohibits) and Al-Munkar
(to deny what ALLAH C.C. commands).
Whoever obeys me, obeys ALLAH C.C., and whoever disobeys me, disobeys ALLAH C.C.
Whoever obeys the ruler, obeys me, and whoever disobeys the ruler, disobeys me. " (Sahih)


Veri tabanını pfile ile açma
{code}STARTUP PFILE=/u01/oracle/product/10.2.0/db_1/database/inittest.ora

emct repository yi yeniden oluşturma
Listener.ora da ip degistigi zaman em dbconsole çalismasi bozuluyor, bu komutla yeniden em repository yaratmak gerekiyor.
{code class=”brush: xml;”}c:\>emca -config dbcontrol db -repos recreate

show parameter sessions
{code}alter system set sessions=555 scope=SPFILE;
veya (default SID ‘den farklı bir SID için değişiklik yapılacaksa)
alter system set sessions=555 scope=both sid=’*’;
alter system set processes=500 scope=both sid=’*’;
alter system set transactions=610 scope=both sid=’*’;

windows SID set
{code class=”brush: xml;”}set ORACLE_SID=SID_ISMI

Session Kill

{code class=”brush: xml;”}Select ‘alter system kill session ‘||”” ||sid||’,’||serial#||””||’;’ from v$session where lockwait is not null order by osuser;

{code class=”brush: xml;”}Select ‘alter system kill session ”’||sid||’,’||serial#||”’ immediate ;’ from v$session where lockwait is not null order by osuser;{/code}

isqlplus ın süresi uzatılmak istemiyorsa (idle kalınca session ı kapatma durumu)

{code class=”brush: xml;”}/u01/app/oracle/product/10.2.0/db_1/oc4j/j2ee/isqlplus/config/server.xml


rakamı arttırılır.

Execution Time&Plan

{code}set timing on;
set autotrace traceonly explain;{/code}
{code class=”brush: xml;”}alter system flush shared_pool;{/code}


{code}SQL> Spool on
SQL> Spool c:\spooltext.txt
SQL> Query
SQL> Spool off

Bir şemadaki belirli bir tbs deki tabloların drop edilmesi
{code}select ‘DROP TABLE “system”.”‘||table_name||'” CASCADE CONSTRAINTS ;’ from user_tables{/code}

{jcomments on}

Copyright © 2015 Sysdba All Rights Reserved Web Designer