Logrotate  logrotate is a utility for managing […]

  INTRODUCTION:  This doc will guide you through the process of installing Postgresql14, Pgadmin4 and also Creating users, databases, schemas VERSION: PostgreSQL14 PGAdmin-4 Verify Platform [...]

what is psudocolumn, Rowdepandancy and Norowdepandency in oracle   A pseudocolumn behaves like a table column, but is not actually stored in the table. You can select from pseudocolumns, but you [...]

All Redo log group Members are in active state, ORA-20 max number of processes exceeded, Database went hung state After restart  A) All Redo log group Members all are in active state   If the [...]

CLOB and BLOB are two types of data types used in databases to store large amounts of data. [...]

Oracle index is a database object that is used to improve the performance of certain queries by providing direct access to the data in a table.  [...]

1.For Loading jar use cmd loadjava -force -genmissing -r -user username/password@servicename -verbose jar     2.For droping jar use cmd   dropjava -f -verbose -u [...]

Query:   select s.sid,sn.SERIAL#,n.name, round(value/1024/1024,2) redo_mb, sn.username,sn.status,substr (sn.code1,1,21) “code”, sn.type, sn.module,sn.sql_id from v$sesstat s join [...]

Query: SELECT owner, table_name, chain_cnt FROM dba_tables WHERE chain_cnt > 0; SELECT owner_name,table_name,count(head_rowid) row_countFROM chained_rows GROUP BY owner_name,table_name

org.apache.cxf.jaxws.context.WebServiceContextResourceResolver/bus’ declared in the standard descriptor or annotation has no JNDI name mapped to it. The resource-env-ref must be mapped to a [...]