Rotate any logs with logrotated.services
…
Read MoreHow to install POSTGRESQL and PGADMIN on linux 7 (REDHAT,CENTOS,ORACLE LINUX)
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 compatibility using below link https://www.enterprisedb.com/resources/platform-compatibility…
Read Morewhat is psudocolumn, Rowdepandancy and Norowdepandency in oracle
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…
Read MoreAll Redo log group Members are in active state, ORA-20 max number of processes exceeded, Database went hung state After restart
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…
Read MoreOracle Blob and Clob Datatypes
CLOB and BLOB are two types of data types used in databases to store large amounts of data. BLOB: BLOB, or Binary Large Object, is used to store binary data such as images, audio, video, and other multimedia objects. It is an extension of the VARBINARY data type and can store up to 2GB of data.Using CLOB and BLOB data types can be beneficial in many situations. CLOB:CLOB, or Character Large Object, is used to store textual data and is used for large strings of text. It is an extension of the VARCHAR data type and can store up to 4GB of data if you have a large document or image you need to store, you can use a CLOB or BLOB data type to store it.storage space is occupied more in the database, so you should be careful about when and how you use them. To query for CLOB or BLOB datatypes,…
Read Morewhat are the oracle index status
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. Indexes are created on columns and contain entries that point to the data in the table. An index can be unique or non–unique and can be created on one or more columns. some of status are below. 1.Unusable 2.N/A 3.Valid 4.Invalid 1.UNUSABLEAn Oracle index can become unusable if the underlying table has been modified or dropped, or if the index has been corrupted. To fix this, you need to re–create the index.The data is not in the order specified by the SORTED INDEXES clause ALTER INDEX [schema.]indexname REBUILD ONLINE;…
Read MoreLoading and unloading java Jar in to database
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 username/password@servicename -schema schmeaname jar Jar…
Read MoreFind the session which generates more archive log
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 v$statname n on n.statistic# = s.statistic# join v$session sn on sn.sid = s.sid where n.name…
Read MoreQuery to find how many chained (and migrated) rows each table has
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
Read MoreError: resource-env-ref,CDI Container and disable policy
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 JNDI name using the resource-env-description element of the…
Read More