Feed aggregator

Introducing the New Digital Asset Management Feature Set for Oracle Content and Experience Cloud

WebCenter Team - Wed, 2017-05-10 09:04

Authors: Mark Paterson and Marc-Andre Houle, Oracle Content and Experience Cloud Product Management

Enterprise users of Oracle Content and Experience Cloud can now easily review, and collaborate on digital assets. Creative teams can now take advantage of great new digital asset management features including:

  • A new digital assets area where teams can easily search, access, and view assets— such as corporate graphics, designs, logos, stock photography, videos, presentations, documents, audio, and more
  • Ability to author structured content likes blogs and news articles with different layouts tailored for different channel delivery
  • Collections gives teams a way to organize needed assets for a new site, marketing campaign, or project
  • Streamlined and simplified asset approval workflow and publishing

Check out our latest HOW TO video to learn more about our new Digital Asset Management and Content Item features:

If you need to collaborate on the go we’ve made sure that right from your mobile device, you are still able to manage and approve your company’s valuable digital assets as well as contribute new assets using your device.

  • Masonry view which optimizes the viewing experience
  • Preview and move seamlessly from asset to asset like a slide show using an enhanced asset previewer
  • Contribute images and videos taken right from your mobile device
  • Real time alerts when assets are awaiting their review

Take a closer look at these Digital Asset Management features available to mobile users in action:

Don’t have Oracle Content and Experience Cloud yet? You can start a free trial immediately. Visit cloud.oracle.com/content to get started on your free trial today.

You can always find Oracle Content and Experience Cloud mobile app in both the AppStore and Google play.

 

 

Whoa! Release News for PHP OCI8, node-oracledb, Python cx_Oracle, Instant Client and ODPI-C

Christopher Jones - Wed, 2017-05-10 07:57

I'm just catching up on some releases that happened prior/during my vacation. Here are some things you may have missed tweets on:

  • PHP OCI8 2.1.4 for PHP 7 was released to PECL. This version corresponds to the OCI8 code in PHP 7.0.18 and 7.1.4. If you are on earlier versions, you should upgrade to avoid an uninitialized memory issue, which is bound to cause random things when you least want them.

  • Node-oracledb 1.13.1 was released, fixing a regression binding NULL to PL/SQL procedures.

  • An Instant Client Docker image was released on the Docker Store and on the Oracle Container Registry. This image has the Basic, SDK and SQL*Plus packages, making it ideal for deploying your favorite scripting language.

  • Python cx_Oracle 6.0 Beta 1 was released to PyPI. More on this in a future dedicated post. In brief, there was an underlying re-architecture. The full release notes are here. Install it with python -m pip install cx_Oracle --pre and let us know what you find.

  • ODPI-C 2.0 Beta 3 was released on GitHub. There were a few tweaks that you can read about here.

Yes, it has been busy.

Quantum Space

Jonathan Lewis - Wed, 2017-05-10 07:31

Here’s a not very serious note that makes a serious point.  I’ve got a small tablespace made up of 4 files, and here’s a little report I can run against the data dictionary for that tablespace:


select 'File space' What, nvl(sum(user_bytes)/1048576,0) MB from dba_data_files where tablespace_name = 'LOB_TEST'
union all
select 'Free space',      nvl(sum(bytes/1048576),0)         from dba_free_space where tablespace_name = 'LOB_TEST'
union all
select 'Extents',         nvl(sum(bytes/1048576),0)         from dba_extents    where tablespace_name = 'LOB_TEST'
union all
select 'Segments',        nvl(sum(bytes/1048576),0)         from dba_segments   where tablespace_name = 'LOB_TEST'
;

The name of the tablespace isn’t significant – it happens to be a tablespace I created to do some tests relating to space allocation with securefile LOBs, and it’s been hanging around ever since.

The query first reports the “user” space defined by the files – remember that there will be some space for header information and other metadata, and there may be some space near the end of the file which is smaller than the minimum extent allowed for that tablespace.

After the statement of total possible usable space we get: the free space, the space taken up by used extents, and the space taken up by segments.

Here’s the result I get currently:


