OracleNotes

Blog

  • #OTNYathra 2016 – A Diary

    OTNYathraYathra simply means travel or journey. OTNYathra did cover many miles! OTNYathra is my first conference tour, organized by Oracle Technology Network. First and foremost, I would like to thank AIOUG and OTN for having me as a speaker, Oracle ACE Program for taking care of my travel and accommodation, and OneNeck IT Solutions for all the support.

    The Chennai event was on April 23rd. I reached Chennai on the morning of the 22nd and hence had time to visit Chennai before the conference. Thanks to AIOUG team – Sai and Hari – for taking us to Mamallapuram and showing us around. Had a good time visiting the historic sculptures and temples. The first day’s lunch was superb, and pretty much every day the food was great and I put on a few pounds in a week 🙁

    The conference venues were carefully picked. The Chennai event was at the prestigious Loyola-ICAM College of Engineering and Technology (LICET) campus. The volunteers of Chennai AIOUG chapter came early and set everything up and were ready. Kudos to all volunteers, I learned that the Chennai chapter is a very active chapter with regularly organized meetings and conferences. Good job; I am sure Chennai Chapter will produce many Oracle ACEs in the near future.

    My two presentations were well received by the Chennai crowd. By the way, Chennai had the largest crowd and the organizers stopped accepting more participants as all seats were sold out. It was a bit tiring to travel to Bengaluru after the Chennai conference and then be ready for Bengaluru conference on Sunday 9 A.M.

    The Bengaluru event was at the Symbiosis Institute of Business Management in Electronics City. The main event hall was like a theater. Thanks to all the AIOUG Bengaluru chapter volunteers. After the conference, I took some personal time and visited my sister in Marathahalli.

    Monday, April 25th was a day of relaxation and travel. The flight was on time, and we reached Hyderabad by 2 P.M.  We started off our Hyderabad visit by having the famous Hyderabad Biriyani for lunch. The drive to the hotel in HiTec city was quick.  The Hyderabad airport, highway to HitTec city and the hotel were in a different world, totally different world from the normal Hyderabad.  I visited the Golgonda fort and Charminar with the team. It was a great evening.

    The Hyderabad event was at the Tech Mahindra Danube Auditorium. It is an excellent high tech facility with big screen projection. I met many friends whom I know only through social media or email. It was very nice of Saurabh Gupta to autograph and present a copy of his most recent book to me. Thank you Satya for taking us shopping and for the delicious dinner.

    April 27th was pretty much spent waiting in the airport! The flight was 3+ hours delayed, but I had the opportunity to travel with the Pune IPL team lead by M. S. Dhoni! My sister gave me a surprise by coming to receive me at the airport.

    The Pune event was at the Oracle Financial Services Software office. The office is on top of a beautiful hill. We saw a lot of very enthusiastic attendees in Pune. It was kind of sad to leave the OTNYathra without completing the next two cities – Mumbai and Gurgaon, but I had to honor prior commitment and be in Dallas on April 30th evening.

    It was a great honor meeting many seasoned speakers, including Chetan Vithlani, Nassyam Basha, Veeratteshwaran Sridhar, Saurabh Gupta, Prabhaker Gongloor, and Satyendra Kumar. I enjoyed the opportunity to connect with the attendees and speakers in all four cities.

    I enjoyed the company of Oracle experts and my fellow speakers Connor McDonald and Riyaj Shamsudeen. I’m grateful to the AIOUG organizers Sai, Hariharaputhran and Veeratteshwaran for taking care of all aspects of the Yathra- from airport pickup, taxis, food, site seeing, conference schedule, pretty much all logistics of the conference from the day I landed in Chennai. OTNYathra was an excellent experience! A great technical journey…

    Once again, many thanks to AIOUG, Oracle ACE Program, Oracle Technology Network and OneNeck IT Solutions… and thanks to all my session attendees – you are awesome!

  • Oracle Daily Tidbits – April 2016

    “Oracle *daily* TidBits” (#oratidbit) published at https://www.facebook.com/oraclenotes on weekdays in April 2016. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well… Hope you find these helpful to learn something new or to remind you of its existence and use…

    TidBit
    #oratidbit ORACLE_OCM is a predefined non-administrative account in DB that is expired and locked, used by Oracle Configuration Manager (OCM) used to associate the configuration information for the Oracle Database instance with My Oracle Support. When you log a service request, information is readily available and associated to the Service Request.
    #oratidbit SQL92_SECURITY parameter specifies whether users must be granted the SELECT object privilege to execute UPDATE or DELETE statements. Default is FALSE and you do not require SELECT to perform UPDATE or DELETE on table. So, by using DELETE/UPDATE statements with different WHERE clauses you may be able to verify the content of table.
    #oratidbit Oracle Virtual Private Database (VPD), Oracle Label Security (OLS), and Oracle Data Redaction enable you to restrict the data that different users can see in database tables. #security
    #oratidbit Use DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL procedure to clean audit records from unified audit trail (UNIFIED_AUDIT_TRAIL) and standard audit trail (DBA_AUDIT_TRAIL).
    #oratidbit 101: ALL_ALL_TABLES shows tables (relational and object) that you have access to, USER_ALL_TABLES shows tables you own, DBA_ALL_TABLES shows tables in the database or PDB, CDB_ALL_TABLES shows tables from all PDB.
    #oratidbit 101: On non-CDB, CDB_ and DBA_ views have same content. The CDB_ view has CON_ID=0 for all rows.
    #oratidbit To enable full database caching in 12c, do ALTER DATABASE FORCE FULL DATABASE CACHING in MOUNT state of DB. Enabling force full database cache mode applies to the CDB and all PDBs when using the multitenant option.
    #oratidbit In 12.1.0.1, job_queue_process was a Container Database (CDB) modifiable parameter (ie. at a global level). In 12.1.0.2, the job_queue_process parameter is not CDB modifiable; instead it’s PDB modifiable which means each PDB can have its own job_queue_process value.
    #oratidbit Oracle Scheduler in 12c has different interpreters to run custom jobs. SQL Script uses sqlplus, External script uses unix shell or windows command, Backup script uses RMAN.
    #oratidbit In 12c, DBMS_STATS.REPORT_STATS_OPERATIONS API can be used to find if automated statistics job or manual statistics collected stats on a table. Filter automatic stats operation by using AUTO_ONLY => TRUE.
    #oratidbit To preserve the in-memory column store configuration during import, use TRANSFORM=INMEMORY:Y option in impdp. When the TRANSFORM=INMEMORY:n option is specified, Data Pump drops the IM column store clause from all objects that have one.
    #oratidbit You can use full transportable export/import to upgrade a database from an Oracle Database 11g Release 2 (11.2.0.3) or later to Oracle Database 12c.
    #oratidbit In a CDB, the default Data Pump directory object, DATA_PUMP_DIR, does not work with PDBs. You must define an explicit directory object within the PDB that you are using with Data Pump export/import.
    #oratidbit 101: Oracle Container Database CDB includes CDB$ROOT (Oracle-supplied metadata and common users), PDB$SEED (template to create new PDBs) and Pluggable Databases.
    #oratidbit The Oracle Pluggable Database Self-Service Provisioning application provides an interface to Oracle Database 12c Multitenant and allows for the self-service provisioning of Pluggable Databases (PDBs). Available from 12.1.0.2.
    #oratidbit Oracle PDB Self-service provisioning application requires AL32UTF8 database characterset, Oracle APEX 4.2.5+ and REST Data Services 2.0.7+.
    #oratidbit 101: A CDB uses single SPFILE. The user who creates or modifies the SPFILE must be a common user with SYSDBA, SYSOPER, or SYSBACKUP administrative privilege.
    #oratidbit 101: All of the PDBs in the CDB must use the characterset of the CDB.
    #oratidbit 101: There is separate SYSTEM and SYSAUX tablespaces for CDB root (CDB$ROOT) and each PDB.