Feed aggregator

REGEXP_REPLACE Match Parameters m and n.

Tom Kyte - Tue, 2017-04-25 17:06
I've been trying to write a query that will remove the comments from another query. Here's the small sample query-with-comments, from which I want to remove the comments: <code>WITH sample_SQL ( line#, txt ) AS ( SELECT line#, txt FROM dual ...
Categories: DBA Blogs

Index coalesce clean waits on enq: TX - row lock contention

Tom Kyte - Tue, 2017-04-25 17:06
Hi TOMs! I've noticed that periodically our 12.1.0.2 Asynchronous Global Index Maintenance job (PMO_DEFERRED_GIDX_MAINT_JOB) gets hung up from time to time and I've tracked it down to a long running insert causing the job to wait on enq: TX - row lo...
Categories: DBA Blogs

Reporting with SQL, How we can merge multiple execution of SQL

Tom Kyte - Tue, 2017-04-25 17:06
Hello TOM, we are generating report with SQL Query and output save to text file. I want to know if we can avoid multiple execution of SQL queries by using any other better way to achieve this and also not want to impact performance. we execute ...
Categories: DBA Blogs

using LIKE operator with IN Clause

Tom Kyte - Tue, 2017-04-25 17:06
Hi, Currently we have a query as given below, select count (distinct chk_ppl_val.serialnum) serialnum__ndv, count (distinct chk_ppl_val.individual_id) individual_id__ndv from chk_ppl_val where (substring(industry_code,1,4) in (SELECT distinct st...
Categories: DBA Blogs

P1TEXT, P1, P2TEXT, P2

Tom Kyte - Tue, 2017-04-25 17:06
Hi Tom, Want to understand what exactly P1TEXT, P1, P3TEXT, P2 denote in various v$ views like v$session, v$session_wait. Documentation says P1TEXT : Description of the first wait event parameter P1 : First wait event parameter (in decimal) ...
Categories: DBA Blogs

scheduler job not raise error

Tom Kyte - Tue, 2017-04-25 17:06
Hi askTome team. I have two database one name is prod and another is test. Their version are 12.2.0.1 I create a scheduler job on db:prod like this <code> begin dbms_scheduler.create_job( job_name=>'J_TEST_02', job_typ...
Categories: DBA Blogs

Trigger to capture before and after insert value of particular column

Tom Kyte - Tue, 2017-04-25 17:06
Hi Team, I have to create a trigger which will record the old value as well as new value in case of insert. Situation is that I have one application and on frontend part whenever some changes happened then the xyz_id got changed. At the backend, ...
Categories: DBA Blogs

What are the benefits of Manufacturing Dashboards?

Nilesh Jethwa - Tue, 2017-04-25 16:15

Today in the US economy, the major players in the manufacturing industry are electronics, automobile, steel, consumer goods, and telecommunications. And as they offer more advanced products, including tablets and smartphones. These technological advancements significantly influence consumer lifestyles.

Along with these changes, the global manufacturing industry is currently embracing a new key player called metrics based manufacturing. This is actually the latest trend that industries need to consider in their sales funnel. So, what does this mean?

Read more at http://www.infocaptor.com/dashboard/manufacturing-dashboards-what-are-their-benefits

Listener and Virtual IP

Yann Neuhaus - Tue, 2017-04-25 15:24

When you configure a standby database, you want the application to transparently connect to the primary database, wherever it is. That’s the role of Transparent Application Failover, but this requires configuration on the client side. If you can’t configure TAF, you can use a virtual IP address. But then the question is how to configure the listener.ora to handle connections to this VIP.

Don’t worry, if you configured everything as recommended, with the hostname declared in /etc/hosts, and listener.ora referencing this host name, then you can simply ignore the VIP for your configuration. The reason is that when the host specified in the listener.ora resolves to the same IP address as the hostname of the server, then Oracle listener binds the port on all interfaces, and this includes the VIP.

However, if you mentioned an IP address in the listener.ora, or if you mentioned a host that resolves to a different IP than the hostname, then it listens only tho this interface.

Why not just listen to the VIP? There are two reasons for that. First, you will need to listen to the host IP anyway for the dynamic registration of instances. You don’t want the standby database to contact the listener on the primary server. The second reason is that you cannot start the listener if the IP is not up. Then, if you want to explicitly listen to the VIP you will need two listeners, some security rules to allow only local registration and to manage the start of the listener, monitoring, etc.

The simplest configuration is to have one listener configured on the server hostname, then it listens on all interfaces and clients can connect with the VIP (for the application) or with the server IP (for Data Guard broker, backups, monitoring, administration).

The behaviour is described in How The Listener Binds On TCP Protocol Addresses (Doc ID 421305.1)

Examples

I have two network interfaces on my system, the loopback (lo) and Ethernet (enp0s3). This interface has the IP 192.168.78.104 and I have added a virtual IP 192.168.66.102 with:

ip a add 192.168.66.102/24 dev enp0s3

Here is the list of interfaces:

[oracle@VM104 tmp]$ ip a
1: lo: mtu 65536 qdisc noqueue state UNKNOWN
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: enp0s3: mtu 1500 qdisc pfifo_fast state UP qlen 1000
link/ether 08:00:cc:00:4e:68 brd ff:ff:ff:ff:ff:ff
inet 192.168.78.104/24 brd 192.168.78.255 scope global enp0s3
inet 192.168.66.102/24 scope global enp0s3
inet6 fe80::a00:ccff:fe00:4e68/64 scope link
valid_lft forever preferred_lft forever

Here is the content of my /etc/hosts where I have two names that resolve to my server IP address 192.168.78.104

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.78.104 VM104 myhost

One of these names is my server hostname:


[oracle@VM104 tmp]$ hostname
VM104

I’ll try different configuration of my listener.ora

(HOST=127.0.0.1)

I mentioned the IP address of the loopback interface

Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=6666)))

The listener listens to this address only:

[oracle@VM104 tmp]$ ss -elpunt | grep -E "^Net|tnslsnr"
Netid State Recv-Q Send-Q Local Address:Port Peer Address:Port
tcp LISTEN 0 128 127.0.0.1:6666 *:* users:(("tnslsnr",4685,8))

With this configuration, I’m able to connect only through the mentioned address, 127.0.0.1

Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.78.104)(PORT=6666)))
TNS-12541: TNS:no listener
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.66.102)(PORT=6666)))
TNS-12541: TNS:no listener
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=6666)))
OK (10 msec)

(HOST=localhost)

I mentioned the loopback interface by a host name

Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=6666)))

This is actually the same as above: the host mentioned has been resolved at listener startup.

(HOST=1192.168.78.104)

I mentioned the IP address of the host interface

Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.78.104)(PORT=6666)))

The listener listens to this address only:

[oracle@VM104 tmp]$ ss -elpunt | grep -E "^Net|tnslsnr"
Netid State Recv-Q Send-Q Local Address:Port Peer Address:Port
tcp LISTEN 0 128 192.168.78.104:6666 *:* users:(("tnslsnr",4735,8))