WHAT               MB
---------- ----------
File space        196
Free space        196
Extents             0
Segments          196

The total usable space is 196MB, of which 196MB are free with no space allocated to extents — except 196MB HAS been allocated to segments. Depending how you look at it the tablespace is either full, or empty.

If you’re in the know the puzzle resolves itself if you query for the segment names, which look like: “BIN$TrDKUCvcVQbgUwEAAH9K2Q==$0” – I have one segment that is in the recycle bin, so I can recover it from the bin if I need it, but until I do Oracle can reuse the space if it wants it. Like Schrodinger’s cat the objects is both alive and dead until someone decides to peek.

After a call to “purge recyclebin” the result changes to:


WHAT               MB
---------- ----------
File space        196
Free space        196
Extents             0
Segments            0

On a production system you might need to issue “purge dba_recyclebin” (if you have the appropriate privilege) to resolve the apparent contradiction as the call to “purge recyclebin” applies only to objects in your own schema.

This note was prompted by a question on the OTN database forum about contradiction between a traditional SQL statement to report free and used space and a screen dump from Enterprise Manager.  I don’t think the thread reached a firm conclusion – but apart from the potential for the recyclebin to confuse the issue, there are extra possibilities thanks to auto-extensible data files, and the Enterprise Manager’s scope for querying a complete different set of views such as dba_tablespace_usage_metrics and v$filespace_usage. In fact the EM code clearly had at least one error in it (which makes any of its results suspect) because it managed to report the critical tablespace as 390% used!

 

 


Oracle API Platform Cloud Enables Customers to Drive Business Transformation and API-First Thinking

Oracle Press Releases - Wed, 2017-05-10 07:00
Press Release
Oracle API Platform Cloud Enables Customers to Drive Business Transformation and API-First Thinking Helps developers monetize new opportunities and deliver better customer experiences

Redwood Shores, Calif.—May 10, 2017

Oracle today expanded Oracle Cloud Platform’s integration offerings with the availability of Oracle API Platform Cloud Service. Bringing together leading API-first design and governance capabilities from recently acquired Apiary and API management from Oracle, the new cloud service delivers end-to-end capabilities for designing, prototyping, documenting, testing, and managing the proliferation of critical APIs. Through a completely new and simplified API management experience, users can easily support changing business demands while having clear visibility into who is using APIs for better control and monetization of digital assets.

“Data is the new corporate currency and APIs are critical to business modernization and agility, enabling users to easily connect and share key information across applications and devices—mobile, IoT, in the cloud or on-premises,” said Amit Zavery, senior vice president, Oracle Cloud Platform. “The Oracle API Platform Cloud enables developers to capitalize on new opportunities by enabling users to simply and securely manage the entire lifecycle of their APIs.”

Part of the Oracle Cloud Platform, Oracle API Platform Cloud Service is designed to eliminate the complexities associated with transforming on-premises API solutions into the cloud, so companies can thrive in the digital economy. Users can grant external developers and partners access to data locked behind firewalls, inside applications, and within data stores, enabling them to power a larger community to innovate and develop new monetization strategies. It also empowers developers to manage different interfaces for a variety of audiences using advanced, but easy-to-use, API management capabilities.

“As organizations continue to adopt not one but multiple cloud vendors, information has never been more federated. Real time access to such assets via APIs has therefore become a priority for our customers,” said Luis Weir, Chief Architect, Application Services, Capgemini UK. “Oracle API Platform Cloud Service delivers a pure-play third-generation API solution capable of creating and managing APIs that run in any vendor’s cloud and/or on-premises—while keeping the entire platform operations and API lifecycle central in the Oracle Cloud. The incorporation of Apiary into the platform, only makes it better as developers also get the tools they need to help ensure that those APIs are well designed, documented and are easy to consume.”

“Customers want to unlock the value in their systems by delivering APIs to internal developers and even customers to re-invent and remix critical business functions,” said Steve Giovannetti, CTO and Founder, Hub City Media. “Oracle API Platform Cloud reduces the administrative burden of launching services by handling API discovery, security, throttling, and versioning in an innovative hybrid cloud solution.”

