Dbsguru.com

How to Perform a Health Check of an Oracle Database

WebIn this blog, we’ll be learning about how we can perform Oracle Database health-check. Many times we have seen that we got the request from Application user …

Actived: 2 days ago

URL: https://dbsguru.com/how-to-perform-a-health-check-of-an-oracle-database/

How to Enable & Disable Block Change Tracking (BCT) in

WebIn option 02 where you can create a BCT file in a platform-specific location generally in ORACLE HOME or somewhere in the desire location since it’s a lightweight …

Category: Health Go Health

How to run sql tuning advisor in Oracle

WebWhen you run SQL advisor for the recommendation against any sql_id or Sql_query, It provides the recommendation to tune long-running SQL query. Below are …

Category: Health Go Health

How to Check Temp Tablespace Usage in Oracle

WebHow to Check Temp Tablespace Usage in Oracle. Below is SQL query to find out temporary tablespace utilization of the database. which includes Tablespace name (Temp …

Category: Health Go Health

How to find Database size in Oracle

WebBelow commands to find Database size in Oracle which includes Total DB size, Free size, used size of DB along with DB name & Hostname, etc. SQL command …

Category: Health Go Health

How to Find Current SCN in Oracle

Web2. Using DBMS_FLASHBACK: Find the current SCN in the database using DBMS_FLASHBACK.

Category: Health Go Health

Step by Step How to increase SGA size in Oracle

WebBelow are both options to increase SGA_MAX_SIZE and SGA_TARGET size using pfile & spfile. in our environment, it’s running using pfile. 1:- Check file location …

Category: Health Go Health

How to check ASM diskgroup Size in Oracle

WebSometimes we need to fetch ASM diskgroup utilization of database in Oracle. Below is the SQL query to find ASM diskgroup size in the database which includes Name, Total_GB, …

Category: Health Go Health

Perform Manual Failover & Switchover using repmgr in PostgreSQL

WebStandby Server. Ste p 1. Promoting a Standby server to Primary (Failover): Before promoting Standby to Primary, we will cross-check cluster health with repmgr cluster …

Category: Health Go Health

Important Technical Links Powered by DBsGuru

WebMySql Technical Group: MySql_DBsGuru (Signal) Job Sharing: Tech Jobs DBsGuru (Signal) Contact Us. Please reach us below to share your valuable …

Category: Health Go Health

Fixing OGG-05500 Detected Database Metadata Mismatch …

WebStep 1. Replicat Process Abended in Target: As you will notice Replicat RC232 Status is ABENDED, Check replicat process rpt file to know the cause of …

Category: Health Go Health

Does HIPAA Apply to Law Enforcement

WebPermissible Disclosures to Law Enforcement Examples; As required by law: Compliance with a court order, warrant, or subpoena: For the purpose of identifying or …

Category: Health Go Health

Hong Kong Immigration Requirements: Everything You Need to …

WebQuestion Answer; 1. What are the general requirements for immigration to Hong Kong? Immigrating to Hong Kong requires meeting specific criteria, such as having …

Category: Health Go Health

Is It Legal to Work 70 Hours a Week

WebLegal Question Answer; 1. Can an employer legally require an employee to work 70 hours a week? Yes, employers can require employees to work 70 hours a week …

Category: Health Go Health

SCRIPTS Archives

WebRMAN Incremental Level 1 Differential and Cumulative Database Backup Scripts in Oracle 0 (0) October 7, 2021. RMAN Incremental Level 1 Differential and …

Category: Health Go Health