Feed aggregator

Oracle Java SE 10 Release Arrives

Oracle Press Releases - Tue, 2018-03-20 11:00
Press Release
Oracle Java SE 10 Release Arrives Continues Commitment to Delivering New Java Innovations Faster and More Frequently

Redwood Shores, Calif.—Mar 20, 2018

Oracle today announced the general availability of Java SE 10 (JDK 10). JDK 10 is a production-ready implementation of the Java SE 10 Platform Specification, as specified by JSR 383 in the Java Community Process. The first release in Oracle’s new six-month Java innovation cycle, Java SE 10 provides a number of new features, including local variable types, parallel full GC for G1, and experimental features such as the Java-Based JIT Compiler.

Java SE 10 was created in close collaboration with the OpenJDK Community, a diverse set of contributors whom have collaborated for more than ten years on an open-source implementation of the Java SE platform. Key features in the new release include:

  • Local-variable type inference: enhances the Java language to extend type inference to declarations of local variables with initializers.
  • Parallel Full GC for G1: improves G1 worst-case latencies by making the full GC parallel.
  • Application Class-Data Sharing: optimizes startup time and footprint by extending the existing Class-Data Sharing ("CDS") feature to allow application classes to be placed in the shared archive.
  • Experimental Java-Based JIT Compiler: enables the Java-based JIT compiler, Graal, to be used as an experimental JIT compiler on the Linux/x64 platform

“Oracle is committed to rapidly evolving and delivering new innovations in the Java platform – this being the first in our newly adopted release cycle and licensing model,” said Georges Saab, Vice President, Software Development, Java Platform Group at Oracle. “We’re especially proud of the simplicity of this release, which introduces useful new features, removes unnecessary elements, and is easy for developers to use.”

To learn more about the JDK 10 release, please visit the Java PM blog. For the full list of features introduced in JDK 10, please visit this page.

Java is the world’s most popular programming language, with over 12 million developers running Java. Java is also the #1 developer choice for cloud, with over 21 billion cloud-connected Java virtual machines.

Contact Info
Alex Shapiro
Oracle
+1.415.608.5044
alex.shapiro@oracle.com
About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

Trademarks

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

Talk to a Press Contact

Alex Shapiro

  • +1.415.608.5044

How to save and show real executions Plans without EE resources

Tom Kyte - Tue, 2018-03-20 10:26
Hi - I would like to know if it is possible to save (in a plan table, say) the real execution plan of a given SQL present in the SQL cache and later show it via DBMS_XPLAN - first please note, I'm talking about the real execution plan (and including ...
Categories: DBA Blogs

SQL problem [ORA-01722: invalid number]

Tom Kyte - Tue, 2018-03-20 10:26
Hi Tom, Could you please help me with the below SQL. I have 2 users "dev" and "admin", both are in same database. DEV>DESC TB_CMA086_US_CITY Name Null? Type --------------------------------...
Categories: DBA Blogs

database sql performance with histograms

Tom Kyte - Tue, 2018-03-20 10:26
Hi Team, is their any way to find old histogram on column . in my situation , i see table having column status having histogram height based , but earlier it was freq. based , in this situation i know this because we have collected data , but in ...
Categories: DBA Blogs

Different ways of writing SQL for no particular reason

Tom Kyte - Tue, 2018-03-20 10:26
Find highest salary in each department without using MAX function Use a single SELECT statement only. For an added complexity (optional): try not using ANY functions at all (neither group, nor analytic, not even scalar) ...
Categories: DBA Blogs

Creating dates with date ranges

Tom Kyte - Tue, 2018-03-20 10:26
Hi Tom, i have a table MY_DATES (START_DATE DATE, END_DATE DATE) with date like : <code> START_DATE END_DATE --------------------------- 18-DEC-17 07-JAN-18 27-JAN-18 06-FEB-18 08-MAR-18 18-MAR-18 </code> ...
Categories: DBA Blogs

Covert clob data into JSON format