“Trunk Club has been able to develop new solutions quickly with Oracle Apiary,” said Brian Lee, engineering manager at Trunk Club. “Originally, a lack of API documentation left a lot of room for interpretation, but since implementing Oracle Apiary, API documentation has been a game changer. Front-end and back-end teams have been able to focus on better API design, and the integrated mock server has allowed us to develop in parallel. Not only has development time gone down, but using Oracle Apiary also brought the architecture and payload discussion earlier in the development process, making it easier for us to collaborate across teams and platforms.”

Key capabilities in the Oracle API Platform Cloud Service include:

  • Design: Collaborate company and customer requirements via API Descriptions and Build API semantic guides for governance and control.
  • Build: Create APIs on top of existing services to enable access to data formerly locked inside legacy apps and data stores.
  • Security Features: Assign industry-standard security and threat protection to APIs with no coding, including OAuth 2.0, IP filtering, and rate limiting.
  • Hybrid Deployment: Choose to deploy the gateway on-premises, in Oracle Cloud or through third-party clouds with the ease of a single-click. Create API policy once, deploy everywhere—a rich lifecycle management tool.
  • Publish: Browse a comprehensive list of proven APIs from Oracle, the community, and your own organization.
  • Consume: Register third-party apps easily to allow them the same seamless API utilization as pre-loaded Oracle SaaS APIs.
  • Monitor: View operational API metrics on a single dashboard to take action quickly.

When used in combination with Oracle’s larger cloud portfolio, Oracle API Platform Cloud can deliver API management as part of a comprehensive and unified PaaS solution to simplify the use of API-related tools including identity management, process management, content management, integration and applications development.

Contact Info
Nicole Maloney
Oracle
+1.415.235.4033
nicole.maloney@oracle.com
Kristin Reeves
Blanc & Otus
+1.415.856.5145
kristin.reeves@blancandotus.com
About Oracle

The Oracle Cloud delivers hundreds of SaaS applications and enterprise-class PaaS and IaaS services to customers in more than 195 countries while processing 55 billion transactions a day. For more information about Oracle (NYSE:ORCL), please visit us at cloud.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Safe Harbor

The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

Talk to a Press Contact

Nicole Maloney

  • +1.415.235.4033

Kristin Reeves

  • +1.415.856.5145

Video: CQRS or CRUD: Modeling Enterprise Applications

OTN TechBlog - Wed, 2017-05-10 07:00

Java Champion Sebastian Daschner discusses the Command Query Responsibility Segregation (CQRS) method for modeling enterprise applications, and how it compares to the create, read, update, and delete (CRUD) method, particularly with regard to event sourcing.

Sebastian has been a very busy guy, having presented sessions at the Oracle Code events in New York, Toronto, and London, and even found time to record a 2 Minute Tech Tip on boosting your JavaEE productivity with Live Templates. You'll find links to that video and other resources below.

Additional Resources

How to make rows to columns

Tom Kyte - Wed, 2017-05-10 04:46
Hi Tom, <code>create table emp_det ( name varchar2(15), occupation varchar2(15) ); insert into emp_det values('samantha','doctor'); insert into emp_det values('julia','actor'); insert into emp_det values('maria','actor'); insert into emp_...
Categories: DBA Blogs

inactive session kill

Tom Kyte - Wed, 2017-05-10 04:46
Hi team, As i have seen i my db where active users are 15 and inactive session are 1500 so load become high then i kill the inactive session like alter system kill session 'SID,SERIAL#' immediate; it works fine and load become normal. So ho...
Categories: DBA Blogs

db cache advice

Tom Kyte - Wed, 2017-05-10 04:46
How are the ON, READY and OFF values supposed to be used ? At first I had the impression I had to do: OFF -> READY -> ON, so READY would allocate memory to be used. Should I do: OFF -> ON -> READY (to maintain memory allocated) -> ON ?
Categories: DBA Blogs

Same SQL, Same Plan but different times on 11gR2 Vs 12cR1

Tom Kyte - Wed, 2017-05-10 04:46
Hi Chris/Connor, Hope you are doing good!! Need you advise on this strange situation we are stuck in, So We have moved from 11gR2 to 12cR1 database and currently in UAT phase, however, it all came to an halt when one of our critical process ...
Categories: DBA Blogs

