SANGAM, India's Largest Oracle Users Group Conference

SANGAM18, India's Largest Oracle Users Group Conference

About Sangam (www.sangam18.info)

"Sangam, India's the largest independent Oracle user's group conference organized by All India Oracle Users Group (AIOUG). Every year Sangam is hosting 100+ in-depth technical sessions on new cutting-edge Oracle Technologies. SANGAM is a prestigious event that provides in-depth Technical Session, Live Demos, Hands on Labs, Technology Booths, Expert Talks, Fire Chats with Technology Gurus and many more.

In Sangam, Technology Experts and Gurus are sharing their knowledge and experience in person with participants. Over 1000+ participation every year which includes Database admin, Developers, Architects, Solution Designers, Technology Directors, Business Analysts, Delivery Heads etc."

I am very much thankful to @AIOUG @SaiPenumuru has given me a chance to speak in SANGAM18.

                                                           My Session Details 
 

Sangam18 session highlights from Key Speakers which gives tremendous knowledge, I would like to attend almost all sessions if possible.

Thanks to AIOUG for great efforts and bringing Oracle Experts and Gurus under one roof. 

Sangam18 Session Highlights from Key Speakers,
•    Threats to Your Data are Bigger Than They Appear by Vipin Samar
•    What to Expect from Oracle Autonomous Database by Penny Avril
•    Oracle Database: What's New and Coming Next by Penny Avril
•    DBAs versus Autonomous Databases by Julian Dontcheff
•    Hyperscale Oracle Database: Extreme Scaling without the Compromises by Tirthankar Lahiri
•    Oracle Database In-Memory [Bring Your Own Laptop] by Tirthankar Lahiri
•    Oracle Database In-Memory: When to Use and Getting Started by Tirthankar Lahiri
•    Database In-Memory: Under the Hood and What's Coming by Tirthankar Lahiri
•    The Database Strikes Back: Return of the SQL Jedi by Connor McDonald
•    Taming the beast. The 12c Optimizer by Connor McDonald
•    Building great apps with great SQL by Connor McDonald
•    Oracle Autonomous Health Framework to Preserve Performance and Rapidly Recover by Sandesh Rao
•    Applied Machine Learning for Database Autonomous Health by Sandesh Rao
•    Introducing new AIOps Innovations in Oracle 19c Autonomous Health Framework by Sandesh Rao
•    Oracle Exadata: Strategy and Roadmap for New Technologies, Cloud, and On-Premises by Gurmeet Goindi
•    Oracle Database In-Memory on Exadata: A Potent Combination by Gurmeet Goindi
•    Should I Drop Indexes in Exadata Cloud by Arup Nanda
•    Database Security in a Single Day in the Cloud by Arup Nanda
•    How Oracle Buffer Cache Works in Cloud by Arup Nanda
•    Cloud Applications – Back to Basics by Debra Lilley
•    Should I move to Cloud SaaS Applications? by Debra Lilley
•    Extensions in Oracle Applications Cloud (ERP & HCM) _ what can you do? by Debra Lilley
•    18(ish) Things You'll Love about Oracle Database 18c by Chris Saxon
•    An Open Chat with AskTom Team by Connor McDonald • Chris Saxon
•    Why Isn't My Query Using an Index? An Introduction to SQL Performance by Chris Saxon
•    How to Hack Your App Using SQL Injection by Chris Saxon
•    Oracle Real Application Clusters Roadmap for New Features by Markus Michalewicz
•    Oracle MAA (Maximum Availability Architecture) by Markus Michalewicz
•    (Oracle) DBA Skills to Have, to Obtain and to Nurture by Markus Michalewicz
•    Developing Applications on the World's Fastest Database by Douglas Hood
•    TimesTen Scaleout [Bring Your Own Laptop] by Douglas Hood
•    Using the World's Fastest Database in the Cloud by Douglas Hood
•    Database Driven Machine Learning by Douglas Hood
•    Turbocharge Analytical and OLTP workloads with Oracle Database In-Memory 18c [Bring Your Own Laptop] by Gavin Soorma
•    Upgrade and Migrate to Oracle Database 18c best practices for minimizing downtime by Gavin Soorma
•    SQL Tuning - Tools, Tips & Techniques by Vivek Sharma
•    Oracle Database Backups On Clouds- An Overview by Aman Sharma
•    Using Machine Learning to secure your company assets against modern cyber-attacks by Chetankumar Vithlani
 
Do you need more sessions, I think, you should visit Agenda, 
See here, https://sangam18.sched.com/

Let's joins us,

Date:- 7^th & 8^th December 2018

Venue:-

The Oterra,

Bengaluru

SANGAM18 at Glance

http://www.aioug.org/Sangam18-At-A-Glance.pdf

About SANGAM18

www.sangam18.info

Registration Link

www.sangam18.info   => Registration

Thanks & Regards,

Chandan Tanwani

Oracle Performance Tuning Certified Expert

Set Autotrace Traceonly giving error SP2-0618 and SP2-0611 in Oracle 18c

Set Autotrace Traceonly giving error SP2-0618 and SP2-0611 in Oracle 18c

I was trying few things in Oracle 18c database using command window and needed autotrace enable for the same.

When i had given command "set autotrace traceonly" it has thrown error as below,

SP2-0618: Cannot find the Session Identifier.  Check PLUSTRACE role is enabled

SP2-0611: Error enabling STATISTICS report

It seems something wired here.

Few steps need to follow to work autotrace in sqlplus.

1.       cd $oracle_home/rdbms/admin

2.       log into sqlplus as sys or system

3.       run SQL> @utlxplan

4.       run SQL> create public synonym plan_table for plan_table

5.       run SQL> grant all on plan_table to public

6.       exit sqlplus and cd $oracle_home/sqlplus/admin

7.       log into sqlplus as SYS

8.       run SQL> @plustrce

9.       run SQL> grant plustrace to public

Let's follow another steps.

$ cd $ORACLE_HOME/sqlplus/admin/
$ sqlplus / as sysdba

SQL*Plus: Release 18.0.0.0.0 - Production on Wed Oct 17 12:40:27 2018
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle.  All rights reserved.
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0

SQL> alter session set container=testpdb1;
Session altered.

SQL> @plustrce
SQL>
SQL> drop role plustrace;
drop role plustrace
          *
ERROR at line 1:
ORA-01919: role 'PLUSTRACE' does not exist

SQL> create role plustrace;
Role created.

SQL>
SQL> grant select on v_$sesstat to plustrace;
Grant succeeded.

SQL> grant select on v_$statname to plustrace;
Grant succeeded.

SQL> grant select on v_$mystat to plustrace;
Grant succeeded.

SQL> grant plustrace to dba with admin option;
Grant succeeded.

SQL>
SQL> set echo off
SQL>
SQL> grant plustrace to public;
Grant succeeded.

After following all above steps, now we are good with autotrace traceonly.

SQL> conn hr/hr@testpdb1
Connected.
SQL>
SQL> set autotrace traceonly
SQL>

Thanks & Regards,

Chandan Tanwani

Oracle Performance Tuning Certified Expert