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)

Tablolarla ilgili scriptler

Table Size

{code}

select segment_name,segment_type,bytes/1024/1024 MB from dba_segments
where owner=’&Owner’
order by MB desc
{/code}

Girilen kullanıcının tüm tablolarını analiz eder
{code}SET PAGESIZE 0
SET FEEDBACK OFF
SET VERIFY OFF

SPOOL temp.sql

SELECT ‘ANALYZE TABLE “‘ || table_name || ‘” COMPUTE STATISTICS;’
FROM all_tables
WHERE owner = Upper(‘&1’)
ORDER BY 1;

SPOOL OFF

— Comment out following line to prevent immediate run
@temp.sql

SET PAGESIZE 14
SET FEEDBACK ON
SET VERIFY ON
{/code}

Tree-Style Execution planı gösterir
{code class=”brush: xml;”}SET LINESIZE 500
SET PAGESIZE 1000
SET VERIFY OFF

SELECT a.ownerid “Owner”,
Substr(name,1,40) “Name”,
type “Type”,
pipe_size “Size”
FROM v$db_pipes a
ORDER BY 1,2;

SET PAGESIZE 14
SET VERIFY ON
{/code}

Tabloları monitor eder
{code}SET VERIFY OFF

SELECT table_name, monitoring
FROM dba_tables
WHERE owner = UPPER(‘&1’)
AND table_name = DECODE(UPPER(‘&2’), ‘ALL’, table_name, UPPER(‘&2’));
{/code}

Belirlenen tabloların izlenmesini (monitoring) aktif eder
{code class=”brush: xml;”}SET PAGESIZE 0
SET FEEDBACK OFF
SET VERIFY OFF
SPOOL temp.sql

SELECT ‘ALTER TABLE “‘ || owner || ‘”.”‘ || table_name || ‘” MONITORING;’
FROM dba_tables
WHERE owner = UPPER(‘&1’)
AND table_name = DECODE(UPPER(‘&2’), ‘ALL’, table_name, UPPER(‘&2’))
AND monitoring != ‘YES’;

SPOOL OFF

SET PAGESIZE 18
SET FEEDBACK ON
{/code}

Belirlenen tabloların izlenmesini (monitoring) deaktif eder
{code class=”brush: xml;”}SET PAGESIZE 0
SET FEEDBACK OFF
SET VERIFY OFF
SPOOL temp.sql

SELECT ‘ALTER TABLE “‘ || owner || ‘”.”‘ || table_name || ‘” NOMONITORING;’
FROM dba_tables
WHERE owner = UPPER(‘&1’)
AND table_name = DECODE(UPPER(‘&2’), ‘ALL’, table_name, UPPER(‘&2’))
AND monitoring = ‘YES’;

SPOOL OFF

SET PAGESIZE 18
SET FEEDBACK ON
{/code}

{jcomments on}

Copyright © 2015 Sysdba All Rights Reserved Web Designer