-
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 » -
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…
Read More » -
How Can I See Hidden Parameters In Oracle Database
Q : How Can I See Hidden Parameters In Oracle Database SELECT a.ksppinm AS parameter ,a.ksppdesc AS description ,b.ksppstvl AS…
Read More » -
How Can I See Invalid Object In Oracle Database
Q : How Can I See Oracle Invalid Object SELECT OWNER ,object_type ,object_name ,STATUS FROM dba_objects WHERE STATUS = 'INVALID'…
Read More » -
ORA-01555:Snapshot too old rollback segment number
ORA-01555: snapshot too old: rollback segment number string with name “string” too small. Cause: Rollback records needed by a reader…
Read More »