Hey Folks, The objective of this blog post is to guide you through out the questionnaire that is being asked now a day from interviewer regrading Postgres Database. Below are some list of Interview questions: Installation: Types of Installations: What are the different methods for installing PostgreSQL?Pre-Requisites: What are the pre-requisites for installing PostgreSQL?Pre-Requisite Verification: … Read more
From Alert logs ORA-1654: unable to extend index SCHEMA.IN021S1 by 128 in tablespace TBS_012024-03-23T16:26:11.156475+05:30ORA-1654: unable to extend index SCHEMA.IN021S1 by 128 in tablespace TBS_012024-03-23T16:26:19.194628+05:30 2. Check the datafiles size and path present in respective tablespace: 4. Give a Log Switch and monitor the Alert Log:
Oracle databases maintain a detailed history of all changes made to the database through archived redo logs, commonly known as archivelogs. These archivelogs are crucial for data recovery and are often managed by database administrators. Monitoring the size of archivelogs is essential to ensure optimal database performance and sufficient storage capacity. Here are some ways … Read more