-
Oracle Database
ORA-39070: Unable to open the log file
Değerli Dostlar, Bugün Oracle Database üzerinde aldığımız ORA-39070 hatasının sebeplerini ve nasıl çözeceğimizi dair bilgileri size ulaştıracağız. Hata EXPDP ile…
Read More » -
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…
Read More » -
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…
Read More » -
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…
Read More » -
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…
Read More » -
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…
Read More » -
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…
Read More » -
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…
Read More » -
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…
Read More » -
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",…
Read More »