Feed aggregator

Best indexing for LEAD / LAG analytic functions

Tom Kyte - Tue, 2016-10-04 15:26
Hi, I was wondering which is the best index structure you can issue on a table in order to get LEAD / LAG functions perform at their best. An example. <code> CREATE TABLE DWH1_PLF.TEST ( COD_SAP VARCHAR2( 10 CHAR ), PLAFOND ...
Categories: DBA Blogs

offline elaboration

Tom Kyte - Tue, 2016-10-04 15:26
Hi, I've a high-level question: i've a huge events table written by an external program and i want make a off-line elaboration for each modification affected by the table (insert, delete and update). the best idea that's come to my mind is crea...
Categories: DBA Blogs

ODI julian (decimal) to date

Tom Kyte - Tue, 2016-10-04 15:26
Hi, i need to convert a julin number in 'my_fiel' ODI enviroment I've in source DECIMAL >>> target DATE. i've tryed many query but i'don't to got fix my problem. select to_date(to_char(s'MyField','J'),'yyyy-mm-dd') from dual can yo...
Categories: DBA Blogs

DBA definition

Tom Kyte - Tue, 2016-10-04 15:26
Hi Team according to you, what main difference between "DBA Production" and "DBA application" ? what are the main (shortly described) tasks for each? for instance is backups, rman, export/import are related to mainly Production DBA ? and Tu...
Categories: DBA Blogs

Extra comma in the heading of my csv

Tom Kyte - Tue, 2016-10-04 15:26
Hello Tom, I have a plsql block that writes the records from a table into mulitple csv's. It is based on a condition(code) and if the csv has got more than 500,000 records then it will spool to another csv. The question is my first CSV has got...
Categories: DBA Blogs

Explore more about 12c Multitenant with useful MOS Docs

Syed Jaffar - Tue, 2016-10-04 12:03
As part of an ongoing Exadata migration assignment, we have been exploring Oracle 12c multitenant capabilities a lot. I would like to share here some of selected useful MOS Doc about 12c multitenant concepts:

Below docs explains most of the 12c multitenant concepts:

  • Initialization parameters in a Multitenant database - Facts and additional information (Doc ID 2101596.1)
  • Initialization parameters in a Multitenant database - FAQ and Examples (Doc ID 2101638.1)
  • Oracle Multitenant Option - 12c : Frequently Asked Questions (Doc ID 1511619.1)
  • 12c Multitenant Container Databases (CDB) and Pluggable Databases (PDB) Character set restrictions / ORA-65116/65119: incompatible database/national character set ( Character set mismatch: PDB character set CDB character set ) (Doc ID 1968706.1)
  • How to Restore - Dropped Pluggable database (PDB) in Multitenant (Doc ID 2034953.1)
  • Script For Getting Complete Basic Information about configured CDB and PDB in Oracle Database Multitenant 12c (Doc ID 2012221.1)
  • Difference Between Major Components of Traditional Databases and Multitenant Databases CDB/PDB Introduced in Version 12c (Doc ID 2013529.1)
  • How to set a Pluggable Database to have a Different Time Zone to its own CDB (Doc ID 2127835.1)
  • Where Manageability Data is Stored in 12c Multi-tenant (CDB) database (Doc ID 1586256.1)
  • Master Note for the Oracle Multitenant Option (Doc ID 1519699.1)


Below notes outlines guideline to manage 12c Multitenant Container Database while Oracle Data Guard configuring is in-place:

  • Step by Step Examples of Migrating non-CDBs and PDBs Using ASM for File Storage (Doc ID 1576755.1)
  • Making Use Deferred PDB Recovery and the STANDBYS=NONE Feature with Oracle Multitenant (Doc ID 1916648.1)
  • Data Guard Impact on Oracle Multitenant Environments (Doc ID 2049127.1)
  • PDB Failover in a Data Guard environment: Unplugging a Single Failed PDB from a Standby Database and Plugging into a New Container (Doc ID 2088201.1)

Oracle Database 12.2.0.1 – Generating JSON in the Database using SQL/JSON operators

Marco Gralike - Tue, 2016-10-04 11:08
Oracle 12.2 is available, although still only in the Oracle Cloud via Oracle’s Exadata Express…

Apache Cassandra overview

Yann Neuhaus - Tue, 2016-10-04 08:20

Apache Cassandra is one of the most popular NoSQL database http://db-engines.com/en/ranking. It is used by many big company as Facebook, Netflix and many others. Initially the project was initiated by Facebook. In combination of Google BigTable and Amazon DynamoDB, they developed Cassandra. Actually, Cassandra is developed and maintained by the Apache foundation for the community version and by DataStax for the enterprise and commercial version.

Cassandra_history

Architecture

Cassandra has a master-less architecture. A cluster is represented as a ring. It’s a peer-to-peer cluster, with no single point of failure.

Cassandra key features:

  • Distributed
  • Decentralized
  • Replicated
  • Scalable
  • Fault-tolerant
  • Tuneable consistency level
  • No Single Point of Failure
  • High Available
  • Multi data center

Cassandra_RIng2

Any server nodes can accept write or read queries from clients. Every server is equal.

Cassandra use the Gossip protocol for internode communication within the cluster. The Gossip allows the exchanges of information between cluster nodes, as the status. Each cluster nodes send it status every second to three other node in the ring. A gossip message contain a version and in case of conflict the older version is overwritten.

A Partitioned Row Store

Because C* is a NoSQL database, and in the “NoSQL world” no strict standards are defined, there is a lot of misunderstanding around the Cassandra data model. Currently, C* is defined as a column-store oriented DBMS, but there is a big confusion on this definition.

To define properly, the Cassandra data model you have to decompose it. The picture below will help you to understand the data objects composition.

thinkmap

Cassandra data model is organized into rows of multiple columns/values pairs. Each row is uniquely identifiable by a key, the Row Key. Rows group columns and super columns. Column is the most basic unit of the data model. All columns are sorted by column key name, and all row key are sorted by row key.

Each row key, are stored into tables or column-family and both are encapsulate into Keyspaces. Below a representation of the complete Cassandra data model.

Cassandra_dataModel

Finally, Apache C* can be defined as a Partitioned row store database.

 

How data is distributed

Cassandra use a partitioner (internal component) to distribute data across cluster nodes. A partitioner determines where each piece of data have to be stored. The partitioning process is completely automatic and transparent.

Basically the partitioner is a hash function and compute a token for each partition key (Partition Key = Row Key). Depending on the partitioning strategy, each node of the cluster is responsible of a token. Below a picture of the partitioning process.

Cassandra_Partitioning

 

Three partitioning strategy are available:

  • Murmur3Partitioner
  • RandomPartitioner
  • ByteOrderedPartitioner

 

Replication

Cassandra can stores multiple copy of data on multiple nodes in order to ensure high availability and fault tolerance. Two important concepts are used for C* replication.

Replication strategy: determines in which node data is placed

Replication factor: determines the number of nodes where data is placed. A replication factor of 1 means that the data is replicated one time in one node.

The client connect to any node in the ring. This node became the coordinator, then the coordinator determines where the data must be stored. Finally, the data is replicated from one node to another in the sense of a clock hand.

Cassandra_replication

 

 

A quick overview of Cassandra main concepts has been done in this post in order to understand more precisely how Apache Cassandra works. Of course Cassandra concepts are more complex and will be described in future blog posts.

 

Cet article Apache Cassandra overview est apparu en premier sur Blog dbi services.

Use WLST to test all your datasources

Darwin IT - Tue, 2016-10-04 07:10
To day I had some problems with deploying my composite to the server of my current customer. Apparently the Server had some problems with datasources. But since there are many I did not feel much for checking them one by one with the console. Using Google I got the following examples

Thus I had to combine those two, sauce it with my own way of wlst-scripting (see my other blog entries). Also I want a tabular form, that got me into troubles with printing the result of the testPool() method. But I came up with the following script, testDS.py:
#############################################################################
# Test Datasources on a domain
#
# @author Martien van den Akker, Darwin-IT Professionals
# @version 2.1, 2016-10-04
#
#############################################################################
# Modify these values as necessary
import sys, traceback
scriptName = sys.argv[0]
#
#
lineSeperator='__________________________________________________________________________________'
#
#
def usage():
print 'Call script as: '
print 'Windows: wlst.cmd '+scriptName+' -loadProperties localhost.properties'
print 'Linux: wlst.sh '+scriptName+' -loadProperties environment.properties'
print 'Property file should contain the following properties: '
print "adminUrl=hhs-sbm3015:7001"
print "adminUser=weblogic"
print "adminPwd=welcome1"
#
#
def connectToadminServer(adminUrl, adminServerName):
print(lineSeperator)
print('Try to connect to the AdminServer')
try:
connect(userConfigFile=usrCfgFile, userKeyFile=usrKeyFile, url=adminUrl)
except NameError, e:
print('Apparently user config properties usrCfgFile and usrKeyFile not set.')
print('Try to connect to the AdminServer adminUser and adminPwd properties')
connect(adminUser, adminPwd, adminUrl)
#
#
def main():
try:
pad=' '
print(lineSeperator)
print('Check datasources for domain')
print(lineSeperator)
print ('Connect to the AdminServer: '+adminServerName)
connectToadminServer(adminUrl, adminServerName)
print(lineSeperator)
allServers=domainRuntimeService.getServerRuntimes();
if (len(allServers) > 0):
for tempServer in allServers:
jdbcServiceRT = tempServer.getJDBCServiceRuntime();
dataSources = jdbcServiceRT.getJDBCDataSourceRuntimeMBeans();
print('\nServer '+tempServer.getName())
if (len(dataSources) > 0):
print('Datasource '[:30]+'\tState\tTest')
for dataSource in dataSources:
testPool = dataSource.testPool()
dataSourceName = dataSource.getName()+pad
dataSourceNamePad=dataSourceName[:30]
if (testPool == None):
print dataSourceNamePad+'\t'+dataSource.getState()+'\tOK'
else:
print dataSourceNamePad+'\t'+dataSource.getState()+'\tFailure: '
print testPool
print(lineSeperator)
print('Done...')
print(lineSeperator)
except NameError, e:
print('Apparently properties not set.')
print "Please check the property: ", sys.exc_info()[0], sys.exc_info()[1]
usage()
except:
apply(traceback.print_exception, sys.exc_info())
exit(exitcode=1)
#
main();

Of course it's easy to extent the table with properties from the monitor script in WebLogic DataSource Monitoring Using WLST.

Which runs pretty neat. Run it with a shell script like the following testDS.sh script:
#!/bin/bash
#############################################################################
# Test DataSources using wlst.
#
# @author Martien van den Akker, Darwin-IT Professionals
# @version 2.1, 2016-06-27
#
#############################################################################
#
. fmw12c_env.sh
echo
echo Test Datasources
wlst.sh ./testDS.py -loadProperties fmw.properties

For the fmw12c_env.sh and fmw.properties files look here.

Businesses Take Note: Less Than Half of Employees Say They Have the Right Technology to Do Their Jobs

Oracle Press Releases - Tue, 2016-10-04 07:00
Press Release
Businesses Take Note: Less Than Half of Employees Say They Have the Right Technology to Do Their Jobs New Oracle Global Engagement Study states that digital technology, leadership and company values rank among top distinguishers for employee success

Redwood Shores, Calif.—Oct 4, 2016

Oracle Corporation (NYSE: ORCL) released a Global Engagement Study conducted by global market research company Kantar TNS, today including feedback from nearly 5,000 full-time employees at organizations with 250 or more employees. The study indicated that equipping employees with the latest technology and having accessible leaders and strong company values are important factors that can ultimately reflect an employee’s success or failure within the company.

Digital Enablement

Technology is enabling companies to connect with employees in more ways than ever to create a more modern and customized learning experience. However, findings from the study indicate low marks when it comes to companies capitalizing on this—only 44 percent of respondents say that their company uses the latest technology to enable them to effectively perform in their role.

“Employees as consumers are more plugged into technology via multiple devices (i.e. mobile, tablet, desktop) than ever before. They expect the same level of accessibility that they get in their personal lives with the technology they encounter at work,” said Gretchen Alarcon, group vice president of HCM Product Strategy, Oracle. “Cloud technology enables this digital employee experience through features that can help employees learn, process and consume information in an easy way. A more modern user experience interface also reflects what they are accustomed to at home.”

Leadership

The findings also express that a strong presence in leadership is the backbone for an employee feeling satisfied and engaged. The study indicates that productivity starts with onboarding: employees are unsatisfied with the process, as only 41 percent believe that company onboarding practices set them up for growth and success. Not only are managers the first impressions of a company during onboarding, but they are also the first example of direction for the new worker. Only 47 percent of those polled viewed their leaders as visible and approachable and only 44 percent expressed that they have confidence in their leadership, indicating a lack of partnership between management and employees. 

“Employees ultimately decide if they would like to stay with a company within the first two weeks of employment,” said Alarcon. “What this means, is that within the first 14 days, employees are already asking themselves, ‘Do I think I can progress here? Do I have a manager who can be a mentor and am I getting the ability to create a network and get introduced to the right people and tools to best perform in my job?’ This is especially important when we think about development within a company—candidates want to feel the company is a good fit.”

Additionally, this study included key indicators for a healthy leadership to employee relationship:

  • Set examples of how best to communicate with those working under you
  • Remain extremely accessible so that people feel connected to company goals
  • Be actively involved in the working lives of new employees from the day they start
  • Use technology and digital experiences to stay in touch with team members
Values, Culture & Reward

What’s more, companies are now seeing that like-minded values between the employee and the company play a huge role in employee engagement. Only an astonishing 38 percent say that their company is concerned about their overall well-being—indicating that working towards a personally rewarding goal, while still upholding individual values can carry even more weight than monetary compensation.

Company culture mirrors these sentiments as employees are most comfortable and productive within a creative, yet flexible workplace culture. While compensation is often seen to be connected to employee satisfaction, we are now seeing that individuals are more interested in joining companies that uphold their same personal values to gauge if they are a good fit. Whether it’s a more flexible work schedule, more volunteer or health & wellness opportunities, companies too should now be listening and connecting with employees in more ways that correlate with their personal well-being.

To view the full study, click here.

For more information, view our infographic, checklist and blog post.

About the Study

Oracle collaborated with Kantar TNS on The Global Engagement Study which surveyed nearly 5,000 full-time employees at organizations with 250 or more employees. The study encompassed a total of 4,706 interviews that captured opinions, feelings and experiences on a wide range of workplace factors including: culture, performance, tangible and intangible rewards, development and progression opportunities, experiences with collaboration technology, the impact of leadership and how employees feel in their current role. Percentages quoted are for those giving a top two box selection on a seven point agreement scale.

Additional Information
Contact Info
Jennifer Yamamoto
Oracle
+1.916.761.9555
jennifer.yamamoto@oracle.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

Jennifer Yamamoto

  • +1.916.761.9555

Oracle 12c and RMAN switch datafile to copy, is it really so easy?

Yann Neuhaus - Tue, 2016-10-04 06:29

Oracle incrementally updating backups are used quite often because they are easy to setup and restoring a datafile is very fast. It is very fast because you are not really restoring a datafile, you are switching to the copy, in case something happens. But how do I switch back to the original destination with minimal downtime and with minimal impact on the system?

A quite common scenario is that we have 3 diskgroups, +DATA, +FRA and +REDO with different performance characteristics, like the following:

  • +DATA Diskgoup is on fast storage (10k rpm)
  • +FRA Diskgroup is on medium storage (7200 rpm)
  • +REDO Diskgroup is on very fast storage (15k rpm)

Loosing a 8T datafile

 

 

 

 

 

 

 

 

In case we loose now a bigfile with 8TB on the +DATA diskgroup, what options do we  have to restore it. Ok. Lets ask the Oracle Data Recovery Advisor first.  Oracle came up with the following script.

oracle@oel001:/home/oracle/rman/ [OCM121] cat /u00/app/oracle/diag/rdbms/ocm121/OCM121/hm/reco_3905236091.hm
   # restore and recover datafile
   restore ( datafile 9 );
   recover datafile 9;
   sql 'alter database datafile 9 online';

The script does his job, no question about it, but it means, that Oracle would copy 8TB from the +FRA to +DATA and afterwards maybe applying an inc1 and some archivelogs. If we do run this script, we wait for 4h. (suppose that we are copying with 600MB per second, which is very good)

In case your Database has a Standby in a DataGuard configuration, Oracle comes up with the following suggestion.

oracle@oel001:/home/oracle/rman/ [OCM121] cat /u00/app/oracle/diag/rdbms/ocm121/OCM121/hm/reco_4177443733.hm
   # restore from standby and recover datafile
   restore ( datafile 9 from service "sty121" );
   recover datafile 9;
   sql 'alter database datafile 9 online';

Again, it will work, but now Oracle tries to get the 8TB datafile over the network from the standby, which makes it even slower. Unfortunately, the “switch datafile to copy” was not build in, into the Recovery Advisor.

Ok. Lets do it manually and switch to the datafile copy. That takes only a few minutes, and this is the reason why we have incrementally updating backups. To make it as fast as possible.

RMAN> switch datafile 9 to copy;

datafile 9 switched to datafile copy "+FRA/OCM121/DATAFILE/monster.346.919594959"

RMAN> recover datafile 9;

RMAN> sql 'alter database datafile 9 online';

 

Now we restored and recoverd the 8TB datafile, and users can start working again on that bigfile tablespace. But due to the fact that the +FRA has only medium storage, your application might run slower than before.

Be careful, another issue might pop up after you are already on your datafile copy in the +FRA. If now a backup kicks it (scheduled by cron or something else), then Oracle has to create another 8TB in the +FRA as a new base for his incrementally updating backups, which makes your application even slower and even worse, you might run out of space.

An easy restore might end up now in a quite complex scenario. So what do we do now. First of all, we have to make sure that backups are not scheduled during our restore/recovery, and then we can manually create a new datafile copy in +DATA (of course, after the situation was corrected which lead to the datafile loss). In case you are running 12c, you can use the new feature “Multisection Backup for Datafile Copies”.

RMAN> backup section size 1T as copy datafile 9 format ='+DATA' tag clonefile9;

 

Now, a small downtime kicks in, when we have to take the datafile offline, switch to our new one in +DATA, recover it, and take it online again.

RMAN> sql 'alter database datafile 9 offline';

RMAN> switch datafile 9 to copy;

RMAN> recover datafile 9;

RMAN> sql 'alter database datafile 9 online';

 

Uffff … we are ready now, and users can work with the application again which is on the fast storage in +DATA. But wait a second, if we start our RMAN backup again, then Oracle does not regognize  the datafile copy in +FRA anymore as a valid copy for incrementally updataing backups. So, Oracle has to create another 8TB in the +FRA.

Now comes the 1Million $ question. How can we avoid this? We need to tag the datafile copy in +FRA as a valid starting point for incrementally updating backups.

RMAN> catalog datafilecopy '+fra/ocm121/datafile/MONSTER.346.919594959' level 0 TAG 'incr_update';

cataloged datafile copy
datafile copy file name=+FRA/ocm121/datafile/monster.346.919594959 RECID=33 STAMP=919603336

Oracle has the very useful command “catalog” for situations like this. Take care, that you specify “level 0″ and the correct “tag”, otherwise the datafile copy will not be regognized.

Now we are really ready, and we can start the RMAN incremetally backups again, like we did beforehand.

To summarize it:

  • Take care of your backups during the restore, it might makes the situation even worse.
  • Make use of the new feature “Multisection Backup for Datafile Copies”. It can speed up the creation of your datafile copies quite heavily.
  • Use the “catalog” command to tag your datafile copy correctly. It avoids the creation of another 8TB.

Cheers,

William

 

Cet article Oracle 12c and RMAN switch datafile to copy, is it really so easy? est apparu en premier sur Blog dbi services.

EBS ATG Oracle OpenWorld 2016 Content Now Available

Steven Chan - Tue, 2016-10-04 02:00

Oracle OpenWorld 2016 hosted approximately 60,000 in-person attendees and over 2 million online attendees.  For those of you that were able to join us in person, thank you for attending and for your feedback and questions. 

For a limited time, you can access all session presentations here:

You can search the catalog by session ID, session title, speaker name or keyword.

A full listing or Oracle E-Business Suite Applications Technology sessions is available in the Focus On Document (FOD) or our recently published blog article.

Where is the download link?

Once you find a session of interest, you can download the presentation by clicking the "Download Presentation" link.

Note: Many speakers are in the process of uploading their presentations.  Check back later if you don't find a download link.

You can also watch recordings from Oracle E-Business Suite Applications Technology and Product Development Oracle E-Business Suite Learning Stream.  Recordings of the sessions presented at Oracle OpenWorld will be made available soon. Please take advantage of this opportunity to consume the latest information at your convenience.

Thanks again for a great event!

Categories: APPS Blogs

VirtualBox Manual DPK Import Failure: Ran out of Virtual Disk

Jim Marion - Tue, 2016-10-04 00:33

The DPK scripts are simply amazing. I enjoy the flexibility of the new DPK system. I will confess, creating an HCM demo environment with DPK is not as easy as the prior PUM image method, but it is pretty close. As I prepared for OpenWorld 2016, I thought I would download the latest HCM DPK (update 18) and build out a new demo server on my MacBook. Unfortunately, I wasn't able to use the standard Windows PowerShell approach (PowerShell on Mac? Yes, maybe...) so went with the manual VirtualBox import method described in the document: PeopleSoft_Deployment_Packages_For_Update_Images_Installation_July2016, page 31 Task 2-2-2. Everything was running great until the VM attempted to extract HCM-920-UPD-018-OVA_12of15. The install process seemed to hang. With a little investigation, I found that the VM's second disk was full. The solution was rather simple: expand the disk and try again. Just in case you find yourself in this situation, here are the steps I performed to expand the virtual disk.

  1. Following the manual steps, I first imported the VirtualBox shell appliance, but I didn't boot the image
  2. Next, I cloned the second disk using the command VBoxManage clonehd VBOX_8_55_06_SHELL-disk2.vmdk VBOX_8_55_06_SHELL-disk2.vdi --format vdi. The point of cloning into a VDI is so we can use VirtualBox commands to expand the disk.
  3. I then expanded that new disk using the command VBoxManage modifyhd VBOX_8_55_06_SHELL-disk2.vdi --resize 122880. I didn't need to make the disk 120 GB. VirtualBox tells me the image is only using 65 GB, but it doesn't hurt to have extra capacity. The disk files grow as needed.
  4. Optional step: If you want, you can convert the disk back to a VMDK, but this is not necessary. I kept the VirtualBox VDI. VBoxManage clonehd VBOX_8_55_06_SHELL-disk2.vdi VBOX_8_55_06_SHELL-disk2.vmdk --format vmdk.
  5. You need to tell VirtualBox to use the new disk you just created. Open the Virtual Machine's settings and switch to the storage section. Replace the exising *disk2 entry with the name of the file you just created.
  6. Now, here is the interesting part... The virtual disk is bigger, but the operating system doesn't know that yet. We have to stretch the partition table on that disk so the operating system can use the free space we just created. The way I handled this was to boot the VirtualBox guest using one of the amazing Linux live ISO distributions. Specifically, I chose GParted. So, your next step is to download a Linux live distribution. You can find the GParted ISO here. Download the ISO so you can make it available to the VirtualBox guest
  7. With the ISO downloaded, open the guest's properties and switch to the storage settings. Add an optical drive to the IDE controller and select the ISO you downloaded.

  8. Boot the Virtual Machine. The live CD image should take over. If you chose GParted, then you should see the GParted program load. Use the list of disks in the upper right corner to switch to sdb. You should now see a disk with lots of unallocated space. Edit this disk so that it uses all of the available space

  9. Apply your changes, shutdown the virtual machine, and then remove the GParted disk ISO from the virtual drive.
  10. Continue with the rest of the DPK Install steps as described in the Oracle provided documentation.

You should now have a fully functional VirtualBox demo image. Tip: if your usage is light (no SES, not running payroll, etc), then you can easily drop the allocated memory for your VirtualBox image down to 2 GB. I've even run them as low as 1 GB. Memory is important, but I derive the most performance improvement from running these images on an SSD.

October 2016 Webinars

Jim Marion - Mon, 2016-10-03 21:38

I will be delivering three webinars this month, with two of them this week:

PeopleSoft Tips and Techniques: Advanced PeopleSoft People Tools Development Strategies

Wednesday, October 5th at 11 AM PST / 2 PM EST

In this session I will share interesting, thought provoking PeopleTools tips and techniques to help customers make the most of their PeopleSoft development investment.

Mobility Options for PeopleSoft Applications

Thursday, October 6th at 11 AM PST / 2 PM EST

Attend to learn various options for mobilizing PeopleSoft Applications.

The Cloud to Ground Mashup

Tuesday, October 25th at 11 AM PST / 2 PM EST

Presenters: Jim Marion, Senior Technology Evangelist
Larry Grey, Co-Founder

Why choose between Cloud and Ground when you can get the best of both? In this demo-intensive session, we will illustrate the flexibility and safety of your PeopleSoft investment.

You can register for our Webinars on the GreyHeller website.

Notes on the transition to the cloud

DBMS2 - Mon, 2016-10-03 21:22

1. The cloud is super-hot. Duh. And so, like any hot buzzword, “cloud” means different things to different marketers. Four of the biggest things that have been called “cloud” are:

  • The Amazon cloud, Microsoft Azure, and their competitors, aka public cloud.
  • Software as a service, aka SaaS.
  • Co-location in off-premises data centers, aka colo.
  • On-premises clusters (truly on-prem or colo as the case may be) designed to run a broad variety of applications, aka private cloud.

Further, there’s always the idea of hybrid cloud, in which a vendor peddles private cloud systems (usually appliances) running similar technology stacks to what they run in their proprietary public clouds. A number of vendors have backed away from such stories, but a few are still pushing it, including Oracle and Microsoft.

This is a good example of Monash’s Laws of Commercial Semantics.

2. Due to economies of scale, only a few companies should operate their own data centers, aka true on-prem(ises). The rest should use some combination of colo, SaaS, and public cloud.

This fact now seems to be widely understood.

3. The public cloud is a natural fit for those use cases in which elasticity truly matters. Many websites and other consumer internet backends have that characteristic. Such systems are often also a good fit for cloud technologies in general.

This is frequently a good reason for new – i.e. “greenfield” – apps to run in the cloud.

4. Security and privacy can be concerns in moving to the cloud. But I’m hearing that more and more industries are overcoming those concerns.

In connection to that point, it might be interesting to note:

  • In the 1960s and 1970s, one of the biggest industries for remote computing services — i.e. SaaS — was commercial banking.
  • Other big users were hospitals and stockbrokers.
  • The US intelligence agencies are building out their own shared, dedicated cloud.

5. Obviously, Amazon is the gorilla in the cloud business. Microsoft Azure gets favorable mentions as well. I don’t hear much about other public cloud providers, however, except that there are a lot of plans to support Google’s cloud just in case.

In particular, I hear less than I expected to about public clouds run by national-champion telecom companies around the world.

6. It’s inconvenient for an application vendor to offer both traditional and SaaS versions of a product. Release cycles and platform support are different in the two cases. But there’s no reason a large traditional application vendor couldn’t pull it off, and the largest are already more or less claiming to. Soon, this will feel like a market necessity across the board.

7. The converse is less universally true. However, some SaaS vendors do lose out from their lack of on-premises options. Key considerations include:

  • Does your application need to run close to your customers’ largest databases?
  • Do your customers still avoid the public cloud?

If both those things are true, and you don’t have an on-premises option, certain enterprises are excluded from your addressable market.

8. Line-of-business departments are commonly more cloud-friendly than central IT is. Reasons include:

  • Departments don’t necessarily see central IT as any “closer” to them than the cloud is.
  • Departments don’t necessarily care about issues that give central IT pause.
  • Departments sometimes buy things that only are available via remote delivery, e.g. narrowly focused SaaS applications or market data.

I discussed some of this in my recent post on vendor lock-in.

9. When the public cloud was younger, it had various technological limitations. You couldn’t easily get fast storage like flash. You couldn’t control data movement well enough for good MPP (Massively Parallel Processing) in use cases like analytic SQL.

Those concerns seem to have been largely alleviated.

10. It takes a long time for legacy platforms to be decommissioned. At some enterprises, however, that work has indeed been going on for a long time, via virtualization.

11. If you think about system requirements:

  • There is a lot of computing power in devices that may be regarded as IoT nodes — phones, TV boxes, thermostats, cars, industrial equipment, sensors, etc. Client-side computing is getting ever more diverse.
  • Server-side computing, however, is more homogenous. Enterprises can, should and likely will meet the vast majority of their server requirements on a relatively small number of clusters each.

I argued the latter point in my 2013 post on appliances, clusters, and clouds, using terminology and reasoning that are now only slightly obsolete.

So what will those clusters be? Some will be determined by app choices. Most obviously, if you use SaaS, the SaaS vendor decides which cloud(s) your data is in. And if you’re re-hosting legacy systems via virtualization, that’s another cluster.

Otherwise, clusters will probably be organized by database, in the most expansive sense of term. For example, there could be separate clusters for:

  • Operational data managed by your general-purpose RDBMS (Oracle, SQL Server, DB2, whatever).
  • Relational data warehousing, whether in an analytic RDBMS or otherwise.
  • Log files, perhaps managed in Hadoop or Splunk.
  • Your website and other internet back-ends, perhaps running over NoSQL data stores.
  • Text documents managed by some kind of search engine.
  • Media block or object storage, if the organization’s audio/video/whatever would overwhelm a text search engine. (Text search or document management systems can often also handle low volumes of non-text media.)

Indeed, since computing is rarely as consolidated as CIOs dream of it being, a large enterprise might have several clusters for any of those categories — each running different software for data and storage management — with different deployment choices among colo, true on-prem, and true cloud.

Categories: Other

Partioning

Tom Kyte - Mon, 2016-10-03 21:06
Hi Team, I want to tune table consisting millions of records. So i want to do partitions based on date column. My primary key in table is currently log id (transaction id). I want to use hash partitioning on date column. Can you tell me wha...
Categories: DBA Blogs

Partner Webcast – Oracle IaaS: Move Your Business Workloads To Oracle Cloud

In the past, companies have been able to adopt and utilize a business-as-usual IT infrastructure and get away with it. They purchased hardware to keep pace with data growth, managed multiple servers,...

We share our skills to maximize your revenue!
Categories: DBA Blogs

Transferring default domains for SQL Developer Data Modeler

Jeff Moss - Mon, 2016-10-03 10:27

I got a new laptop the other day and installed all the software, including SQL Developer Data Modeler all fine. I then opened a model which had a bunch of tables with columns based off Domains…the columns did not have Domains against them but had been replaced with Logical data types instead.

After some research, the fix, in this case, involved copying the file “defaultdomains.xml” from the following directory on my old laptop, to the same place on the new laptop:

%SQL Developer Home%\sqldeveloper\extensions\oracle.datamodeler\types

After restarting and reopening the model all was back to normal.

What I probably could have done in the first place was to have created my own Domains file for the Design, saved in the Design folder and then when I transferred the Design by copying across the Design folder the domains would have come with it. I could have then just opened the Domain file on the new laptop. I guess it depends on whether I would want these domains to Design specific or part of the defaults.

SGMB_URL = "http://www.oramoss.com/wp-content/plugins/social-media-builder/"; jQuery(".dropdownWrapper").hide();
jQuery(".socialMediaOnEveryPost").addClass("sgmb-left")

When Social Meets Content to Drive Meaningful Collaboration

WebCenter Team - Mon, 2016-10-03 10:25

Author: Marc-Andre Houle, Principal Product Director, Content and Experience Product Management, Oracle

You’ll often hear people say that effective collaboration starts with effective communication. Unfortunately, the most common way for enterprise people to communicate is through traditional email, which is far from effective. Email works well for simple communication, but not for lengthy discussions, and certainly not for group collaboration. That’s not to say email is bad or that it’s going away, but it does mean that enterprise workers are looking for a more effective way to collaborate without relying solely on email.

So, within Oracle Documents Cloud Service, we introduced our solution to the collaboration problem. By providing social collaboration features built directly into our powerful content platform, we’re providing the tools for people to collaborate and communicate more effectively without ever leaving the context of their collaboration, both within our application and in the sites and experiences that people build using our tools.

Normal 0 false false false EN-US X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-family:"Cambria","serif"; mso-ascii- mso-ascii-theme-font:minor-latin; mso-hansi- mso-hansi-theme-font:minor-latin;}

