28 Kasım 2011 Pazartesi

Oracle faydali sql`ler

-> scheman'in indexlerinin cikartilmasi ve toplu olarak acilmasi(schemaadi yerine sizin schema adini girmelisiniz)

select 'alter index schemaadi.'||index_name||' monitoring usage;' from dba_indexes where owner=schemaadi order by table_name;

-> monitor'Un acilmasi tek bir index icin (index.adi yerine istediginiz indexin adini giriniz)

alter index "index.adi" monitoring usage;

-> izlenmesi ((schemaadi yerine sizin schema adini girmelisiniz)

select * from v$object_usage where owner=schemaadi;

->monitor'un kapatilmasi (index.adi yerine istediginiz indexin adini giriniz) 

alter index "" nomonitoring usage;

5 yorum:

  1. If sοmе onе desireѕ expert view regardіng blоgging then i pгopose
    him/heг to pay a ѵisit this website, Kеep up the gοoԁ job.

    Heге is my webpage; payday loans

  2. Fantastіc blog! Dο you have any tіps anԁ
    hints for аsρirіng writerѕ?
    I'm planning to start my own website soon but I'm a littlе lost on
    everythіng. Would уou recommеnd
    staгting with a frеe platform like Wordpress or go for a paid
    option? There are so many choices out thеre
    that I'm totally confused .. Any suggestions? Kudos!

    my weblog ... payday loans

  3. This info is worth everyone's attention. Where can I find out more?

    my web blog: Instant Payday Loans

  4. What's up, its nice piece of writing on the topic of media print, we all be familiar with media is a great source of information.

    Here is my weblog Same Day Payday Loans