Tom Kyte - Tue, 2018-03-20 10:26
I have two clob columns in my table KEY & VAL. Key column data: ACTION|COCODE|SNCODE|SPCODE|PARAMETER_ID|PARAMETER_VALUE|PARAMETER_ID|PARAMETER_VALUE|SNCODE|SPCODE|SNCODE|SPCODE|PARAMETER_ID|PARAMETER_VALUE VAL column data: Add|CONTR001920905...
Categories: DBA Blogs

Check for Expiry two weeks prior

Tom Kyte - Tue, 2018-03-20 10:26
Hi Tom, i have a question regarding some expiry dates that I have in a table and need to create a function that will check for those dates and will notify before they expired in two weeks. i am very new to this and hoping that you might help me...
Categories: DBA Blogs

redhat event Ansible Automates Zurich

Yann Neuhaus - Tue, 2018-03-20 10:08

Here are some fresh personal impressions from the “Ansible Automates Zurich” half day event organized by redhat.
There was a overwhelming interest for this event. About 200 people filled the room and there were many more on the waiting list.
The event started with a networking lunch. My impression was, that the visitors were not only interested in the food, but also gaining some practical knowledge about Ansible. Most of them are already using Ansible.

Eduard Modalek from redhat opened the Event. He was very impressed with the interest in the event.
AnsibleAutomates ZurichSacha Dubois who is a great speaker with solid technical background gave an introduction about Ansible and the impact to your team and enterprise. “Ansible loves the repetitive work your people hate.”

Ansible loves the repetitive work your people hate

Ansible community downloads

The strength of Ansible is the community. Enjoy the  statistics. Ansible has

  • more than 27’000 stars on GitHub
  • over 1250 modules and
  • more than 500’000 downloads a month

 

Christian Sanabria and Marc Frauenfelder from ipt – Innovation Process Technology showed how they do Continuous Delivery by combining Jenkins Pipeline with the Ansible Tower API for provisioning. They published the code in GitHub:
https://github.com/mfrauenfelder/ansible/blob/master/Jenkinsfile

After the break Rob McMahon, redhat Director Cloud EMEA, who had already presented a day before at the Ansible Automates Netherlands event, showed his visions about empowering customers with Ansible.  The future are automated organizations and Ansible is the right tool to automate everything and help to overcome the silo character of cross functional teams.

Ansible Automates Organizations
Another customer case has been shown by Nicolas Christener and Lukas Grossar from Adfinis SyGroup AG. They fully automated the roll out of desktop clients.

Roland Wolters from redhat reveals what is coming in March 2018 with Ansible 2.5

  • Networking now first level connection “plugin”- credentials just like with any other connections
  • Role versioning
  • become on Windows features NT AUTHORITY\System and others
  • new loop mechanism ( no with_loops anymore)
  • fact namespaces

He also explained the differences between Ansible Tower and  the open source project AWX.

The highlight at the end was a live demo which deployed a WordPress environment in the Microsoft Azure cloud. Roland Wolters and Sacha Dubois demonstrated it successfully. Congratulations ! If you have a valid subscription at Microsoft Azure you can try it out https://github.com/sa-ch/ansible-azure-deployment

Ansible deploy WordPress on Microsoft AzureThere has been time for drinks and networking afterwards.
I spoke with Eduard Modalek. The organization was a big challenge, so many people wanted to attend this event and this was the biggest room they could get at such short notice in Zürich. He said that in future there will be more events like this, and perhaps some workshops with time for the audience to exchange ideas.

 

Cet article redhat event Ansible Automates Zurich est apparu en premier sur Blog dbi services.

SQL Server 2017: Can I run a “standard” rebuild on the index after a Resumable Online Index Rebuild is suspended?

Yann Neuhaus - Tue, 2018-03-20 07:18

This article is an additional article to my precedent about “SQL Server 2017: What’s happens with an interruption during a Resumable Online Index Rebuild?

The goal is to see after I suspend the rebuild, if I can run a traditional rebuild without the option RESUME.

 

I start an index rebuild with the option Resumable:

ALTER INDEX [NCI_dbo_Transaction] ON [dbo].[Transaction]
REBUILD WITH (RESUMABLE = ON, ONLINE = ON)
GO

 