SQL Server 2017: first steps with Python Service

Yann Neuhaus - Wed, 2017-05-10 02:54

Last year, I written blogs about SQL Server 2016 and his integration from the R language.
Just for information, you can find these blogs about SQL Server 2016 R Services here:

Now, the next version of SQL Server, named officially SQL Server 2017 integrate also the language Python.
The first step is to install the Python Services during the installation of SQL Server.
Python01
In the Instance Features > Database Engine Services, you have a new structure named “Machine Learning Services (In-Database)” with R and Python.
I check the case “Python” and next button.
After the classical instance, server and database Engine Configurations, a window “Consent to install Python” need your acceptance to be validate and go to the next installation step.
Python02
After that, the installation begins and failed… :-(
Python03
The eternal question, WHY???…
Like a majority of peoples, I don’t read the text in the window “Consent to install Python”.
The text explains “By clicking Next, you will start the download and installation of these packages to your machine.”. This means that you need an access to Internet.
You can also go the installation log file to see the error message:
Python10
After activating the access to Internet to download all necessary packages to use Python, the installation was successful. :-D
Python04
I have the curiosity to have a look in the installation file and find the feature parameter for the script installation for Python. In addition of ADVANCEDANALYTICS, to install Python the parameter is SQL_INST_MPY.
Python05
Like for R, in the instance configuration, you need to set the ‘external script enabled’ to 1.
If you haven’t read my article on SQL Server 2016: R Services, I rewrite the method to search and configure the service:
Script to search the configuration:

SELECT * FROM sys.configurations WHERE name='external scripts enabled'

Python06
As you can see in the result, this configuration is not dynamic and need a restart of the engine.
After a restart, the configuration is enabled.
Python07
Time to test a query….
Like my article SQL Server 2016 – R Services Tips: How to find installed packages using T-SQL?, I will find all installed packages.
I have created the Query using packages pip and pandas:

  • pip is a package management system used to install and manage software packages
  • Pandas is a library for data manipulation and analysis

The query uses the stored procedure sp_execute_external_script and Python as parameter for the language:

exec sp_execute_external_script  @language =N'Python',
@script=N'import pip
import pandas
installed_packages = pip.get_installed_distributions()
installed_packages_list = sorted(["%s %s" % (i.key,i.version)
     for i in installed_packages])
OutputDataSet = pandas.DataFrame(installed_packages_list)'

Python08

 

You can see that you have 125 packages installed for Python with the CPT2 of SQL Server 2017.
Have fun with Python on SQL Server… 8-)

 

Cet article SQL Server 2017: first steps with Python Service est apparu en premier sur Blog dbi services.

Reminder: Extended Support for Oracle Portal Ends June 2017

Steven Chan - Wed, 2017-05-10 02:00

Extended Support Oracle Portal 11gR1 (e.g. Portal 11.1.1.6) ends on June 30, 2017.  This is published in the Oracle Lifetime Support Policy for Fusion Middleware (PDF):

Migrating to Oracle WebCenter

If you're currently using Oracle Portal, you should upgrade to the terminal release: Portal 11.1.1.6.  

You consider migrating to Oracle WebCenter Portal at your earliest convenience.

What can EBS customers expect after June 2017?

After Oracle Portal enters Sustaining Support on July 1, 2017:

  • Oracle Support will continue to assist, where possible, in investigating issues that involve Oracle Portal.
  • Oracle's ability to assist may be limited due to limited access to PCs running Oracle Portal.
  • Oracle will continue to provide access to existing EBS patches for Oracle Portal.
  • Oracle will provide new EBS patches only for issues that can be reproduced on Oracle WebCenter.

Related Articles

Categories: APPS Blogs

Announcing SLOB 2.4! Integrated Short Scans and Cloud (DBaaS) Support, and More.

Kevin Closson - Wed, 2017-05-10 01:59

This post is to announce the release of SLOB 2.4!

VERSION

SLOB 2.4.0. Release notes (PDF): Click Here.

WHERE TO GET THE BITS

As always, please visit the SLOB Resources page. Click Here.