The first time you view a document in our application, whether in our Web client or in our mobile applications, you’ll notice the presence of a conversation icon. That lets you start a new conversation in the context of that document. Everyone who can collaborate on that document can also collaborate in the conversation. You can add annotations, post messages, reply to messages, and like people’s posts. When you want to draw someone’s attention to a specific post, you can flag that person on a message and a notification will get sent to them either by email, mobile notification, or as a desktop pop-up alert.


Normal 0 false false false EN-US X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-family:"Cambria","serif"; mso-ascii- mso-ascii-theme-font:minor-latin; mso-hansi- mso-hansi-theme-font:minor-latin;}

As people start to collaborate with you in conversations, you’ll want to see where those posts are being made and where people are collaborating with you. From the left-hand navigation pane, you can click on the “Conversations” tab to show you your list of conversations. That will include conversations related to files and folders, as well as stand-alone conversations and one-on-one conversations you may have with another person. There is an icon on each conversation to show the number of unread messages in that conversation, so you can see where you might need to catch up. And it’s possible to expand each row (or all rows, if you want) to show the most recent post that was made to a conversation. Because the list is sorted by recent activity, you can see new posts as they are posted, in real-time.

Normal 0 false false false EN-US X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-family:"Cambria","serif"; mso-ascii- mso-ascii-theme-font:minor-latin; mso-hansi- mso-hansi-theme-font:minor-latin;}

One common problem that people face is not knowing when there is an important update on one of their conversations when they’re not active in the user interface. You can configure to receive email notifications but, as I mentioned earlier, email isn’t always the best way to collaborate. However, people who have Oracle Documents Cloud Desktop Sync Client installed will receive pop-up alerts on their desktop for important activity taking place in their folders and files in Documents Cloud Service. Each person can configure what types of activity will trigger pop-up alerts. For example, you can get pop-up alerts for all the posts to all your favorite conversations or only get notifications for urgent flags that require a reply.

Normal 0 false false false EN-US X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-family:"Cambria","serif"; mso-ascii- mso-ascii-theme-font:minor-latin; mso-hansi- mso-hansi-theme-font:minor-latin;}

With our mobile-first strategy, our social features are completely integrated with our content features on all the platforms we support. That means you can collaborate anywhere and anytime, even when you’re not in the office or not sitting at your desktop. Oracle Documents Cloud Service apps are available off of the Apple App Store and Google Play today.

Normal 0 false false false EN-US X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-family:"Cambria","serif"; mso-ascii- mso-ascii-theme-font:minor-latin; mso-hansi- mso-hansi-theme-font:minor-latin;}

Of course, what we’re offering is more than just a set of social features; our social capabilities are part of a broader social platform that people can use to build their own custom sites and experiences. Our social features and UI are fully embeddable in sites and applications that people build themselves and the full set of social capabilities are also exposed in our REST APIs. 

Normal 0 false false false EN-US X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-family:"Cambria","serif"; mso-ascii- mso-ascii-theme-font:minor-latin; mso-hansi- mso-hansi-theme-font:minor-latin;}

Don’t have Oracle Documents Cloud Service yet? Then, I highly recommend getting started with a free trial version available at cloud.oracle.com/documents to see how you can now drive content and social collaboration anytime, anywhere and on any device.

Normal 0 false false false EN-US X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-family:"Cambria","serif"; mso-ascii- mso-ascii-theme-font:minor-latin; mso-hansi- mso-hansi-theme-font:minor-latin;}

Digital User Experience from the Cloud Hits the Silicon Valley of Transylvania

Usable Apps - Mon, 2016-10-03 07:17

Ultan O'Broin (@ultan) tells us of upcoming EMEA activity: 

Seems appropriate that someone from Bram Stoker’s home town, Dublin, should be visiting the Silicon Valley of Transylvania again, eh? I won't be alone, of course. We have a great team of Oracle Applications User Experience champs in Romania already!

I'm delighted to say that this October we are off around Romania for an engaging of sessions about user experience trends, emerging technology insights, innovation, and how digital-savvy people need digital-savvy workplaces and ways of working.

TechHub Bucharest Cloud and Wearable Tech Event

First of all, we're excited by another opportunity to engage with the Bucharest startup scene, this time at Bucharest’s TechHub where will join the tech community to share insights on the hot topics of the "Cloud and Wearable Technology Experience". Don’t miss it (Or "Imposibil de ratat", if you prefer). See you there! Sign up here

Later in the same week we will be at the Great People Inside conference in Brașov, bringing a lively session called "Function, Form, Fitness and Fashion: Smart People Need A Smart Experience".

Great People Inside Conference Logo

More details of this leading event are on the Usable Apps website.

Stay tuned for reports and insights from both these events and more from Romania!

Pages

Subscribe to Oracle FAQ aggregator