With this configuration, I’m able to connect only through the mentioned address, not the virtual IP, not other interfaces:

Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.78.104)(PORT=6666)))
OK (0 msec)
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.66.102)(PORT=6666)))
TNS-12541: TNS:no listener
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=6666)))
TNS-12541: TNS:no listener

(HOST=localhost)

I mentioned the loopback interface by a host name

Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=6666)))

This is actually the same as above: the host mentioned has been resolved at listener startup.

(HOST=VM104)

I mentioned the host name which resolves to the IP address of the host interface – this is the default when creating with DBCA, and the recommended configuration.

Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=VM104)(PORT=6666)))

The listener socket do not mention the IP address:

[oracle@VM104 tmp]$ ss -elpunt | grep -E "^Net|tnslsnr"
Netid State Recv-Q Send-Q Local Address:Port Peer Address:Port
tcp LISTEN 0 128 :::6666 :::* users:(("tnslsnr",4760,8))

We see something different here as there’s no mention of a local address in :::6666

With this configuration, I’m able to connect through any IP address, including the virtual IP

Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.78.104)(PORT=6666)))
OK (0 msec)
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.66.102)(PORT=6666)))
OK (10 msec)
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=6666)))
OK (10 msec)

(HOST=myhost)

I mentioned another host name which resolves to the IP address of the host interface (see the /etc/hosts above). It is not the hostname returned by $(hostname) but it resolve to same IP.

Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=VM104)(PORT=6666)))

The listener has resolved the address through /etc/hosts and then, because the IP matches the resolution of $(hostname), has used the $(hostname). We are then in the same situation as above where we can connect through any interface:

[oracle@VM104 tmp]$ ss -elpunt | grep -E "^Net|tnslsnr"
Netid State Recv-Q Send-Q Local Address:Port Peer Address:Port
tcp LISTEN 0 128 :::6666 :::* users:(("tnslsnr",4760,8))

(HOST=0.0.0.0)

Finally, when you want to listen on all interfaces, why not configure the host to 0.0.0.0

Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=VM104)(PORT=6666)))

We are again in the same situation here and the listener has replaced it with the hostname. This may be convenient when you want to use the same listener.ora for different hosts. However, as it finally show the hostname, better to avoid confusion and have it in the listener.ora

(HOST=VM104)(IP=FIRST)

This is the way to bypass the ‘listen on all interfaces’ rule, even when you resolve to the hostname.

Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.78.104)(PORT=6666)))

Because of (IP=FIRST) the listener listens to the first IP address returned by gethostbyname()

Conclusion

It is easy to know if the listener listens on one specific IP address, or on all interfaces. You get the hostname and the listener endpoints

hostname
lsnrctl status

If the ‘HOST=’ matches the hostname, then it listens to all interfaces. If the ‘HOST=’ mentions an IP address, then it listens on this IP only. If it mentions a name which is not the hostname, then maybe someone has changed the hostname after the listener was started?

The other way is to look at the socket information with:

netstat -elpunt
ss -elpunt

If you think that it is a security problem to listen to all interfaces, then you should understand that the listener is not a firewall. It is just a convenient way to route connections by service name to the right instance. But remember that you can even connect to the database without the listener (read https://amitzil.wordpress.com/2015/10/19/bypassing-the-listener/), just connecting to the dispatcher:

Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SID=CDB1))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=30229)))
OK (0 msec)

And this one listens to all interfaces:


[oracle@VM104 tmp]$ ss -elpunt | grep -E "(^Net|ora_d)"
Netid State Recv-Q Send-Q Local Address:Port Peer Address:Port
tcp LISTEN 0 128 :::30229 :::* users:(("ora_d000_cdb1",1362,8)) uid:54321 ino:20635 sk:ffff880117900800
tcp LISTEN 0 128 :::32316 :::* users:(("ora_d000_cdb2",1729,8)) uid:54321 ino:20958 sk:ffff880117900040

Security is done by firewall rules. Listener is there only to help, so keep it simple.

 

Cet article Listener and Virtual IP est apparu en premier sur Blog dbi services.

Twitter Chat Reveals – Is headless CMS signaling the end of WCM?

WebCenter Team - Tue, 2017-04-25 14:18

Last week, on April 20, @oraclewebcenter hosted a live Twitter Chat at #contentdgtl. The topic – Is headless CMS signaling the end of WCM?

Decoupled CMS architecture (aka “headless”) is rising in popularity in the development world. This model allows breakthrough user experiences, gives developers great flexibility to innovate, and helps site owners future-proof their builds by allowing them to refresh the design without re-implementing the whole CMS. With all this upside, it’s no wonder this type of build has gained serious traction.

With that in mind, the live Twitter discussion focused on the topic of headless CMS and whether companies need to be thinking about it. The Twitter Chat explored headless CMS vs. WCM and use cases of when it makes sense to use one or the other. Industry thought leaders including Melissa Webster from IDC, Dave Gray from Xplaner.com, numerous partners and more participated in this very engaging discussion. The interaction ranged from the benefits of headless CMS to both the developer and business, to things to watch for with headless CMS and ended with best practice recommendations for content production, management & delivery in a cloud world.

From serious musings to light hearted commentary (including this pic that Tanu Sood shared), the Twitter Chat proved to be a great meeting of minds.

Even if you participated, you may have missed portions of the live discussion so we have curated the chat here; it might be worth going back and following the discussion.

One of my personal favorites was a tweet from Carlos Picazo (@carlines) that said "in a few years, we will have even more connected than today and content is key, Internet of People!"

Catch the recap of the Twitter Chat and while you still can, feel free to search for the complete thread by searching on “#contentdgtl” on Twitter.

Archive: Is headless CMS signaling the end of WCM?

Picture Courtesy: https://t.co/jb7JDERk9i

Oracle Helps Transform Lead Generation with LinkedIn Matched Audiences

Oracle Press Releases - Tue, 2017-04-25 12:30
Press Release
Oracle Helps Transform Lead Generation with LinkedIn Matched Audiences Product integration between Oracle Marketing Cloud and LinkedIn Campaign Manager enables marketers to generate high-quality leads at scale, increase conversion rates and accelerate sales.

Modern Customer Experience 2017, Las Vegas —Apr 25, 2017

To help marketers generate high-quality leads at scale and maximize the ROI of lead generation campaigns, Oracle today announced a new product integration between Oracle Marketing Cloud and LinkedIn Campaign Manager - a new targeting capability within LinkedIn’s recently announced product, Matched Audiences. This new product integration enables Oracle Marketing Cloud customers to seamlessly integrate data from more than 467 million LinkedIn users into existing marketing campaigns to reach and engage their ideal buyers on the world’s largest professional social network.

Marketers need to be able to deliver personalized experiences at scale in order to increase conversion rates and accelerate sales. With the new product integration between Oracle Eloqua, part of the Oracle Marketing Cloud, and LinkedIn Campaign Manager, marketers now have the power to seamlessly nurture leads using LinkedIn Matched Audiences. The product integration enables marketers to personalize and orchestrate campaigns across multiple channels including email, websites and digital ads in order to engage the right audience at the right time in the buyer’s journey.

