metin ergöktaş oracle blog

Oracle data dictionary view leri görmek

Posted in Admin Scriptleri by itmanager on 19 Kasım 2009

Oracle v$ performans  view leri ( dinamik performans view) leri görmek için şu sorguları çalıştırabiliriz.

select kqfvinam name from x$kqfvi order by kqfvinam;
select * from PUBLICSYN where sname like 'V$%' order by 3,1;
select table_name from DICTIONARY where table_name like 'V$%' order by 1

oracle data dictionary view ler için :  http://ss64.com/orad/oracle
 v$ performans view ler için  : http://ss64.com/orav/index.html

Bir Yanıt

Subscribe to comments with RSS.

  1. mayk said, on 24 Kasım 2009 at 1:38 pm

    müdürüm notlar güzel olmuş


Yorum yapın

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Değiştir )

Twitter picture

You are commenting using your Twitter account. Log Out / Değiştir )

Facebook photo

You are commenting using your Facebook account. Log Out / Değiştir )

Connecting to %s

Follow

Get every new post delivered to your Inbox.