Oracle 23c New Features for DBA'sAPACOUC Webinar 2018 - Wave 2 Sessions In next 2.5 hrs , @apacouc @fcomunoz @DataIntensity , I am presenting SQL Plan Stability & Flexibility Features
Register for free
https://events.genndi.com/register/818182175026319207/528ad96d7a
|
|||||||||||||||||||||||||||||||||||||
|
Hi Join in to my free webinar for APACOUC.org webinar tour tomorrow i.e 27th July and I am presenting 18c New Features for DBA's. Timing: July 27th - 12.30PM (IST) , 17.00PM (AEST) Registration link : https://events.genndi.com/register/818182175026319207/2e96be318e And also next wave of presentations announced, please check here. http://www.apacouc.org/2017-webinar-tour.html See you all there. -Suresh Hello We have official docker files available to build the Oracle 18c Database in docker. Please go to this link. https://github.com/oracle/docker-images/tree/master/OracleDatabase/SingleInstance/dockerfiles To build this
Build the image process Open command prompt
Here the oracle/database:18.3.0-ee is image name and
You can see the steps involved in the window (click on image for best viewing) Finally, you will get this
Let's check the docker image built listed
Run the docker and start the database
As you see, 18.3.0-ee image built now get into the container and check database
The Oracle 18c database is up and running and you can build as many as containers you want. -Thanks Suresh Oracle 18c database Officially released for on premise customers. Not sure why 18.3 🙂
Hello All, Few years back, I have been asked to deliver a dashboard which provide audit information of databases. We don't have OEM or any other tools and that time we migrated to Cloud with standard edition only and we do not have control of database, except enable audit and review on our own. Secondly I want to have a simple application without much hassle. So I choose Apex for rapid development of interface and some queries , that's it all done and application is ready. The application will need this, download application file f014
That's it, here are the snippets and here is the application file, Below I show how to import that application too Select the database link and table you want to, I choosed dba_common_audit_trail since if you have XML/DB/OS set for audit trail this view get populated. The home screen contains the day wise audit records and the graphs Download Application file from f104 and import in your application builder
When you click on day wise record it navigates to Audit Summary Reports Where in Audit summary report you can see multi dimensional summary by OWNER, OS HOST, RETURN CODE, OBJECT, if you click on any record type you take to next screen
In this following screen you see each record of that record type with day wise, you can apply lot of filters as well.
Lastly, you can create database links from Application itself
Finally, you can see the alerts like Login Fail Attempts and Invalid Passwords attempts.
If you are interested and having difficulties in deploying this application, shoot me an email will assist you. -Thanks Suresh
Follow this link for Oracle Hands on Lab to practice certain tasks like upgrades and patching etc which is quicker and nicer. http://www.oracle.com/technetwork/community/developer-vm/vts-hol-2415742.html The lab instructions contains the following activities : Source Oracle
Thanks Suresh
Starting 18c, UTL_FILE_DIR Parameter is no longer supported and errors out if called. Instead we have to directly call the file object using utl_file. This is due to increase the security of the database, since UTL_FILE will use the DIRECTORY object as location where in the UTL_FILE_DIR is the direct path to the OS directory where you have no control on privilege. This has been notified in 12c release that UTL_FILE_DIR will be removed and 18c is not going to support. What it has for you?
Ref: Oracle 18c New Features. -Thanks Suresh
The 2018 APAC Webinar Tour will be running from July 16 until September 7th with the participation of over 20 International Speakers that will be presenting over 50 interesting presentations, making it the largest webinar series ever made in the Oracle world! The registrations are open now. [embedyt] https://www.youtube.com/watch?v=htew3BToP10[/embedyt] First wave of Agenda is here:- http://www.apacouc.org/2017-webinar-tour.html I am speaking about Oracle 18c New Features List and registration link is here https://events.genndi.com/register/818182175026319207/2e96be318e Stay tuned for second and third wave. -Thanks Suresh Hello All, Now I am speaking in four cities and here is the agenda and registration links.
-Thanks Suresh Hello All AIOUG - Hyderabad Chapter announced Performance Tuning Tech Day on 23-June in Hyderabad and I am speaking on SQL Plan Stability & Flexibility Features. Here is registration Link :- https://www.meraevents.com/event/aioug-hyderabad-oracle-db-performance-tuning-tech-day And Agenda is as follows, Don't miss it as the topics covered by speakers will be helpful.
|
|||||||||||||||||||||||||||||||||||||
Follow Me!!!