“At LinkedIn, we strive to equip B2B marketers with the tools and insights that they need to reach the audiences that matter most to their business,” said Russ Glass, vice president of product, LinkedIn Marketing Solutions. “Matched Audiences gets us closer to that goal by enabling us to give marketers custom ways to combine LinkedIn’s powerful professional data with their own first-party data. Our product integration with Oracle was key to helping make that happen for Oracle Eloqua customers.”

This integration also empowers marketers to enhance their Account Based Marketing (ABM) strategies. Marketers can leverage the powerful insights delivered by the new integration to help convert unknown prospects into known buyers, retarget buyers with relevant digital ads, and enrich buyer profiles and optimize digital ad spend on LinkedIn. This enables marketers to increase conversion rates and accelerate sales.

“We are focused on empowering marketers with the data they need to inform, measure and maximize the impact of marketing campaigns,” said Laura Ipsen, general manager and senior vice president, Oracle Marketing Cloud. “LinkedIn is the world’s largest professional network and by enabling marketers to seamlessly integrate data from more than 467 million LinkedIn users we are able to provide powerful customer insights that can transform lead generation campaigns. The new product integration between Oracle Eloqua and LinkedIn Campaign Manager can ultimately help marketers enhance the customer experience and increase revenues.” 

Oracle Marketing Cloud is part of Oracle CX Cloud Suite. Oracle CX Cloud Suite empowers organizations to take a smarter approach to customer experience management and business transformation initiatives. By providing a trusted business platform that connects data, experiences and outcomes, Oracle CX Cloud Suite helps customers reduce IT complexity, deliver innovative customer experiences and achieve predictable and tangible business results. The Oracle CX Cloud Suite includes Oracle Commerce Cloud, Oracle Marketing Cloud, Oracle Sales Cloud and Oracle Service Cloud.

Contact Info
Simon Jones
Public Relations for Oracle
+1.415.856.5155
sjones@blancandotus.com
About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit 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.

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.856.5155

Blue Microphones Turns Up the Volume with NetSuite

Oracle Press Releases - Tue, 2017-04-25 12:30
Press Release
Blue Microphones Turns Up the Volume with NetSuite Microphone Maker Gains Vital Business Agility for Innovation and Growth

SUITEWORLD 2017, LAS VEGAS, Nev.—Apr 25, 2017

Oracle NetSuite Global Business Unit (GBU), the industry’s leading provider of cloud financials / ERP, HR and omnichannel commerce software suites, today announced that Blue Microphones (www.bluemic.com), a leading designer and producer of premium microphones and sound recording equipment for audio professionals, musicians and consumers, has gained vital business agility with NetSuite’s unified cloud business management system. NetSuite allows Blue Microphones to focus on product innovation, scale into new markets, and challenge larger rivals in the competitive recording industry. To ensure agility for innovation and growth, the company replaced QuickBooks Enterprise with NetSuite to manage its end-to-end business operations including financials, fixed assets, demand planning, inventory management, bill of materials, work orders and assemblies, warehouse management, CRM, HR, and multi-currency transactions in the Canadian dollar and Euro. After a rapid three-month implementation, the company went live on NetSuite in July 2014.

Headquartered in Westlake, Calif., Blue Microphones was founded in 1995 by an American jazz musician and a recording engineer who designed high-quality studio microphones and pioneered the digital USB microphone – microphones that plug directly into a computer. Beginning in 2004, the company saw significant growth thanks to its Snowball, a USB mic built for use with Apple’s GarageBand recording software, and continued to develop a range of USB mics made vastly successful by the explosion of user generated content. Since then, Blue Microphones has continued to design and manufacture a full range of studio microphones, the world’s #1 USB mic line, and recently launched a lineup of premium headphones.

With 30 to 35 percent annual growth, the company was quickly realizing it needed new functionality its existing system couldn’t provide, including: multicurrency transactions; anywhere, anytime access to business data across the globe; integration with marketing and engineering systems for better collaboration; and integration to its shipping software.

“Replacing our entry-level accounting system with a unified cloud-based business management suite has made a huge difference in our business and has us well positioned for our next stage of growth,” said Bart Thielen, CFO and COO of Blue Microphones. “With NetSuite, we’re able to scale the business very quickly and our visibility is tremendously improved. We now have strong financial controls and a solid infrastructure with great agility to respond rapidly to changing market conditions.”

Leveraging the NetSuite SuiteCloud Development Platform, Blue Microphones was able to customize the NetSuite system to meet its business needs and industry specific requirements. The company was also able to integrate the Pacejet Enterprise Shipping Software with NetSuite seamlessly, allowing it to better manage millions of freight quotes and shipments with reduced costs and improved efficiency. Bidirectional EDI interface powered by the NetSuite SuiteCloud Development Platform enables Electronic Data Interchange to 15 different partners including large retailers like Best Buy, Apple and Amazon; which saves Blue Microphones up to 30 to 40 hours a week of manual order entry and invoicing and enables near 100 percent accuracy.

Blue Microphones’ IT modernization efforts have also attracted the notice of others. Most recently, the company was awarded the prestigious 2016 Manufacturing Leadership (ML) Award in the “Enterprise Leadership" category from Frost and Sullivan’s ML Council. The awards are given to companies and individuals that have undertaken breakthrough projects in manufacturing as determined by an expert panel of judges. Blue Microphones was recognized for its "IT Modernization Project,” which allowed the company to rapidly scale, while giving it the agility to adapt to changing market conditions.

As a result of its implementation of NetSuite, Blue Microphones has realized multiple benefits, including:

  • Improved IT and operational efficiency. As a pure cloud system, NetSuite spares Blue Microphones from the hassles of managing on-premise software and the hardware required to support it, including patches, upgrades and security. As a result of efficiencies gained, Blue Microphones can attribute avoiding the costs of hiring two full-time employees by converting to NetSuite, an annual savings of $80,000.
  • Improved inventory management. Third-party logistics partners in Amsterdam and Hong Kong are now able to access NetSuite through a portal to fulfill orders, improving accuracy and efficiency. Previously, Blue Microphones would scan documents and email them over as PDFs, a labor intensive, error-prone process. Additionally, the company has been able to setup a virtual warehouse for its marketing group, which sequesters key products for product reviews and key influencers like artists and producers.
  • Product improvements. Blue Microphones is now capturing customer feedback in the system, which can be shared directly with engineering and overseas manufacturers to improve the products.
  • Reduced manual entry. Workflow and scripting has saved up to 15 hours a month of manual entry for the sales department.
  • A flexible and powerful development platform. NetSuite’s SuiteCloud Development Platform provides flexibility for Blue Microphones to tailor the system and integrate with other third-party solutions to meet its unique business needs and industry-specific requirements.
  • Improved asset tracking. A new fixed assets interface saves significant time at both monthly and year-end audits. During the course of a year, the company estimates it is saving about 50 hours total.