In a new query window, I stopped the rebuild:

USE [WideWorldImportersDW]
GO
ALTER INDEX [NCI_dbo_Transaction] ON [dbo].[Transaction] 
PAUSE
GO

 

As you can see, the index rebuild is stopped:
riro2_00

 

I have a look on the index state with the DMV sys.index_resumable_operations:
riro2_01

 

To restart, I run the rebuild without the RESUME or ABORT options:
riro2_02

As you can see, the query does not work and you have this error message:
Msg 10637, Level 16, State 1, Line 14
Cannot perform this operation on ‘object’ with ID 430624577 as one or more indexes are currently in resumable index rebuild state. Please refer to sys.index_resumable_operations for more details.

The standard rebuild will not change the status of the resumable rebuild and begin from scratch in order to do the rebuild from beginning.
Finally, the only way to rebuild the index is really to use the RESUME option and continue where it’s stopped.

 

Cet article SQL Server 2017: Can I run a “standard” rebuild on the index after a Resumable Online Index Rebuild is suspended? est apparu en premier sur Blog dbi services.

Oracle HCM Cloud Delivers Simple and Powerful Innovations that Can Make Work More Enjoyable and Supportive for Employees

Oracle Press Releases - Tue, 2018-03-20 07:00
Press Release
Oracle HCM Cloud Delivers Simple and Powerful Innovations that Can Make Work More Enjoyable and Supportive for Employees New AI capabilities and user experience enhancements deliver a more personal, productive, and rewarding employee experience

ORACLE HCM WORLD, Dallas—Mar 20, 2018

To empower HR professionals and further enhance the employee experience, Oracle (NYSE: ORCL) today announced new artificial intelligence-based capabilities and user experience enhancements within Oracle Human Capital Management (HCM) Cloud. The latest innovations deliver simple, powerful tools that can improve engagement, recruitment, and HR productivity, while also empowering employees to quickly and easily access the information they need to excel at work.

“HR teams have traditionally had to pick between simplicity and performance when selecting new technologies,” said Holger Muller, VP and Principal Analyst, Constellation Research. “To accelerate innovation, improve productivity, and successfully prepare for the future of work, HR can no longer make this trade-off. Instead, HR teams need simple and powerful solutions that combine an intuitive user experience with the latest innovations in areas such as chatbots and artificial intelligence.”

HR professionals need to apply new strategies and technologies to attract, engage, and retain employees to address escalating recruitment costs and increasing employee turnover. The latest innovations within Oracle HCM Cloud enable HR professionals to address these challenges by providing simple, powerful solutions that can proactively anticipate and respond to changing employee and workforce needs. The new innovations can optimize talent management, provide complete workforce insights, increase operational efficiency, and make it easy for everyone to connect, collaborate, and do their job—from anywhere, on any device.

“We are always looking at new ways to enhance the employee experience and optimize business processes, and Oracle has been a key partner in helping us make that possible,” said Larry Freed, CIO, Overhead Door Corporation. “The new AI and user experience enhancements within Oracle HCM Cloud are powerful innovations that will greatly benefit our employees.”

With the new features, HR professionals can simplify and humanize the entire candidate and employee experience by making work more enjoyable, smarter, and collaborative.

Make Work Enjoyable: A redesigned user interface leverages artificial intelligence to help employees minimize busywork and focus on actions and decisions that matter most. The new features include:

  • “Newsfeed” Interface: Employees can now choose a “newsfeed” style interface to highlight the data and details they care about most. For example, tasks that need attention can be highlighted in an easy-to-read tiled format; an automatically updating analytics snapshot can elevate key business insights; and company and employee-related news can be easily accessed without digging through email. 
  • Seamless Search: Intelligent, intuitive, new search capabilities make it easier for employees to find the information they are seeking quickly and easily.
  • One Experience, Any Device: A personalized cross-device experience enables employees to be more productive and take action based on company updates, personal feedback, and goals—no matter where the job takes them—on their desktop, tablet, or mobile phone.
  • Continuous Performance Management: New performance “check-in” capabilities help ensure employees are always receiving real-time coaching and feedback and can easily track goals.
 