NEW IN THIS RELEASE
  • Short Table Scans. This release introduces the ability to direct SLOB sessions to perform a percentage of all SELECT statements as full table scans against a small, non-indexed table. However, the size of the “scan table” is configurable.
  • Statspack Support. This version, by default, generates STATSPACK reports instead of Automatic Workload Repository (AWR) reports. This means that SLOB testing can be conducted against Oracle Database editions that do not support AWR–as well as the ability to test Enterprise Edition with fewer software licensing concerns. AWR reports can be generated after a simple modification to the slob.conf file.
  • External Script Execution. House-keeping of run results files and the ability to, for example,  issue a remote command to a storage array to commence data collection is introduced by the EXTERNAL_SCRIPT feature in SLOB 2.4.
ADDITIONAL CHANGES

SLOB 2.4 has been tested on public cloud configurations to include Amazon Web Services RDS for Oracle. SLOB 2.4 changes to slob.conf parameters, and other infrastructure, makes SLOB 2.4 the cloud predictability and repeatability testing tool of choice as of SLOB 2.4.

ADDITIONAL INFO

Please see the SLOB 2.4 Documentation in the SLOB/doc directory. Or, click here.

ACKNOWLEDGEMENTS

The SLOB 2.4 release came by way of non-trivial contributions from the SLOB community. I’m very thankful for the contributions and want to point out the following value added by several SLOB user community folks:

  • Chris Osborne (@westendwookie). Chris provided a functional prototype of the new SLOB 2.4 Scan Table Feature. Thanks, Chris!
  • Christian Antognini (@ChrisAntognini): Chris provided a functional prototype of the new SLOB 2.4 support for statspack! Thanks, Chris!
  • James Morle (@JamesMorle). James has helped with several scalability improvements in slob.sql based on his astonishing high-end SLOB testing. With thousands of sessions attached to a dozen or more state-of-the-art Xeon hosts connected to NVM storage led to several issues with proper start/stop synchronization and thus impacting repeatability. James also created the new SLOB 2.4 EXTERNAL_SCRIPT feature. As always, thanks, James!
  • Maciej Przepiorka (@mPrzepiorka): Maciej conducted very thorough Beta testing and enhanced the EXTERNAL_SCRIPT feature in SLOB 2.4. Thanks, Maciej.
  • Martin Berger (@martinberx): Martin conducted significant Standard Edition testing and also enhanced the SLOB/misc/awr_info.sh (SLOB/misc/statspack_info.sh) script for producing performance data, in tuple form, from statspack. Thanks, Martin!

Filed under: oracle

Oracle Announces Data Center Plans for India

Oracle Press Releases - Tue, 2017-05-09 23:30
Press Release
Oracle Announces Data Center Plans for India

ORACLE OPENWORLD, NEW DELHI —May 10, 2017

Oracle today announced it will expand its cloud services in India over the next six to nine months with plans for an Oracle data center in India.

Over the coming months Oracle will be reviewing proposals from government and business partners to provide customers with the capability to build and move workloads to an India-based cloud. The services will offer uncompromised security and performance at a significant price advantage over both existing on-premises infrastructure and competitive cloud offerings.

Oracle’s expanded infrastructure footprint is a result of tremendous customer demand.

“Our customers and partners in India have trusted their businesses and mission-critical workloads to the Oracle Cloud for years,” said Thomas Kurian, president of product development, Oracle. “With this expansion we will be able to further support customer choice adding to capabilities already available through deployments of Oracle Cloud at Customer, as well as other Oracle Cloud data center regions in Asia Pacific.”

Contact Info
Vandana Shenoy
Oracle
+91.9811551760
vandana.shenoy@oracle.com
About Oracle

The Oracle Cloud delivers hundreds of SaaS applications and enterprise-class PaaS and IaaS services to customers in more than 195 countries while processing 55 billion transactions a day. For more information about Oracle (NYSE:ORCL), please visit us at http://cloud.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Safe Harbor

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

Talk to a Press Contact

Vandana Shenoy

  • +91.9811551760

APEX Connect 2017 – Day 1

Yann Neuhaus - Tue, 2017-05-09 18:26

This year again the APEX connect conference spans over three days with mixed topics around APEX, like JavaScript, CSS, SQL and much more.
After the welcome speech and the Keynote about “Reconciling APEX and the Thick Database Paradigm” by Bryn Llewellyn I decided to attend presentations on following topics:
– Temporal Validity and Flashback Data Archive
– Universal Theme and Custom Themes in APEX 5.1
– Using REST Services in APEX applications the nice way
– Uncover the Truth (of APEX application)
– Browser Developer Tools for APEX developers
– Docker for Dummies

Thick Database Paradigm:
What was highlighted by Bryn Llewellyn is that the key to proper Database development, is to encapsulate your database through PL/SQL APIs.
When you work on DB development make your environment such as it can be easily rebuild from scratch with sripts so you have no fear in making anything wrong.
Your schema user should have as less rights as needed so you keep your environment safe.
If you build proper APIs, no mater what kind of client application uses your data (APEX, REST, Java Web App, …), it will be able to interface.

Temporal Validity and Flashback Data Archive:
There is an increasing demand on data history and audit.
Data history means not only keeping track of past data but also managing different versions of the same data over time (e.g. customer delivery address). This is managed by Temporal validity.
Oracle 12c allows to automatically manage such time dependent data by using “ADD PERIOD FOR” on a table.
When retrieving the data use “AS OF PERIOD FOR” in the select statement.
Details can be found on the Oracle website:
Implementing temporal validity
Audit can be managed using the well known trigger business with all issues it can generate but also automatically by using flashback archive.
In this second case data audit is written in a specified tablespace for which you define the data retention period. SYS_FBA tables get automatically created and information tracked is managed by setting context level. This is very powerful tool as it also takes in account DML changes.
Also very important for audit purpose, flashback data cannot be modified.
You can find further information on following Blog:
Oracle 12c Flashback Data Archive

Universal Theme and Custom Themes in APEX 5.1:
After a brief overview of Theme and Templates history in APEX, we were shown how easy (at least it seems) it is to create and manage custom Theme and Templates.
Template options introduced in APEX 5 aim to reduce the number of templates for a specific “object” type to a minimum in order to ease maintenance.
Live template options have been introduced with APEX 5.1 to have a preview of the changes at run time and facilitate their usage.
Theme subscription allows to distribute changes made to a master Theme which can now be defined at workspace level.
Theme styles allow you to have a dedicated CSS file on top of you application standard CSS and define user based styles from the Theme roller.
Note: Themes based on JQuery Mobile for mobile applications should no longer be used, rather use the Universal Theme responsive as JQuery UI wasn’t updated for long and might have issues with the new JQuery core version that might be used in future versions of APEX.

Using REST Services in APEX applications the nice way:
The definition of REST is based on 3 pillars:
– Resources
– Methods (GET, PUT, POST, DELETE, PATCH)
– Representation (JSON, HTML, CSV, …)
The new REST Client Assistant packaged application in APEX 5.1 will be on a great help for developer as it manages to generate the procedures required to parse JSON data returned by a given REST Data service URL as well as the underlying SQL query to display the data in report.
When the amount of data is becoming to large, REST data services can return them on a pagination fashion which needs to be supported on the client side. At this point only classic report can support that feature in APEX 5.1. Filtering on the data query to the service needs also to be managed. The REST Data Sample application is showing how to implement the different kind of interaction with REST Data services based on Oracle standards.
There will be improvements in supporting REST Data service in the upcoming version 5.2 of APEX, such as remote SQL execution.

Uncover the Truth (of APEX application):
When you have to modify an existing APEX application or take over from customer development you need to understand thee heart of the application which can be a challenge. To do so you need to identify it’s structure and how different elements are used and interact.
Various people are interested in this:
– DB developers
– APEX developers
– Cloud developers
– Project leaders
This is all about:
– Functionality (Page function, application logic, Interfaces)
– Complexity (APEX components, PL/SQL objects, JavaScript, CSS, DB objects)
– Transparency (who changed, when, Conditions, relations between pages)
There are already different tools in APEX allowing to see different aspects of those data:
– Searches
– History
– Application utilities
– Reports
– SQL Workshop
So it can be cumbersome to walk through all those.
We were presented a self developed toll which can be seen as a kind of “Dashboard” to analyze everything in one place base on all sorts of charts reading out the APEX metadata tables. I’m looking forward to seeing it released next summer.