About Oracle NetSuite Global Business Unit

Oracle NetSuite Global Business Unit pioneered the Cloud Computing revolution in 1998, establishing the world’s first company dedicated to delivering business applications over the internet. Today, Oracle NetSuite Global Business Unit provides a suite of cloud-based financials / Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries. For more information, please visit www.netsuite.com.

Follow Oracle NetSuite Global Business Unit’s Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit 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.

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. 

Pods Turns to NetSuite SuiteSuccess to Fuel Its Global Operation

Oracle Press Releases - Tue, 2017-04-25 12:15
Press Release
Pods Turns to NetSuite SuiteSuccess to Fuel Its Global Operation SuiteSuccess Engineers Customer Success – Readies PODS for Rapid Global Expansion

LAS VEGAS, Nev. —Apr 25, 2017

Oracle NetSuite Global Business Unit (GBU), the industry's leading provider of cloud financials / ERP, HR and omnichannel commerce software suites, today announced that PODS Enterprises, LLC, the leading provider of portable container-based moving and storage solutions, chose NetSuite SuiteSuccess to support its business expansion. PODS will be using NetSuite to manage mission-critical business processes including financials, inventory management, multi-subsidiary management for 16 subsidiaries and multi-currency management for the U.S., Canadian and Australian dollars. SuiteSuccess is the culmination of a multi-year transformation effort to combine the NetSuite unified suite, 20 years of industry leading practices, a new customer engagement model, and business optimization methods into a unified, industry cloud solution. SuiteSuccess is NetSuite’s new purpose-built, unified cloud solution tailored for each industry. 

“I was amazed how closely NetSuite worked with us to ensure we had good process alignment with the fewest possible gaps,” said Bill Tingle, CIO of PODS. “We need to get a system up and running quickly to meet our strategic objectives and SuiteSuccess seems to fit the bill perfectly.”

PODS transformed the moving business when it invented the concept of portable storage in 1998 and now counts a network of more than 170,000 PODS storage containers and 230 PODS Storage Centers in North America alone. In 2016, leadership reevaluated the business and IT strategy and determined the need to move onto a new software platform to support the company’s growth and development plans moving forward. After a rigorous evaluation process, PODS selected NetSuite OneWorld for its flexible platform, strong partner ecosystem and its commitment to customer success.

“Before we had even made the decision to purchase NetSuite, they had a detailed engagement plan with very specific steps on how we would implement the solution,” said Tingle. “We felt comfortable knowing we wouldn’t be starting from scratch and would have a robust solution with NetSuite’s years of experience baked into the product.”

PODS is using SuiteSuccess to ensure a successful deployment of NetSuite OneWorld across its 16 subsidiaries and a complex franchise model with 230 PODS Storage Centers. NetSuite OneWorld will give PODS a flexible, scalable system for growth. With support for 190 currencies, 20 languages, automated tax compliance in more than 100 countries, and transactions in more than 200 countries.

SuiteSuccess was engineered to solve unique industry challenges that historically have limited a company’s ability to grow, scale and adapt to change. Most ERP vendors have tried to solve the industry solution problem with templates, rapid implementation methodologies, and custom code. NetSuite took a holistic approach to the problem and productized domain knowledge, leading practices, KPI’s, and an agile approach to product adoption. The benefits of this are faster time to value, increased business efficiency, flexibility, and greater customer success.

For more information about SuiteSuccess, please visit:  http://www.netsuite.com/portal/services/suitesuccess.shtml

Other expected features and benefits include:

  • Rapid deployment. Backed by SuiteSuccess, PODS expects to launch NetSuite OneWorld in less than three months, a huge difference from its experience with the previous system that took nearly four years.
  • A powerful development platform. The SuiteCloud development platform provides unprecedented flexibility that enables businesses to tailor the system to meet their unique requirements and industry-specific needs.
  • A robust partner ecosystem. NetSuite’s wide array of partner solutions will allow PODS to extend NetSuite to meet its current and future business needs. PODS plans to leverage NetSuite’s comprehensive partner ecosystem for solutions in warehouse management, Electronic Data Interchange (EDI) integration and financial planning.
  • Centralized order and inventory management. NetSuite OneWorld can provide real-time inventory visibility across the business for better forecasting and optimization of more than 170,000 PODS containers moving throughout North America.
  • Built-in business intelligence. With NetSuite OneWorld, PODS will have real-time insights into key business performance indicators for a unified view of the organization and a single version of truth.
  • A highly scalable system for growth. NetSuite’s scalable infrastructure will enable PODS to easily expand to support growing business volumes.

Bill Tingle is sharing PODS’ story at SuiteWorld 2017, the number one cloud ERP event of the year, this year being held in Las Vegas from April 24-27. Watch all keynotes live here.

About PODS Enterprises, LLC
PODS® is a leader in the moving and storage industry providing both residential and commercial services in 46 U.S. states, Canada, Australia and the UK. Founded in 1998, PODS pioneered the portable moving and storage industry now preferred by many customers’ increasingly active and mobile lifestyles. To date, the PODS network has completed more than 700,000 long-distance moves, exceeded 3 million deliveries and has more than 170,000 PODS containers in service.

About Oracle NetSuite Global Business Unit  
Oracle NetSuite Global Business Unit pioneered the Cloud Computing revolution in 1998, establishing the world's first company dedicated to delivering business applications over the internet. Today, Oracle NetSuite Global Business Unit provides a suite of cloud-based financials / Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries. For more information, please visit www.netsuite.com.
 

Follow Oracle NetSuite Global Business Unit's Cloud blogFacebook page and @NetSuite Twitter handle for real-time updates.

About Oracle
Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit 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.

Smartsheet Realizes the Power of Unified Billing and Revenue Recognition with NetSuite

Oracle Press Releases - Tue, 2017-04-25 12:00
Press Release
Smartsheet Realizes the Power of Unified Billing and Revenue Recognition with NetSuite Enterprise Collaboration Software Leader Can Easily Adapt to Market Changes, New Business Models and New Revenue Recognition Standards

SUITEWORLD 2017, LAS VEGAS, Nev.—Apr 25, 2017

Oracle NetSuite Global Business Unit (GBU), the industry's leading provider of cloud financials / ERP, HR and omnichannel commerce software suites, today announced that Smartsheet, a leading provider of SaaS-based solutions for managing and automating collaborative work, has implemented NetSuite OneWorld to manage rapid growth. Smartsheet is leveraging NetSuite OneWorld to manage mission critical business processes including financials, billing, revenue recognition, analytics and multi-currency transactions in the Euro, yen, Pound and US, Australian and Canadian dollars. With NetSuite OneWorld, Smartsheet has a platform that is ready for next and provides the foundation to scale the business. As Smartsheet has evolved its business model, NetSuite’s SuiteBilling software is helping the company to manage recurring revenue processes from order to billing and revenue recognition with complete control and auditability for its software subscription business.