Make Work Smarter: Powerful, built-in AI capabilities and guided paths create a simple and personalized experience from a candidate’s first interaction, through to hiring and onboarding. The new features include:

  • Candidate Recruiting: New AI and chatbot capabilities enable candidates to search for jobs and get questions answered directly through channels like Facebook Messenger, while also automatically alerting candidates to updates and needed actions on their channel of choice.
  • Optimized Promotion Process: A “self-driving” promotion process helps employees reach their objectives and succeed in their current positions by providing proactive alerts.
  • Hiring and Onboarding the Right Employees: Advanced machine learning capabilities helpreduce the time it takes to fill open positions by highlighting best-fit candidates and proactively identifying candidates and employees who should be invited to apply.

     

  • Smart Onboarding: New onboarding features enhance collaboration between new hire, manager, and HR team to make it faster and easier for employees to move from “new hire” to an engaged, productive contributor to the team.
 

Make Work Supportive: New smart and adaptable AI-powered business processes enable HR professionals to deliver all the support employees need to excel. The new features include:

  • HR Help Desk in the Cloud: Helps ensure compliance by optimizing the management and security of sensitive Employee Relations cases with configurable actions, such as managing data collection by category and queue. Extended knowledge management capabilities ensure consistent search and content based on security and versioning.
  • Advanced HCM Controls: A pre-built library of best practice controls, security dashboards and workbench capabilities help organizations stop unauthorized access to sensitive HCM functions and data. With the ability to also manage exception and policy violations, HR departments can keep classified employee data protected, while lowering compliance costs (GDPR, SOX etc.), by automating audit procedures and analysis.
 

“We all now expect that enterprise applications offer the same easy, intuitive experience that we enjoy with digital services in our personal lives,” said Chris Leone, senior vice president, HCM Development, Oracle. “With the latest release of Oracle HCM Cloud, we are focused on delivering the best possible employee experience without compromising the security or performance of critical business applications. By leveraging advanced technologies to make HR applications powerful yet simple to use on any device, we can make work smarter, more enjoyable, and more supportive.”

For additional information about Oracle HCM Cloud, follow @OracleHCM on Twitter or Facebook, or read the Modern HR in the Cloud blog.

Contact Info
Simon Jones
Oracle
+1.415.202.4574
s.jones@oracle.com
About Oracle
The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle, please visit us at 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

Simon Jones

  • +1.415.202.4574

SQL Server 2017: What’s happens with an interruption during a Resumable Online Index Rebuild?

Yann Neuhaus - Tue, 2018-03-20 06:14

Last week, I presented this option in our internal event, the dbi xChange.

My colleague David Barbarin asked me this question, what’s append if an interruption occurs (reboot, SQL Server service stopped,…) during a Resumable Online Index Rebuild?

I was not able to answer because I forgot to do this test.

The new enhancement for an index rebuild provides the capability to suspend, resume or abort an online index operation (msdn reference). I always use the option PAUSE to see how it works but never with a break.

Now I do the test to have the answer. It’s never too late! ;-)

To do my demo, I downloaded the Microsoft example database WideWorldImportersDW from github.

I choose the index NCI_dbo_Transaction in the Transaction table.

riro_00

As you can see with this query, the index is big enough to have the time to interrupt the rebuild.

I run the rebuild with this command:

ALTER INDEX [NCI_dbo_Transaction] ON [dbo].[Transaction] 
REBUILD WITH (RESUMABLE = ON, ONLINE = ON)
GO

After killing the SQL Server task in the task manager, I have this message in SSMS:
riro_01
Of course, the server is no more available…

I start the SQL Server service and have a look on the index state with the DMV sys.index_resumable_operations:
riro_02
As you can see the index is on state PAUSE with 19% completed.

To restart, I run the rebuild with the RESUME option:
riro_03

If the index rebuild is interrupted, you don’t need to restart from scratch.
The rebuild is in a PAUSE state and then you can decide or not to continue the rebuild.
Very clever option, isn’t it?

