Dear Readers, In this article, we will see the following How to Create VPC Using Cloud Formation. Steps to Follow : Logging to AWS Account Create Stack for creating VPC Very VPC Graphically 1. Logging to AWS Account First, we need to AWS Console… Read More
Dear Readers, In this article, we will see the following Install PostgreSQL 12 On RHEL 8 . Steps to Follow : Logging to AWS Account Launch MySQL Server Connect to Linux EC2 Instance by Using Putty Switch to root user Install Server Updates Install wget… Read More
Hi Dears, In this article, we will see Installation of AWS CLI and S3FS We can use multiple AWS services by using AWSCLI. It’s a command line interface which can manage S3 to copy, list, move files from local filesystem to Bucket as one of… Read More
Hi Dears, In this article, we will see Important Oracle v$parameters (SecureCRT) Tab Name : v$parameter Button Name : SGA
|
1 2 3 4 5 |
col name for a50 set linesize 300 col value for a40 select name,value from v$parameter where name like '%sga%'; select &sga/1024/1024/1024 GB from dual; |
Output :
|
1 2 3 4 5 6 7 8 |
NAME VALUE -------------------------------------------------- ---------------------------------------- sga_max_size 4294967296 pre_page_sga TRUE lock_sga FALSE allow_group_access_to_sga FALSE sga_target 4294967296 unified_audit_sga_queue_size 1048576 |
|
1 2 3 4 5 6 |
select &sga/1024/1024/1024 GB from dual; Enter value for sga: 4294967296 GB ---------- 4 |
Button Name : SGA_TARGET
|
1 2 3 4 5 |
col name for a50 set linesize 300 col value for a40 select name,value from v$parameter where name like '%sga_target%'; select &sga_target/1024/1024/1024 GB from dual; |
Output :
|
1 2 3 4 5 6 7 8 9 10 |
NAME VALUE -------------------------------------------------- ---------------------------------------- sga_target 4294967296 select &sga_target/1024/1024/1024 GB from dual; Enter value for sga_target: 4294967296 GB ---------- 4 |
Button Name : PGA_Aggregate_target
|
1 2 3 4 5 |
SQL> col name for a50 SQL> set linesize 300 SQL> col value for a40 select name,value from v$parameter where name like '%pga_aggregate_target%'; select &pga_aggregate_target/1024/1024/1024 GB from dual; |
Output :
|
1 2 3 4 5 |
SQL> select &pga_aggregate_target/1024/1024/1024 GB from dual; NAME VALUE -------------------------------------------------- ---------------------------------------- pga_aggregate_target 2147483648 |
|
1 2 3 4 5 |
SQL> Enter value for pga_aggregate_target: 2147483648 GB ---------- 2 |
Button Name :… Read More
Hi Dears, In this article, we will see How to Switch/Recreate Undo Tablespace at PDB Level(12cR2) In Oracle Database 12c Release 1 all containers in an instance shared the same undo tablespace. In Oracle 12c Release 2 each container in an instance can use its… Read More
Hi Dears, In this article, we will see Manage SQL Profile in Oracle Database A SQL profile is a collection of auxiliary statistics on a query, including all tables and columns referenced in the query. The profile is stored in the data dictionary. The optimizer… Read More
Hi Dears, In this article, we will see Resource Manager in Oracle Resource Manager is an enterprise edition feature which will restrict sessions consuming high resources. We can assign shares to sessions depends on priority of session. We can restrict degree of parallelism for group… Read More
Hi Dears, In this article, we will see Oracle Sample Unix script to monitor select query during Load Test
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
#!/bin/bash ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/dbhome_1 ORACLE_SID=ORCL while : do sqlplus -s / as sysdba <<EOF set pagesize 0 set linesize 300 select B.USERNAME ||' ('||B.SID||','||B.SERIAL#||',@'||B.INST_ID||') is Currently '||B.STATUS||' for last '||B.LAST_CALL_ET||' Sec and it''s BLOCKING user '|| W.USERNAME|| ' ('| |W.SID||','||W.SERIAL#||',@'||W.INST_ID||')' from (select INST_ID,SID,SERIAL#,USERNAME,STATUS,BLOCKING_INSTANCE,BLOCKING_SESSION, LAST_CALL_ET from gv\$session where BLOCKING_SESSION >0) W, (select INST_ID,SID,SERIAL#,USERNAME,STATUS,LAST_CALL_ET from gv\$session ) B where W.BLOCKING_INSTANCE=B.INST_ID and W.BLOCKING_SESSION=B.SID; EOF date echo "Hit [CTRL+C] to stop!" sleep 5 done |
Output :
|
1 2 3 4 5 6 7 8 9 |
Wed Mar 24 11:54:39 PDT 2021 Hit [CTRL+C] to stop! no rows selected Wed Mar 24 11:54:44 PDT 2021 Hit [CTRL+C] to stop! no rows selected |
Thank you for giving your valuable time to read the above information. Please click here to subscribe for further updates KTEXPERTS is always… Read More
Hi Dears, In this article, we will see Configure Active DataGuard and DG BROKER. Oracle Active Data Guard allows DBAs and users to run real-time queries on a physical standby system for reporting. Queries and reports can be offloaded from the production system to… Read More
Hi Dears, In this article, we will see Difference between ROWID and ROWID BATCHED in Oracle. TABLE ACCESS BY INDEX ROWID BATCHED is new execution plan operation introduced in oracle 12c to improve performace by make efficient and minimal read writes to the disk. It… Read More