“Using a hairball of multiple point products, whether on-premise or in the cloud, is always a bad idea. But doing it in your financial system is downright reckless,” said Jason Maynard, SVP of Strategy and Marketing, NetSuite. “Smartsheet is an innovator in collaboration software and knew how to leverage NetSuite innovation to fuel their growth.”

Founded 11 years ago in Bellevue, Wash., Smartsheet began selling collaboration software for individuals and small teams but has grown rapidly as it began selling its product into large enterprises, including 50 percent of the Fortune 500, to help solve large, complex work management and project automation challenges. It has achieved more than 70 percent year-over-year revenue growth for the fifth consecutive year and currently serves more than 68,000 companies and 10 million users across 190 countries. Smartsheet’s prior accounting system couldn’t handle that growth, requiring extensive manual workarounds that were cumbersome and inefficient, including the physical entry of every invoice. Smartsheet knew that it needed a new platform that could manage all its critical business processes in one system while also providing the flexibility to scale rapidly with the company’s growth. After a rigorous evaluation of several applications, Smartsheet chose NetSuite OneWorld for its scalability, revenue recognition and international capabilities.

A key factor in Smartsheet’s decision was SuiteBilling, the industry’s first unified cloud-based order-to-billing-to revenue recognition solution. SuiteBilling enables businesses to adopt any business model from product-based, time- and services-based, through to usage- and subscription-based, or any combination of these without limit. In the future, Smartsheet plans to manage subscriptions for its enterprise customers while providing a self-service model for its smaller customers allowing them to sign up for a trial, pay with a credit card and establish a recurring billing account all from a single system.

“We needed a solution that could support significant growth in our primary segments—enterprise customers as well as SMBs where we leverage a self-service model—each of which has its own unique set of complexities,” said Mark Mader, Smartsheet CEO. “NetSuite was the only solution that offered us the ability to automate both the back office and customer-facing aspects across both these important segments of our business.”

After a four-month implementation, Smartsheet deployed NetSuite OneWorld, which supports 190 currencies, 20 languages, automated tax calculation and reporting in more than 100 countries, and support for customer transactions in more than 190 countries. NetSuite OneWorld supports Smartsheet’s growth by providing:

  • Scalability for growth. NetSuite OneWorld’s single cloud solution allows Smartsheet to quickly and easily; add functionality as the business evolves; quickly add offices as it expands with anywhere, anytime access.
  • Single source of truth. NetSuite’s unified billing and advanced revenue management system, synchronizes complex processes from order to billing to revenue recognition.
  • Real-time visibility. NetSuite OneWorld’s unified platform gives Smartsheet visibility across its operations with one single unified financial system of record, providing users with real-time information right at their fingertips.
  • Improved efficiency. NetSuite has automated numerous processes previously done manually, including processing of thousands of renewals at a time, saving significant time in order entry.
  • Robust customization and integration. NetSuite's SuiteCloud Developer Network (SDN) provides a platform for Smartsheet to customize the system to its specific needs and adapt as its business evolves. Customized business rule logic improves data quality while a planned integration with Salesforce.com will fully automate the quote-to-cash process for sales floor led deals.


Mark Mader will be sharing Smartsheet’s story at SuiteWorld 2017, the number one cloud ERP event of the year, this year being held in Las Vegas from April 24-27. Watch him and all other SuiteWorld 2017 keynotes live here.

About Oracle NetSuite Global Business Unit

Oracle NetSuite Global Business Unit pioneered the Cloud Computing revolution in 1998, establishing the world’s first company dedicated to delivering business applications over the internet. Today, Oracle NetSuite Global Business Unit provides a suite of cloud-based financials / Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries. For more information, please visit www.netsuite.com.

Follow Oracle NetSuite Global Business Unit’s Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit 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.

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. 

Ring Dials NetSuite to Fuel Growth

Oracle Press Releases - Tue, 2017-04-25 11:45
Press Release
Ring Dials NetSuite to Fuel Growth Outdoor Home Security Innovator Leverages NetSuite to Scale Global Business Operations

SUITEWORLD 2017, LAS VEGAS, Nev.—Apr 25, 2017

Oracle NetSuite Global Business Unit (GBU), the industry's leading provider of cloud financials / ERP, HR and omnichannel commerce software suites, today announced that Ring, a leader in outdoor home security, has implemented NetSuite to fuel its rapid growth, which took it from startup to 1,000 team members in less than three years. Ring is using NetSuite for financial management and reporting with plans to significantly extend the NetSuite platform to other areas of the business as it continues to extend its business model beyond doorbells, to services and subscriptions. With NetSuite, Ring has gained efficiencies and real-time visibility with a unified platform that is next ready. NetSuite enables Ring to grow, scale and adapt its business model as Ring’s business expands and evolves.

With a mission to reduce crime in neighborhoods, Ring has revolutionized outdoor home security by building smart doorbells and outdoor cameras designed to proactively monitor your home. Initially founded as DoorBot, Ring got a significant boost when CEO and Chief Inventor Jamie Siminoff appeared on ABC’s “Shark Tank” with the smart doorbell in September 2013. It has since expanded its product line and is building a “Ring of Security” around your home with data services and digital neighborhood watches. Additionally, Ring has received $209 million in investment, reached over 1,000,000 users and has expanded its footprint in retail and is now available in over 15,000 stores globally. Initially, Ring relied on an outsourced accounting firm for basic general ledger and journal entries, to manage its financial processes with reporting done in Excel and online spreadsheets. Understanding that the company’s growth trajectory demanded more comprehensive solution, Ring evaluated several software packages on the market including Microsoft Dynamics, before selecting NetSuite.

“When you grow as fast as we’ve grown, one of the biggest challenges is breaking older systems and having to move to new things,” said Siminoff. “NetSuite gives us a platform that allows us to grow from zero to infinity. It takes away those concerns and means resources can be directed to sales and business development.”

“We are honored to partner with a mission-driven business like Ring as they transform communities and help make neighborhoods safer,” said Jason Maynard, SVP of Strategy and Marketing, Oracle NetSuite GBU. “Empowering entrepreneurial companies to scale and achieve their vision is NetSuite’s purpose.”

While still a young and fast-growing business, Ring has complex needs including a B2C website and B2B relationships with retailers like Costco, Best Buy and Home Depot. Ring is confident that the advanced revenue recognition features in NetSuite can allow it to sell, bill and recognize its revenue as it continues to transform its business and meet the needs of the modern customer. With NetSuite, Ring has streamlined financial processes and gained operational efficiency with a roadmap for future growth.

Since implementing NetSuite, Ring has gained the following benefits:

  • A flexible and agile platform. The NetSuite SuiteCloud Platform easily enables the company to customize NetSuite to meets its current and future business requirements and to integrate with other third-party solutions.
  • Real-time visibility. One single, unified financial system of record and financial reporting across the entire organization has created efficiencies by automating cumbersome manual processes.
  • Significant savings in IT costs and complexity. NetSuite's proven, securely featured cloud solution eliminates the hassles of managing, maintaining and upgrading business applications and offers significant time and cost savings.
  • Anytime, anywhere access. For a company built around accessing a video doorbell from a smartphone, NetSuite’s mobile capabilities enable staff to access the system anywhere there is an internet connection.
  • Scalability for growth. With plans to extend the NetSuite platform to adopt advanced revenue recognition, CRM and ecommerce, plus inventory management for its warehouse and fulfillment for its retail partners, Ring can continue to grow and adapt its business on a single platform.