Browser Developer Tools for APEX developers:
The IDE for APEX is the web browser, so it’s important to know about the developer tools provided in your web browser.
Each and every web browser has it’s own tools, some being better than others.
The most used browser has also the most complete tool set: Chrome (Firefox Developer Edition is also worth looking at)
As there are a lot of information to be displayed in the Developer tools, its highly recommended to detach the window from the browser to display it on a secondary screen when possible.
CSS usage is showing all level of the style Sheet to understand what is set where.
Specifications of the web page can be modified on the fly to understand their impact.
Debugging of JavaScript can be done with setting breakpoints.
Application panel allows to monitor cookies.
Device mode allows to emulate mobile devices and even set the network speed to have a better understanding of end user experience.
Even remote debugging can be used on attached devices.

Docker for Dummies
I already heard a lot about Docker but I never took some time to look into it, so I took the opportunity to have it shown today.
What is Docker? A light weight VM?
No, a container!
It allows to share resources and get ride of things like Hypervisor and full target OS (which are used for VMs), which makes it light.
Main characteristics are:
– You can put almost anything into it
– It stays locked
– It’s efficient for transport
– It’s small, light weight
– It’s scallable
Actually it can be seen more as a software delivery platform.
The basic component is an image:
– It contains File System and parameters
– It has no state
– Layers are read only
– Layers are shared
– Updates require only updated files to be downloaded
A container is a running instance of an image. It adds a R/W layer on top of the image.
Images are not cloned.
Persistence of the data used in the container is managed by mapping local folder into the container.
Also Docker is command line based, there is a GUI available called Kitematic.
Resources:
Docker website
Kitematic website
You can find further details on following blog:
Overview and installation

 

Cet article APEX Connect 2017 – Day 1 est apparu en premier sur Blog dbi services.

Certifications

Steven Chan - Tue, 2017-05-09 11:39
Categories: APPS Blogs

Video: IoT: You're Not Paranoid Enough

OTN TechBlog - Tue, 2017-05-09 11:01

Is your IoT-enabled toaster sharing information about your WiFi network? Is someone using that device you ask for weather reports to listen to your private conversations? Are you concerned about the security of IoT devices? Maybe you should be.

The Internet of Things presents architect and developers with enormous opportunities for innovation, and it's well worth the time and effort to explore the various devices and possibilities. But as an architect or developer you need to be aware of concerns about the security of IoT devices. Blaine Carter, a Oracle developer advocate for Open Source, voices some of those concerns in this 2 Minute Tech Tip

Additional IoT Resources Also from Blaine Carter

Reset 12c identity column sequence to 1

Tom Kyte - Tue, 2017-05-09 10:26
For entire schema need a script to reset all 12c identity columns seq to 1. Identify all identity columns....I believe there should be a data dictionary view. Then do some alter script. Like select 'alter identity ' from view ; Thanks. ...
Categories: DBA Blogs

Daily Big Amount of data deleteion on partitioned table, but not by partition key

Tom Kyte - Tue, 2017-05-09 10:26
Hi Tom, First, Thanks for the great effort answering everyone questions. lately im struggeling in deleting data in our system(OLTP). The tables we need to delete are all partitioned by start_Time(which mostly being used by every query in the s...
Categories: DBA Blogs

Table join only if records exist

Tom Kyte - Tue, 2017-05-09 10:26
I have the following tables... Student Info: Student ID* Student Name etc. Available Courses: Semester* Course ID* Subject Course Number Course title Registration: Student ID* Semester* Course ID* *Designates primary key As ...
Categories: DBA Blogs

BULK COLLECT

Tom Kyte - Tue, 2017-05-09 10:26
Hi, I have the following code where the cursor returns 2985604 rows. I am using the following PL/SQL procedure to insert and delete rows. However, although I am using BULK COLLECT, it still takes over 2 hours to come back ! Is there something w...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator