Dear Readers, In this article, we will see the following Installation of SQL Server On AWS Cloud. This provides a step by step procedure for installing a new instance of SQL server 2014 by using the SQL server setup installation wizard. Now I will show… Read More
Hello Everyone, In this article , we will learn how to Attach and de-attach the expdp/impdp datapump jobs. EXPDP and IMPDP is used to take the logical backup of full database, tablespace ,schema,table and query level. we can attach or deattach the datapump jobs using… Read More
Dear Readers, In this article, we will see the SQL Joins. Joins A join is a query that combines rows from two or more tables Join Conditions Most join queries contain WHERE clause conditions that compare two columns, each from a different table. Such a… Read More
Dear Readers, In this article, we will see the following Introduction to SQL Server. DBMS: Human needs have increased tremendously. Now people are doing much more composite tasks than ever before. Society has become very complex if a person has to work in a huge… Read More
Dear Readers, In this article, we will see the following Important ASM Commands. Tab Name : asm_free
|
1 2 |
set linesize 300 col name for a30 |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
select NAME, ALLOCATION_UNIT_SIZE, STATE, TYPE, TOTAL_MB, FREE_MB,(FREE_MB/TOTAL_MB)*100 PCt_FREE from v$asm_diskgroup order by PCt_FREE ; NAME ALLOCATION_UNIT_SIZE STATE TYPE TOTAL_MB FREE_MB PCT_FREE ------------------------------ -------------------- ----------- ------ ---------- ---------- ---------- REDO01 4194304 CONNECTED HIGH 3051520 2657044 87.0728031 DATA01 4194304 CONNECTED NORMAL 21368320 18917476 88.5304788 RECO01 4194304 CONNECTED NORMAL 9154560 8677040 94.7838017 select NAME, ALLOCATION_UNIT_SIZE, STATE, TYPE, TOTAL_MB/1024 TOTAL_GB ,FREE_MB/1024 FREE_GB,(FREE_MB/TOTAL_MB)*100 PCt_FREE from v$asm_diskgroup order by PCt_FREE ; SQL> NAME ALLOCATION_UNIT_SIZE STATE TYPE TOTAL_GB FREE_GB PCT_FREE ------------------------------ -------------------- ----------- ------ ---------- ---------- ---------- REDO01 4194304 CONNECTED HIGH 2980 2594.76953 87.0728031 DATA01 4194304 CONNECTED NORMAL 20867.5 18474.0977 88.5304788 RECO01 4194304 CONNECTED NORMAL 8940 8473.67188 94.7838017 |
Tab Name : ASMCMD>find file find +DATA01 undo* Tab Name : WhatInstances
|
1 2 3 4 |
set linesize 300 col instance_name for a15 col SOFTWARE_VERSION for a15 col COMPATIBLE_VERSION for a15 |
|
1 2 3 4 5 6 7 |
SELECT * FROM V$ASM_CLIENT; GROUP_NUMBER INSTANCE_NAME DB_NAME CLUSTER_NAME STATUS SOFTWARE_VERSIO COMPATIBLE_VERS CON_ID ------------ --------------- -------- ------------------------------- ------------ --------------- --------------- ---------- 3 +ASM1 ORCL1234 server1234-c CONNECTED 18.0.0.0.0 18.0.0.0.0 0 2 +ASM1 ORCL1234 server1234-c CONNECTED 18.0.0.0.0 18.0.0.0.0 0 1 +ASM1 ORCL1234 server1234-c CONNECTED 18.0.0.0.0 18.0.0.0.0 0 |
Tab Name : Rebalance_status
|
1 2 |
set linesize 300 select * from gv$asm_operation; |
Tab Name : ASM_Candidate
|
1 2 3 4 5 6 7 |
BREAK ON report ON disk_group_name SKIP 1 set pagesize 50 set linesize 300 col DISK_GROUP_NAME for a20 col DISK_FILE_PATH for a50 col DISK_FILE_FAIL_GROUP for a40 col DISK_FILE_NAME for a25 |
|
1 2 3 4 5 6 7 8 9 |
SELECT NVL(a.name, '[CANDIDATE]') disk_group_name , b.path disk_file_path , b.name disk_file_name , b.failgroup disk_file_fail_group FROM v$asm_diskgroup a RIGHT OUTER JOIN v$asm_disk b USING (group_number) ORDER BY a.name; |
Tab… Read More
Dear Readers, In this article, we will see the following Oracle : Redolog Files. Redo log Files are Recovery options whenever Database crashes or Down. LGWR will take care of redo content that needs to be written to redolog files, Based on SCN a record… Read More
Dear Readers, In this article, we will see the following Daily Tips for .NET. Tip-1 : Date: 21-Dec-20 Provided By (Linkedin): Deepthi 👉 Use yield in C# instead of temporary collections. Tip-2 : … Read More
Dear Readers, In this article, we will see the following Installation of MySQL 8.0.21 On RHEL Using Generic Binaries in AWS Cloud . Steps to Follow : Logging to AWS Account Launch MySQL EC2 Instance Connect to Linux EC2 Instance by Using Putty Switch to… Read More
Dear Readers, In this article, we will see the following Installation of Oracle Database 19c On Windows. Step-1: 👉 Download the Oracle Database Software Download the Oracle Database 19c software (Windows Version) by the below link. https://www.oracle.com/database/technologies/oracle-database-software-downloads.html#19c Oracle software will be downloaded in zip format … Read More
Dear Readers, In this article, we will see the following MySQL Upgrade from 5.6 to 5.7 to 8.0 1. Logging to AWS Account First, we need to AWS Console page by using below link. https://aws.amazon.com/console/ Click on sign in to Console button. Logging to aws… Read More