Jamie Siminoff will be sharing Ring’s story at SuiteWorld 2017, the number one cloud ERP event of the year, this year being held in Las Vegas from April 24-27. Watch him and all SuiteWorld 2017 keynotes live here.

About Ring

Ring's mission is to reduce crime in neighborhoods and empower consumers by creating a Ring of Security around homes and communities with its suite of smart home security products: Ring Video Doorbell, Ring Video Doorbell Pro (HomeKit-enabled), Ring Stick Up Cam and the new Ring Floodlight Cam. With these security devices, Ring has created the neighborhood watch for the digital age and continues to keep homes around the world safe. For more information, visit www.ring.com. With Ring, you’re always home. To learn more, please visit https://ring.com.

About Oracle NetSuite Global Business Unit

Oracle NetSuite Global Business Unit pioneered the Cloud Computing revolution in 1998, establishing the world’s first company dedicated to delivering business applications over the internet. Today, Oracle NetSuite Global Business Unit provides a suite of cloud-based financials / Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries. For more information, please visit www.netsuite.com.

Follow Oracle NetSuite Global Business Unit’s Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit 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.

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. 

NetSuite Announces SuiteSuccess: The First Unified Industry Cloud Solution

Oracle Press Releases - Tue, 2017-04-25 11:30
Press Release
NetSuite Announces SuiteSuccess: The First Unified Industry Cloud Solution SuiteSuccess Transforms the Way NetSuite Builds, Sells, Delivers and Supports Industry Solutions
SuiteSuccess Empowers Customers to Be Ready for What’s Next

SUITEWORLD 2017, LAS VEGAS, Nev.—Apr 25, 2017

Oracle NetSuite Global Business Unit, the world’s leading provider of cloud-based financials / ERP, HR and omnichannel commerce software suites, today announced SuiteSuccess, the first unified industry cloud solution. NetSuite has delivered 12 SuiteSuccess editions for the following eight industries:

  • Advertising, media, publishing
  • Financial technology
  • Manufacturing
  • Nonprofit
  • Retail
  • Service-based businesses
  • Software/internet
  • Wholesale distribution

SuiteSuccess is the culmination of a multi-year transformation effort to combine the NetSuite unified suite, 20 years of industry leading practices, a new customer engagement model, and business optimization methods into a unified, industry cloud solution. SuiteSuccess was engineered to solve unique industry challenges that historically have limited a company’s ability to grow, scale and adapt to change. Most ERP vendors have tried to solve the industry solution problem with templates, rapid implementation methodologies, and custom code. NetSuite took a holistic approach to the problem and productized domain knowledge, leading practices, KPI’s, and an agile approach to product adoption. The benefits of this are faster time to value, increased business efficiency, flexibility, and greater customer success.

Within each industry offering, NetSuite has built unique micro-vertical solutions to address specific market needs. SuiteSuccess has over 300 customers and is available now, expanding globally into more industries and to current NetSuite customers over the course of this year.

“SuiteSuccess is what is next for NetSuite and our customers,” said Jim McGeever, Executive Vice President, Oracle NetSuite Global Business Unit. “When we started SuiteSuccess, we had high expectations, but the results our customers have achieved have gone way beyond our wildest dreams.”

“I was amazed, not only with how fast the project went, but how closely NetSuite worked with us,” said Bill Tingle, CIO of PODS. “We needed to get a system up and running quickly to keep up with our growth and SuiteSuccess fit the bill perfectly.”

The four key pillars of SuiteSuccess are:

  • BUILD. A complete suite to support the modern business including ERP, CRM, PSA, omnichannel commerce, HR, and Business Intelligence (BI) built on the NetSuite cloud platform, continually updated with leading edge capabilities and technologies to support all eight industries.
  • ENGAGE. Leading practices for each industry and role including workflows, KPI’s, reports, dashboards and metrics, with the flexibility to personalize on the NetSuite platform from the initial sales contact to ongoing support. With these leading practices, value is added at each stage of the engagement.
  • CONSUME. Intelligent staged approach via NetSuite’s industry ‘stairway’ allows companies to consume capabilities based on their business needs. Re-imagined consumption model drives faster time to value, better ROI and greater user adoption. Companies can now go from zero to cloud in 100 days.
  • OPTIMIZE. Customers benefit from continuous engagement, updated leading practices, new feature releases, value added SuiteCloud partners, and movement up the stairway. Customers also are always on the latest release.

DirectScale, a software solution designed to seamlessly meet the needs of the direct and social sales industry, implemented NetSuite OneWorld in November of 2016 with SuiteSuccess.

“NetSuite had customers in our industry that were dealing with the same issues as us. Setting up contracts, revenue recognition rules, revenue schedules. Choosing NetSuite, it was a match made in heaven,” said Ansen Hatch, Corporate Controller, DirectScale. “We know that NetSuite can grow with us as quickly as we can grow.”

Sourcingpartner, a leading provider of complete end-to-end sourcing solutions from product concept to after care support, implemented NetSuite in July 2016 with SuiteSuccess.

“Everything went much smoother than our Microsoft implementation. I’ve had nothing but good comments from everyone involved and I’m so glad we switched,” said Richard Gardner, Director for Customer Service, Sourcingpartner.

Precision Disposables, a wholesale distributor of high quality, cost efficient, medical products, implemented NetSuite in January 2017 with SuiteSuccess.

“I have 15 plus years of experience in all the major ERP platforms, including SAP, and I’ve been through six major implementations. This was by far the best,” said Bruce Capagli, COO, Precision Disposables.

To learn more about SuiteSuccess, please visit www.netsuite.com/suitesuccess.

About Oracle NetSuite Global Business Unit

Oracle NetSuite Global Business Unit pioneered the Cloud Computing revolution in 1998, establishing the world’s first company dedicated to delivering business applications over the internet. Today, Oracle NetSuite Global Business Unit provides a suite of cloud-based financials / Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries. For more information, please visit www.netsuite.com.

Follow Oracle NetSuite Global Business Unit’s Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit 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.

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. 

NetSuite Unveils SuitePeople, the Most Unified and Flexible Cloud Core HR Offering

Oracle Press Releases - Tue, 2017-04-25 11:15
Press Release
NetSuite Unveils SuitePeople, the Most Unified and Flexible Cloud Core HR Offering Addition of Core HR Unifies Financial, Customer, Product, Services and People Data in NetSuite

SUITEWORLD 2017, LAS VEGAS, Nev.—Apr 25, 2017

Oracle NetSuite Global Business Unit (GBU), the industry’s leading provider of cloud financials / ERP, HR and omnichannel commerce software suites, today announced SuitePeople, a new core human resources (HR) offering natively built on NetSuite’s unified cloud suite. NetSuite is the first and only cloud ERP suite to give businesses a single platform to manage mission critical business processes across ERP, Customer Relationship Management (CRM), Professional Services Automation (PSA), omnichannel commerce and now HR.

Traditionally, businesses have had to manage core HR processes in separate modules, disparate systems, or worse, in spreadsheets. Growing businesses can’t afford the cost, time and risk associated with manual workarounds, complex integrations or siloed data. Unlike legacy HRIS solutions, SuitePeople helps people information actionable throughout the organization from a single suite.

“Since its inception, NetSuite has believed that the best way to run a business is with a unified suite. Today, we are incredibly excited to complete that vision with the launch of SuitePeople,” said Jim McGeever, Executive Vice President of the Oracle NetSuite Global Business Unit. “NetSuite has always delivered applications designed to run a complete business not just a department. And that same philosophy was built into the core of SuitePeople, the most unified flexible core HR offering ever available.”

“Having HR data available in NetSuite has transformed how we manage, train and retain our most valuable asset—our people,” said Noah Finn, Managing Partner at Finn Partners, a SuitePeople customer. “We’ve already seen significant business benefits and have only just scratched the surface of what we can do with all of our information in one central repository.”

“Successful organizations seek employee engagement solutions to ensure that their people are empowered and motivated. These solutions must enable everyone from the shop floor to the top floor,” said R “Ray” Wang, Principal Analyst and CEO of Constellation Research, Inc.

SuitePeople weaves people data throughout the suite, giving businesses complete control over their core HR processes. SuitePeople help enable employees to request time off, access employee directories and organizational charts, monitor upcoming vacation schedules and new hires or publicly recognize good work. SuitePeople help empower managers and HR professionals to streamline employee information, new hires, employee onboarding, promotions and compensation changes, all from a single suite.

SuitePeople plans to provide:

  • Core HR Capabilities. Native organization design, job and position management, workflows and  compliance management, all powered by effective-dated employee master data, providing HR with the systems they need to run a best-in-class operation.
  • HR Analytics. With pre-built reports and dashboards focused on key people metrics and compliance, including a new Chief People Officer dashboard, SuitePeople gives employees the data they need, right at their fingertips.
  • Employee Engagement. Kudos help allow all employees to recognize those co-workers who have helped drive the business forward, vital in today’s world of distributed workforces.
  • HR compliance. Built in human resources reports, searches and notifications are paired with tailored compliance features to ensure regulatory requirements are easily met and filing deadlines aren’t missed.
  • Unified access. With NetSuite’s unified data model, people information can be seamlessly analyzed from a single application suite. From HR to finance, services to the shop floor and the warehouse, the suite wins.
  • Global reach. With the NetSuite OneWorld supporting 190 currencies, 20 languages, automated tax calculation and reporting in more than 100 countries, and customer transactions in more than 200 countries, fast growing businesses know they can expand abroad and manage a global workforce.
  • Flexibility. Built on the flexible SuiteCloud platform, SuitePeople help allow customers and partners to configure workflows and forms to meet their unique needs without worrying about upgrades.
  • People security. Sophisticated role-based security features help allow executives, managers, supervisors and employees to simultaneously view information based on their operational and management role. Supporting both each other and their teams while safeguarding sensitive data.
  • Unmatched ease of use. Built within NetSuite’s intuitive user interface, SuitePeople can give employees a familiar experience that speeds adoption and training.

“Systems are the backbone of your business, but the heartbeat is your people,” said Joseph Fung, VP of Product Development at NetSuite. “With SuitePeople, businesses can achieve a more engaged workforce, improved operational efficiency, and timely strategic decision making. And best of all, because it is part of the unified suite, you can now manage and engage a global workforce better than ever.”

About Oracle NetSuite Global Business Unit

Oracle NetSuite Global Business Unit pioneered the Cloud Computing revolution in 1998, establishing the world’s first company dedicated to delivering business applications over the internet. Today, Oracle NetSuite Global Business Unit provides a suite of cloud-based financials / Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries. For more information, please visit www.netsuite.com.

Follow Oracle NetSuite Global Business Unit’s Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit 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.

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. 

NetSuite Announces Massive Global Expansion Initiatives

Oracle Press Releases - Tue, 2017-04-25 11:00
Press Release
NetSuite Announces Massive Global Expansion Initiatives Launching More Data Centers, More Field Offices, More Development Centers, More International Product Functionality and a Broader Partner Network

SUITEWORLD 2017, LAS VEGAS, Nev.—Apr 25, 2017

Oracle NetSuite Global Business Unit, the industry's leading provider of cloud financials / ERP, HR and omnichannel commerce software suites, today announced a massive expansion plan to accelerate its international growth. NetSuite customers will benefit from Oracle’s vast global scale and resources. The expansion initiatives will enable Oracle NetSuite Global Business Unit to launch more data centers, more field offices and more development centers globally, which will help to bring the leading cloud ERP suite to more organizations around the world.

“Leveraging Oracle’s global scale, we are able to massively accelerate NetSuite’s vision of bringing a single unified suite to companies all over the world,” said Jim McGeever, Executive Vice President of Oracle NetSuite Global Business Unit. “Oracle’s technology infrastructure and global reach enables us to help ensure customer success no matter where they are located in the world.”

“Oracle’s increased investment in all areas of the NetSuite product and operations offers more opportunities to customers, particularly growing international businesses like PageGroup,” said Mark Hearn, Finance Director of recruitment company PageGroup. “As we continue our global roll-out of NetSuite OneWorld, I am reassured by the even greater capabilities and resources behind the product. A commitment to strong and sustained investment in OneWorld functionality will enable international companies like us to continue to grow with NetSuite in the future.”

Adding Oracle’s global resources to NetSuite’s existing global footprint provides rapid entry and expansion into new markets across three key areas:

  • Data Centers. Oracle NetSuite Global Business Unit plans to more than double its data center footprint from five data centers globally to 11. NetSuite currently operates five data centers, three in North America, one in Amsterdam, Netherlands and one in Dublin, Ireland. NetSuite expects to add a fourth North American data center in Chicago. As part of the global expansion plans, NetSuite will leverage existing Oracle data centers in Europe and Asia. In Europe, NetSuite is scheduled to open a data center in Frankfurt, Germany to remedy the lack of modern cloud computing offerings in the country. In Asia Pacific, NetSuite plans to initially launch facilities in Australia and Singapore, followed by Japan and China. The addition of Oracle data centers to NetSuite’s operations will provide even greater security, redundancy, performance and scalability for new and existing customers across the globe.
  • Field offices. NetSuite expects to double its global presence, expanding from offices in 10 countries to 23 spread across the globe. The addition of Oracle’s field offices significantly increases NetSuite’s ability to meet the rising demand for cloud ERP around the world. NetSuite is establishing a new presence in Argentina, Brazil, Colombia, Chile, Mexico, France, Germany, Sweden, Dubai, China, India, Malaysia and New Zealand. In addition, NetSuite is expanding headcount in existing field offices by over 50 percent to provide better resources for customer demand.
  • Development centers. Oracle NetSuite Global Business Unit is leveraging existing Oracle development centers across India, China and Japan. The development centers will be able to accelerate the development of international, regional and local features and functionality within NetSuite OneWorld.
About Oracle NetSuite Global Business Unit

Oracle NetSuite Global Business Unit pioneered the Cloud Computing revolution in 1998, establishing the world’s first company dedicated to delivering business applications over the internet. Today, Oracle NetSuite Global Business Unit provides a suite of cloud-based financials / Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries. For more information, please visit www.netsuite.com.

Follow Oracle NetSuite Global Business Unit’s Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit 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.

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. 

Oracle Unified Auditing Performance Issues and 12.2 Improvements

For those of you using and/or considering Unified Auditing, in case you might have missed, Oracle has made significant changes to Unified Auditing in 12.2. Unified Auditing, new in Oracle 12c, represents a complete rewrite of how native database auditing works - see the links below for Integrigy research on Unified Auditing.

With Oracle 12.1, when using Unified Auditing, reads of the UNIFIED_AUDIT_TRAIL view were not performant. With Oracle 12.2, a new relational partitioned table (AUDSYS.AUD$UNIFIED) is created to solve the performance issue, and a patch (22782757) has been issued to backport the fix to 12.1.

For 12.1 clients using Unified Auditing, the patch and/or the workaround should be a high priority consideration.

Thank you to Mark Dietrich for pointing out the 12.1 patch.

If you have any questions, please contact us at info@integrigy.com

-Michael Miller, CISSP-ISSMP, CCSP, CCSK

References
 
 
 
 
 
 
Auditing, Oracle Database
Categories: APPS Blogs, Security Blogs

Does the wal segment size matter in PostgreSQL?

Yann Neuhaus - Tue, 2017-04-25 02:39

In PostgreSQL you configure the size of the wal (write ahead log) segments when you compile from source. If you use an installer or if you use the packages provided by your OS distribution the size of the wal segments is usually 16MB. Although 16MB seems very low you don’t need to worry about that in most of the cases, it just works fine. However there are cases where you might want to adjust this, e.g. when you have an application that generates thousands of transactions in a very short time and therefore forces PostgreSQL to generate huge amounts of wal segments. In this post we’ll look at a specific case: Usually you want to archive the wal segments for being able to do point in time recovery in case your severs crashes for some reason. Does the size of the wal segments matter for archiving?

Archiving of wal segments in PostgreSQL is done by specifying an archive_command. Whatever you put there will be executed by PostgreSQL once a new wal segment is created. Usually you’ll find something like this in archive_command (from the documentation):

archive_command = 'test ! -f /mnt/server/archivedir/%f && cp %p /mnt/server/archivedir/%f'  # Unix
archive_command = 'copy "%p" "C:\\server\\archivedir\\%f"'  # Windows

Or something like this:

archive_command = 'rsync -a %p postgres@[SOME_OTHER_HOST]:/path/to/wal_archive/%f'

Or:

archive_command ='scp %p postgres@[SOME_OTHER_HOST]:/path/to/wal_archive/%f'

Lets test how the size of wal segments impact the three ways of archiving outlined above. To begin with lets create 100 files each 16MB (the same as the default wal segment size in PostgreSQL) and 25 files 64MB each:

rm -rf /var/tmp/test16mb
mkdir /var/tmp/test16mb
for i in {1..100}; do
   dd if=/dev/zero of=/var/tmp/test16mb/${i} bs=1M count=16
done
ls -la /var/tmp/test16mb
rm -rf /var/tmp/test64mb
mkdir /var/tmp/test64mb
for i in {1..25}; do
   dd if=/dev/zero of=/var/tmp/test64mb/${i} bs=1M count=64
done
ls -la /var/tmp/test64mb
du -sh /var/tmp/test16mb
du -sh /var/tmp/test64mb

This will give us a total size of 1.6GB for each of the wal sizes (16MB and 64MB). Lets start by testing the “cp” way:

echo 3 > /proc/sys/vm/drop_caches
mkdir -p /var/tmp/target
rm -rf /var/tmp/target/*
time for i in `ls /var/tmp/test16mb`; do
    cp /var/tmp/test16mb/${i} /var/tmp/target/
done

My result (on a VM local on my notebook):

real	0m17.444s
user	0m0.275s
sys	0m8.569s

The same test for the 64MB files:

echo 3 > /proc/sys/vm/drop_caches
mkdir -p /var/tmp/target
rm -rf /var/tmp/target/*
time for i in `ls /var/tmp/test64mb`; do
    cp /var/tmp/test16mb/${i} /var/tmp/target/
done

It is almost 3 times as fast to copy the large files than to copy the smaller files:

real	0m5.365s
user	0m0.065s
sys	0m1.835s

Of course, for production systems, you would copy the files not locally but rather to e.g. NFS mount and then the numbers will change.

What are the numbers for scp? For the smaller files:

echo 3 > /proc/sys/vm/drop_caches
mkdir -p /var/tmp/target
rm -rf /var/tmp/target/*
time for i in `ls /var/tmp/test16mb`; do
    scp /var/tmp/test16mb/${i} root@localhost:/var/tmp/target/
done

The result:

real	2m51.708s
user	0m14.136s
sys	0m35.292s

Quite a huge overhead. What is the result with the 64MB files?:

echo 3 > /proc/sys/vm/drop_caches
mkdir -p /var/tmp/target
rm -rf /var/tmp/target/*
time for i in `ls /var/tmp/test64mb`; do
    scp /var/tmp/test64mb/${i} root@localhost:/var/tmp/target/
done

Approximately double as fast:

real	1m23.326s
user	0m10.353s
sys	0m30.814s

And finally rsync, for the smaller files:

echo 3 > /proc/sys/vm/drop_caches
mkdir -p /var/tmp/target
rm -rf /var/tmp/target/*
time for i in `ls /var/tmp/test16mb`; do
    rsync -a /var/tmp/test16mb/${i} root@localhost:/var/tmp/target/${i}
done

The result:

real	0m51.624s
user	0m4.488s
sys	0m10.247s

For the larger ones:

echo 3 > /proc/sys/vm/drop_caches
mkdir -p /var/tmp/target
rm -rf /var/tmp/target/*
time for i in `ls /var/tmp/test64mb`; do
    rsync -a /var/tmp/test64mb/${i} root@localhost:/var/tmp/target/${i}
done

The result:

real	0m34.342s
user	0m3.623s
sys	0m9.685s

Conclusion: When you have applications with high transaction rates it can make sense to increase the default wal segment size as archiving will usually be much faster when you use bigger segments. Of course you’ll need to test this on your specific hardware and for your specific workload. In a next post we’ll look at how bigger segments affect performance of PostgreSQL.

 

Cet article Does the wal segment size matter in PostgreSQL? est apparu en premier sur Blog dbi services.

Pages

Subscribe to Oracle FAQ aggregator