Dear Readers, Please check the below articles to get good knowledge on Oracle Production Support Scripts. SNO Article Name Article Link 1 Oracle : Check Partition Summary More than N Days (60 Days) https://www.ktexperts.com/oracle-partition-check-summary-more-than-n-days-60-days/ 2 UNDO segments not Releasing Space https://www.ktexperts.com/undo-segments-not-releasing-space/ 3 Oracle : How… Read More
Dear Readers, This article will see the following Create and configure a virtual cloud network(VCN) by using VCN Wizard. By using this option VCN will create with below-added resources by default Includes: ➸ VCN ➸ Public subnet ➸ Private subnet ➸ Internet gateway (IG) ➸… Read More
Dear Readers, This article will see the following Table Restore Depends On Time in Oracle. We receive requests from the requester stating that they have lost data of some tables and want us to restore it. As it is a time-consuming method to restore the… Read More
Dear Readers, This article will see the following Change DBID in Oracle. NID is the tool that is used to change DBID or database name. Before changing the NID safer side take the backup of the database, and related files dependent on DB.
|
1 2 3 4 5 6 7 8 9 |
[root@detedb1 ~]$ ora_env List of instances oracle : { test1 dbdr11 dbcs16 } Environnement oracle ~~~~~~~~~~~~~~~~~~~~ ORACLE_SID ...... : dbcs16 ORACLE_HOME ..... : /u01/app/oracle/11.2.0.3/db_home TNS_ADMIN ....... : /u01/app/oracle/product/11.2.0.3/db_home/network/tnsadmin NLS_LANG ........ : american_america.AL32UTF8 listener...: LISTENER_DBCS |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 |
[root@detedb1 ~]$ nid TARGET=SYS DBNEWID: Release 11.2.0.3.0 - Production on Thu Feb 4 19:23:28 2019 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Password: Connected to database DBCS16 (DBID=3216085472) Connected to server version 11.2.0 Control Files in database: /u01/app/oracle/11.2.0.3/db_home / dbcs16 /control01.ctl /u01/app/oracle/11.2.0.3/db_home / dbcs16 /control02.ctl Change database ID of database DBCS16? (Y/[N]) => Y Proceeding with operation Changing database ID from 3216085472 to 2519222153 Control File /u01/app/oracle/11.2.0.3/db_home / dbcs16 /control01.ctl - modified Control File /u01/app/oracle/11.2.0.3/db_home / dbcs16 /control02.ctl - modified Datafile File /u01/app/oracle/11.2.0.3/db_home / dbcs16 /system_01.db - dbid changed Datafile File /u01/app/oracle/11.2.0.3/db_home / dbcs16/ sysaux_01.db - dbid changed Datafile File /u01/app/oracle/11.2.0.3/db_home / dbcs16 /undo1_01.db - dbid changed Datafile File /u01/app/oracle/11.2.0.3/db_home / dbcs16 /ttools_01.db - dbid changed Datafile /u01/app/oracle/11.2.0.3/db_home / dbcs16 /sbg_d1_01.db - dbid changed Datafile /u01/app/oracle/11.2.0.3/db_home / dbcs16 /sbg_i1_01.db - dbid changed Datafile /u01/app/oracle/11.2.0.3/db_home / dbcs16 /temp1_01.db - dbid changed Control File /u01/app/oracle/11.2.0.3/db_home / dbcs16 /control01.ctl - dbid changed Control File /u01/app/oracle/11.2.0.3/db_home / dbcs16 /control02.ctl - dbid changed Instance shut down Database ID for database DBCS16 changed to 2519222153. All previous backups and archived redo logs for this database are unusable. Database has been shutdown, open database with RESETLOGS option. Succesfully changed database ID. DBNEWID - Completed succesfully. |
Dear Readers, This article will see the following Create and configure a virtual cloud network(VCN). Sign in to Oracle Cloud Infrastructure Console using your cloud tenant name, user name, and password. From the OCI services menu, click Virtual Cloud Networks under Networking. Choose the appropriate… Read More
Dear Readers, This article will see the following Install SQLT and Query Slowness resolved over SQLT profile method. Installing SQLT SQLT installs under its own schemas SQLTXPLAIN and SQLTXADMIN. It does not install any objects into the application schema(s). You can install this version of SQLT in Oracle databases 10.2, 11.1,… 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