Don’t hesitate to go on David’s blog to read how this option works with AlwaysOn:
https://blog.dbi-services.com/sql-server-2017-high-availability-and-resumable-online-indexes/

 

Cet article SQL Server 2017: What’s happens with an interruption during a Resumable Online Index Rebuild? est apparu en premier sur Blog dbi services.

Finally you will be able to use exit and quit in psql

Yann Neuhaus - Tue, 2018-03-20 05:39

When giving the PostgreSQL DBA Essentials workshop one of the main issues people have is how they can exit psql. Even on stackoverflow this is a popular topic. The good news for people who still don’t like to use “\q” here is the commit that will add additional options to quit/exit from psql.

Up to PostgreSQL 10 what you can usually see is something like this:

postgres@pgbox:/home/postgres/ [PG10] psql -X postgres
psql (10.0)
Type "help" for help.

postgres=# exit
postgres-# exit
postgres-# quit
postgres-# let me out, what do I need to to?
postgres-# 

Starting with PostgreSQL 11 you can either use “quit”:

postgres@pgbox:/home/postgres/ [PGDEV] psql -X postgres
psql (11devel)
Type "help" for help.

postgres=# quit
postgres@pgbox:/home/postgres/ [PGDEV] 

… or “exit”:

postgres@pgbox:/home/postgres/ [PGDEV] psql -X postgres
psql (11devel)
Type "help" for help.

postgres=# exit
postgres@pgbox:/home/postgres/ [PGDEV] 

I am pretty sure MacBook users will love that :)

 

Cet article Finally you will be able to use exit and quit in psql est apparu en premier sur Blog dbi services.

Presenting At ODTUG Kscope18 Conference in Orlando, Florida 10-14 June 2018

Richard Foote - Mon, 2018-03-19 22:47
I’m very excited to have a couple of papers accepted at this year’s ODTUG Kscope18 Conference in sunny and likely very hot Orlando, Florida between 10-14 June 2018. I’m excited because I’ve been to a few of these conferences before and they have always been excellent events. As a mainly Oracle Database kinda guy, it’s […]
Categories: DBA Blogs

Moving from ADG to Golden Gate for an DB centric application

Tom Kyte - Mon, 2018-03-19 16:06
One of my application is currently running on unsupported HW & Oracle version (Solaris 9 & Oracle 10g) with ADG between primary & DR and as part of platform uplift plan is to move to private enterprise cloud (OEL 6/7 with Oracle 12c). Management ask ...
Categories: DBA Blogs

Unable to find EMP & Dept in Object Browser (APEX oracle)

Tom Kyte - Mon, 2018-03-19 16:06
i have recently made an account on APEX oracle, my trainer illustrated how to make the account on Apex and use it for training purpose PL/SQL, therefore i tried by myself when i make the account and go to object browser there i am unable to find any ...
Categories: DBA Blogs

output customization

Tom Kyte - Mon, 2018-03-19 16:06
i have a table create table demo(ord_no number(4),division varchar2(100)); value for the table is insert into demo values(1,123456789012); i just want to create a procedure to do the following cut the division into 4 in length(me...
Categories: DBA Blogs

using max function

Tom Kyte - Mon, 2018-03-19 16:06
Hi, Look at here..... Find highest salary in each department without using MAX function. Note:- Use a single SELECT statement only. For an added complexity (optional): try not using ANY functions a...
Categories: DBA Blogs

sqlloader versus external table.

Tom Kyte - Mon, 2018-03-19 16:06
hi Tom, Is there any advantage of sql* Loader over the new 9i feature external table. Which of them is faster. sql* loader direct path load or direct path load from the external table. thanx in advance Nikhil India
Categories: DBA Blogs

i face prob with the returned cursor from function

Tom Kyte - Mon, 2018-03-19 16:06
<code>i face prob with the returned cursor from function ,i created function to return cursor ,and in the script ,i use the function to give me the cursor after that in loop i try to print all data that is in the cursor . but it didnt work , and ...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator