-
Oracle Scripts
Most used or executed SQL Queries ( Last 20 )
Q: How can i see most used or executed SQL Queries ? SELECT * FROM ( SELECT ss.sql_text, a.SQL_ID, SUM…
Devamını Oku » -
Oracle Database kullanıcı erişim denetimleri
Oracle Database’e erişen kullanıcıların yada erişirken hata alan kullanıcıları nasıl görebilirim ? SELECT username AS "DB KULLANICI", os_username AS "OS…
Devamını Oku » -
Who are using Temp Tablespace in Oracle Database
Q : Who are using Temp Tablespace in Oracle Database SELECT b.tablespace, ROUND ( ( (b.blocks * p.VALUE) / 1024…
Devamını Oku » -
How can i see Block Session in Oracle Database
Q : How can i see Block Session in Oracle Database SELECT H.SAMPLE_TIME AS "TARIH", H.INSTANCE_NUMBER AS "SUNUCU", U.USERNAME AS…
Devamını Oku » -
How can i see Invalid Object in Oracle Database
Q : How can i see Invalid Object in Oracle Database SELECT OWNER ,object_type ,object_name ,STATUS FROM dba_objects WHERE STATUS…
Devamını Oku » -
How can i see running job in Oracle Database
Q: How can i see running job in Oracle Database SELECT JOB_NAME, comments, job_Action, last_start_date, last_run_duration, state FROM dba_scheduler_jobs WHERE…
Devamını Oku » -
How can I empty the trash in Oracle Database
Question : How can I empty the trash in Database To remove the entire contents of your recycle bin, issue…
Devamını Oku » -
ORA-01665: control file is not a standby control file
Today , After restoring standby database from RMAN backup, got below error 🙁 What is Solution ? Firstly , I…
Devamını Oku » -
How Can I See Error In Oracle Database
Q : How Can I See Error In Oracle Database SELECT ORIGINATING_TIMESTAMP AS "DATE", MESSAGE_TEXT AS "TEXT", MESSAGE_LEVEL AS "LEVEL",…
Devamını Oku » -
How Can I See Active Session In Oracle Database
Q : How Can I See Active Session In Oracle Database SELECT NVL(s.username, '(oracle)') AS username ,s.osuser ,s.sid ,s.serial# ,p.spid…
Devamını Oku »