March, 2019 - alfredokriegdba.com

Collaborate 2019 Presentations

Collaborate 2019 will take place April 7-11 in San Antonio this year.

This time I have 3 presentations accepted and ready to roll starting April 7^th.

Simplifying EBS 12.2 ADOP

In this session I’ll talk about basic ADOP concepts, how to us them and real-life problems and best practice recommendations.

Listen to your Database. How to Understand an Oracle AWR Report.

This session is one of my favorites. In this quick tip I’ll show you the method I use to quickly identify a bottleneck in the DB system using an AWR report.

SMART Performance Monitoring. Exadata and OEM 13c.

I’ll talk about a product that has been set aside by Oracle for a while. Yes, that is OEM 13c.

This session will cover how to monitor Exadata systems using OEM 13c, how to use the plug-in features to find the system’s performance and to alert in case of issues.

Don’t forget to also visit us at our Viscosity booth. I’ll see you there in case you have questions.

Click on the Viscosity logo for all the company events.

Thanks,

Alfredo

Configure Oracle Cloud Infrastructure’s VCN Network

Oracle Cloud Infrastructure requires a VCN (Virtual Cloud Network) to be created in order to connect to DB Systems (Bare Metal and VM). There are basically tow options to configure this VCN.

· Public Subnet with Internet Gateway

· Private Subnet

The Public Subnet with Internet Gateway will expose the network to the Internet. The Internet Gateway is a virtual router that provides a path for traffic between he VCN and the Internet. This option is mainly recommended for non-production workloads.

The Private Subnet cannot be reached from the Internet. You will need to configure a Dynamic routing Gateway (DRG) with either FastConnect or IPSec VPN on your on-premises site.

Once the VCN is created, you can associate the Bare Metal or the VM system to it. The navigation menu to create the VCN is Menu -> Networking -> Virtual Cloud Networks

Then click on Create Virtual Cloud Network and follow the wizard.

Once you create your VCN it will show as a (green) available icon.

More configuration information below:

https://docs.cloud.oracle.com/iaas/Content/Database/Tasks/network.htm

Thanks,

Alfredo

Avoid Transaction Errors Due To Tablespace Shortage

How many times we have had a call from application teams regarding a session error due to a tablespace (either DATA, TEMP or UNDO) getting 100% full?

How many times we had ask for an estimate of space used by a process, session or transaction?

There are several options that can help us overcome this type of issues.

a) If you are using Oracle Enterprise Manager (if you don’t, you should), make use of Corrective Actions to manage your data tablespaces.

http://www.alfredokriegdba.com/2017/01/oem-13c-new-features-corrective-actions.html

b) If your issue is more with tablespace quotas, TEMP or UNDO you may want to enable RESUMABLE session

RESUMABLE is an option which allows the session to go into a suspended state in such a way that it won’t fail/abort. The session cannot wait forever though, this is controlled by RESUMABLE_TIMEOUT initialization parameter.

In order to enable this option at the session level you have to execute below SQL statement:

SQL> ALTER SESSION ENABLE RESUMABLE;

Alertlog file will record if the session entered into suspended mode.

Some examples are:

###########
statement in resumable session ‘User TEST1(32), Session 3, Instance 2’ was
suspended due to
ORA-01536: space quota exceeded for tablespace ‘USERS’

###########
statement in resumable session ‘User TEST1(32), Session 15, Instance 1’ was
suspended due to
ORA-01562: failed to extend rollback segment number 4

###########
statement in resumable session ‘User TEST1(32), Session 23, Instance 1’ was
suspended due to
ORA-01652: unable to extend temp segment by 32 in tablespace TEMP

###########
statement in resumable session ‘User TEST1(54), Session 2, Instance 1’ was
suspended due to
ORA-01653: unable to extend table TEST1.TEST_RESUMABLE by 256 in tablespace USERS

While the session is into this suspended state it will account time to the “statement suspended, wait error to be cleared” wait event.

Once the error that sent the session to the suspended state is fixed, the session will resume its work.

More details on below Oracle’s documentation:

https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema002.htm#ADMIN11581

Thanks,

Alfredo