viernes, 27 de julio de 2018

Oracle TimesTen Scaleout Sets New Performance Standard for In-Memory Databases

Press Release 

World’s fastest transaction processing database delivers unmatched speed and scalability for extreme OLTP applications, such as real-time trading, real-time telecommunications billing, IoT, and real-time fraud detection 

Redwood Shores, Calif.—Jul 25, 2018 

Empowering global organizations to manage growing transaction workloads, Oracle today announced Oracle TimesTen Scaleout, the world’s fastest Online Transaction Processing (OLTP) database. Oracle TimesTen Scaleout, built on a proven enterprise architecture, is capable of massive scaleout, extreme transaction processing throughput, and ultra-low response times. 

TimesTen Scaleout was designed specifically to address real-time business workloads that handle an immense volume of data transactions, such as real-time trading, real-time telecommunications billing, IoT, and real-time fraud detection. Delivering breakthrough high throughput read and write speeds, TimesTen Scaleout achieves an impressive 144 million SQL transactions/second and 1.2 billion SQL statements/second running the Telecom Provider Throughput Benchmark (TPTBM) on commodity hardware. 

"We are proud to announce the release of TimesTen Scaleout, a new scaleout in-memory database for OLTP workloads," said Andrew Mendelsohn, executive vice president, Oracle Database. “Since it is based on the mature and time-tested TimesTen In-Memory Database, TimesTen Scaleout has both extensive sophisticated functionality, as well as incredible performance. This scaleout architecture is designed for extreme performance OLTP workloads and further extends Oracle's in-memory database technology leadership." 

Built on Oracle’s unmatched experience delivering industrial-strength database offerings, Oracle TimesTen Scaleout offers always-on operations and instant scalability. It includes a highly available architecture with multiple active copies of data that are automatically kept in sync. Queries and transactions can be initiated from, and executed on, any replica, ensuring database users always have access to data. With instant scalability, organizations can expand or shrink database instances and resources as business demands change. 

“Our marketing service system was successfully deployed under the new TimesTen Scaleout architecture with almost no application code changes,” said Tang Tang, head of the construction and maintenance department at Chongqing Mobile (China Mobile). “The entire system has not only improved performance by more than three times, but also successfully supported a number of new high concurrency business modules. This fully demonstrates that Oracle TimesTen Scaleout is an excellent distributed relational in-memory database product for OLTP SQL-based applications.” 

“Processing business transactions with large workloads with speed and agility is critical for making real-time business decisions, particularly those related to connected IoT devices, fraud detection and billing,” said Julian Dontcheff, Global Oracle Technology Lead for Accenture. “Having teamed with Oracle for more than two decades to deliver the latest technology innovations to our joint clients to help them accelerate digital transformation, we look forward to leveraging TimesTen Scaleout as an important component of our data architecture toolkits.” 

Oracle TimesTen Scaleout supports parallel SQL execution, global secondary indexes, and full-featured multi-statement distributed transactions. It features Oracle Database compatible data types, languages, and APIs, including SQL and PLSQL, the Oracle Call Interface (OCI), JDBC, among others. The system also allows for multiple data distribution options to accommodate a wide variety of application requirements and provides centralized management capabilities that can be accessed via Oracle SQL Developer. 

TimesTen Scaleout is just the latest Oracle database innovation. To learn more about recent database solutions, including the Oracle Autonomous Data Warehouse, please visit here
Oracle Data Management 

Oracle provides the industry's most complete family of data management software products: Oracle RDBMS, Oracle TimesTen Scaleout In-Memory Database, Oracle NoSQL Database, MySQL, and Berkeley DB. Oracle's new Autonomous Database Cloud provides the industry's first self-driving, self-securing, and self-repairing database cloud service. It's built on unique Oracle data management technologies, including Oracle Exadata Database Machine, Oracle Database 18c, Oracle Real Application Clusters, and Oracle Multitenant, plus algorithms using artificial intelligence to make it autonomous. 

Follow Oracle Database via Blog, Facebook and Twitter

Contact Info 
Dan Muñoz
Oracle
+1.650.506.2904

Nicole Maloney
Oracle
+1.650.506.0806

Oracle Named a Leader in Digital Experience Development Platforms by Leading Industry Analyst Firm


Press Release 
Oracle recognized among vendors that enable developers to build a portfolio of digital experiences 

Redwood Shores, Calif.—Jul 26, 2018 

Oracle today announced that Forrester Research has named Oracle a leader in its “The Forrester Wave™: Digital Experience Development Platforms, Q2 2018” report. This placement confirms the exceptional growth of Oracle Mobile Cloud and Oracle’s innovative no-code solution that leverages the latest emerging technologies to help developers create a unified multi-channel digital experience across platforms. 

“We believe this recognition by Forrester is further validation of Oracle’s commitment to building a comprehensive suite that enables enterprises to create unique, personalized digital experiences across web, mobile and chatbots,” said Suhas Uliyar, vice president, product management, Oracle. “Users have a variety of choices in the way they engage content and enterprises can’t assume stakeholders interact on any one particular channel. Using Oracle Mobile Cloud, customers can build across multiple channels and derive insights on usage and adoption across these to personalize end user engagement.” 

In the report, Forrester utilized 33 criteria to evaluate nine digital experience development platform vendors, grouping these evaluations into three main categories, including: current offering, strategy, and market presence. 

The author of The Forrester Wave™, Michael Facemire wrote: “Oracle has seen great adoption of its Mobile Cloud Enterprise platform since building it from the ground up in 2014. Oracle has added to this cloud-first platform with front-end tooling around web, chat, and low-code options. A unified programming model has allowed Oracle to build solid tooling (Visual Builder Cloud Service) to expose these components to a larger audience without going down the proprietary path where other vendors have stumbled in the past.” 

Working with Oracle, Mutua Madrid Open became the first ATP World Tour Masters 1000 and Premier WTA tournament to offer fans an AI-equipped chatbot, “MatchBot,” for event information, including results, services, parking and more. “We wanted to position the Mutua Madrid Open as the tournament of the 21st century,” said Gerard Tsobanian, president and CEO, Mutua Madrid Open. “Development of the MatchBot using Oracle Mobile Cloud positions us at the forefront of technology and innovation. With this new technology, we were able to provide visitors with an amazing experience—a pleasant, simpler, and faster way to get the information they wanted about the tournament.” 

Part of Oracle Cloud Platform, Oracle Mobile Cloud is a complete multi-channel platform managed by Oracle to help developers and enterprises engage intelligently and contextually with customers, business partners and employees through the end user’s channel of choice. It enables customers to deliver engaging, personalized digital experiences that will delight customers across multiple channels. Not only can customers engage via mobile and web channels, but now take advantage of the next leap in technology—artificial intelligence—for all platforms and intelligent bot services. In addition to providing a platform to build engaging experiences across mobile, bots and web, users also get actionable insights via analytics that provide deep understanding of user adoption behavior and app performance across platforms, so businesses can personalize engagement and ensure that everything is running at peak performance. 

Learn more about Oracle Mobile Cloud
Connect with Oracle Mobile Cloud on Twitter and via Oracle Mobile Cloud Blog

Contact Info 

Jesse Caputo
Oracle
+1.650.506.5967

Oracle Hot Topics: ORA-7445 [PC:0X2B540CABCCEB] [SIGSEGV]


Alerts

Alert
Product Area
Last Updated
Oracle Database - Enterprise Edition
Fri, 27 Jul 2018 07:53 GMT-06:00

Bugs

Bug
Product Area
Bug ID
Last Updated
Oracle Database - Enterprise Edition
12805444
Fri, 27 Jul 2018 06:28 GMT-06:00

Knowledge Articles

Knowledge Article
Product Area
Last Updated
Oracle Database - Enterprise Edition
Fri, 27 Jul 2018 07:53 GMT-06:00


jueves, 26 de julio de 2018

TIP#4 SQLCL 18.2 Información general sobre una tabla


info+ SCHEMA.tarjeta_db_auth

SQL> info+ SCHEMA.tarjeta_db_auth
TABLE: CARD_DB_AUTH
         LAST ANALYZED:2018-07-10 22:36:27.0
         ROWS         :1392911
         SAMPLE SIZE  :1392911
         INMEMORY     :
         COMMENTS     :Debito automatico

Columns
NAME                           DATA TYPE             NULL  DEF LOW_VALUE         HIGH_VALUE        NUM_DISTINCT   HISTOGRAM
*ID                            NUMBER(9,0)           No            3162          1437089           1386666        NONE
 ID_NET_TXN                    VARCHAR2(50 BYTE)     Yes           000000        999998            916800         HEIGHT BALANCED
 BUSSINES_DATE                 TIMESTAMP(6)          Yes                                           2103           NONE
 NET_TXN_TYPE                  NUMBER(9,0)           No            2             82                4              FREQUENCY
 CARD_DB                       NUMBER(9,0)           Yes           2719          43592             5887           NONE
 ACCOUNT                       NUMBER(9,0)           Yes           854058840     854133928         4238           HEIGHT BALANCED
 MSG_DATE_TIME                 TIMESTAMP(6)          No                                            1377408        NONE
 ORIGIN_DATE_TIME              TIMESTAMP(6)          Yes                                           2063           NONE
 AMOUNT                        NUMBER(17,10)         Yes           -100000       1000000           152672         HEIGHT BALANCED
 MSG_TYPE                      NUMBER(9,0)           Yes           3             9                 3              FREQUENCY
 MESSAGE                       VARCHAR2(1024 BYTE)   No            "BARACAT"     zubbcare.com151   361504         HEIGHT BALANCED
 CURRENCY                      NUMBER(9,0)           Yes           3             8                 2              FREQUENCY
 REFERENCE_NUMBER              NUMBER(38,0)          Yes           0             999998            902592         NONE
 ORIGIN_POINT                  VARCHAR2(100 BYTE)    Yes           "BARACAT"     zubbcare.com151   102664         NONE
 QUOTATION                     NUMBER(9,0)           Yes                                           0              NONE
 RECONCILIATION_FLAG           NUMBER(9,0)           Yes           1             3                 3              FREQUENCY
 ACTIVITY_TYPE                 NUMBER(9,0)           No            3             3                 1              FREQUENCY
 ERROR_TEXT                    VARCHAR2(100 BYTE)    Yes           : Cuenta rs   Tipo de Autoriz   13             FREQUENCY
 STATUS                        NUMBER(9,0)           No            3             214591            8              FREQUENCY
 STATUS_DATE                   TIMESTAMP(6)          No                                            1349632        NONE
 STATUS_REASON                 NUMBER(9,0)           Yes                                           0              NONE
 STAMP_USER                    NUMBER(9,0)           No            44            826087358         18             NONE
 STAMP_ADDITIONAL              VARCHAR2(50 BYTE)     Yes           214010        275987            11             NONE
 STAMP_DATE_TIME               TIMESTAMP(6)          Yes                                           1363456        NONE
 CASHIER_MACHINE               VARCHAR2(40 BYTE)     Yes           "G6j9SBD      {FLM1SBD          107312         NONE
 AUTHORIZATION_STATUS_TYPE     NUMBER(9,0)           Yes                                           0              NONE
 AUTHORIZATION_STATUS_TYPE_PR  NUMBER(9,0)           Yes                                           0              NONE
 SEQUENCE                      NUMBER(9,0)           No            0             131               132            NONE
 CONVERTED_AMOUNT              NUMBER(20,5)          Yes           -59,41        1017093,56        33000          NONE
 CARD_DB_CONCILIATION          NUMBER(9,0)           Yes           2953          1290563           1193344        NONE
 STATUS_TYPE_DATE_TIME         TIMESTAMP(6)          Yes                                           0              NONE
 TD_ANULATION_TYPE             NUMBER(9,0)           Yes                                           0              NONE
 ORIGIN_MOVEMENT               NUMBER(9,0)           Yes           2             22                2              FREQUENCY
 DATE_TIME_EXPIRY              TIMESTAMP(6)          Yes                                           2109           NONE
 USER_EXPIRY                   NUMBER(9,0)           Yes                                           0              NONE
 EXPIRY_FLAG                   NUMBER(9,0)           Yes                                           0              NONE

Indexes
INDEX_NAME                         UNIQUENESS   STATUS   FUNCIDX_STATUS   COLUMNS
SCHEMA.SYS_C001670372              UNIQUE       VALID                     ID
SCHEMA.XAKBCARD_DB_AUTH            UNIQUE       VALID                     BUSSINES_DATE, NET_TXN_TYPE, ID_NET_TXN, SEQUENCE
SCHEMA.PERF_CARD_DB_AUT01          NONUNIQUE    VALID    ENABLED          SYS_NC00037$, ERROR_TEXT, ACCOUNT
SCHEMA.AK_CARD_DB_JOUNAL_ON_LINE   NONUNIQUE    VALID                     BUSSINES_DATE, ID_NET_TXN


References
TABLE_NAME                  CONSTRAINT_NAME   DELETE_RULE   STATUS    DEFERRABLE       VALIDATED   GENERATED
CARD_DB_AUTH_PROCESS_CTRL   SYS_C0062226      NO ACTION     ENABLED   NOT DEFERRABLE   VALIDATED   GENERATED NAME
CARD_DB_AUTH_STATUS         SYS_C0062232      NO ACTION     ENABLED   NOT DEFERRABLE   VALIDATED   GENERATED NAME

Oracle 18c 18.3.0.0. Instalando el esquema HR de ejemplo ( Installation HR SCHEMA example in 18c )


[oracle@lab01 admin]$ sqlplus system/oracle@pdb1

SQL*Plus: Release 18.0.0.0.0 - Production on Mon Jul 23 17:30:18 2018
Version 18.3.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.

Last Successful login time: Mon Jul 23 2018 17:29:13 -06:00

Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0

SQL> alter user hr account unlock;
alter user hr account unlock
           *
ERROR at line 1:
ORA-01918: user 'HR' does not exist


SQL> @?/demo/schema/human_resources/hr_main.sql

specify password for HR as parameter 1:
Enter value for 1: hr

specify default tablespeace for HR as parameter 2:
Enter value for 2: users

specify temporary tablespace for HR as parameter 3:
Enter value for 3: temp

specify log path as parameter 4:
Enter value for 4: examplehr_instalation.txt


PL/SQL procedure successfully completed.


User created.


User altered.


User altered.


Grant succeeded.


Grant succeeded.


Session altered.


Session altered.


Session altered.

******  Creating REGIONS table ....

Table created.


Index created.


Table altered.

******  Creating COUNTRIES table ....

Table created.


Table altered.

******  Creating LOCATIONS table ....

Table created.


Index created.


Table altered.


Sequence created.

******  Creating DEPARTMENTS table ....

Table created.


Index created.


Table altered.


Sequence created.

******  Creating JOBS table ....

Table created.


Index created.


Table altered.

******  Creating EMPLOYEES table ....

Table created.


Index created.


Table altered.


Table altered.


Sequence created.

******  Creating JOB_HISTORY table ....

Table created.


Index created.


Table altered.

******  Creating EMP_DETAILS_VIEW view ...

View created.


Commit complete.


Session altered.

******  Populating REGIONS table ....

1 row created.


1 row created.


1 row created.


1 row created.

******  Populating COUNTIRES table ....

1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.

******  Populating LOCATIONS table ....

1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.

******  Populating DEPARTMENTS table ....

Table altered.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.

******  Populating JOBS table ....

1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.

******  Populating EMPLOYEES table ....

1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.

******  Populating JOB_HISTORY table ....

1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


1 row created.


Table altered.


Commit complete.


Index created.


Index created.


Index created.


Index created.


Index created.


Index created.


Index created.


Index created.


Index created.


Index created.


Index created.


Commit complete.


Procedure created.


Trigger created.


Trigger altered.


Procedure created.


Trigger created.


Commit complete.


Comment created.


Comment created.


Comment created.


Comment created.


Comment created.


Comment created.


Comment created.


Comment created.


Comment created.


Comment created.


Comment created.


Comment created.


Comment created.


Comment created.


Comment created.


Comment created.


Comment created.


Comment created.


Comment created.


Comment created.


Comment created.


Comment created.


Comment created.


Comment created.


Comment created.


Comment created.


Comment created.


Comment created.


Comment created.


Comment created.


Comment created.


Comment created.


Comment created.


Comment created.


Comment created.


Comment created.


Comment created.


Comment created.


Comment created.


Commit complete.


PL/SQL procedure successfully completed.

SQL>

SQL> connect hr/hr@pdb1
Connected.
SQL> col table_name format a20

SQL> select * from cat;

SQL> /

TABLE_NAME           TABLE_TYPE
-------------------- -----------
REGIONS              TABLE
COUNTRIES            TABLE
LOCATIONS            TABLE
LOCATIONS_SEQ        SEQUENCE
DEPARTMENTS          TABLE
DEPARTMENTS_SEQ      SEQUENCE
JOBS                 TABLE
EMPLOYEES            TABLE
EMPLOYEES_SEQ        SEQUENCE
JOB_HISTORY          TABLE
EMP_DETAILS_VIEW     VIEW

11 rows selected.

SQL> select * from jobs;

JOB_ID     JOB_TITLE                           MIN_SALARY MAX_SALARY
---------- ----------------------------------- ---------- ----------
AD_PRES    President                                20080      40000
AD_VP      Administration Vice President            15000      30000
AD_ASST    Administration Assistant                  3000       6000
FI_MGR     Finance Manager                           8200      16000
FI_ACCOUNT Accountant                                4200       9000
AC_MGR     Accounting Manager                        8200      16000
AC_ACCOUNT Public Accountant                         4200       9000
SA_MAN     Sales Manager                            10000      20080
SA_REP     Sales Representative                      6000      12008
PU_MAN     Purchasing Manager                        8000      15000
PU_CLERK   Purchasing Clerk                          2500       5500
ST_MAN     Stock Manager                             5500       8500
ST_CLERK   Stock Clerk                               2008       5000
SH_CLERK   Shipping Clerk                            2500       5500
IT_PROG    Programmer                                4000      10000
MK_MAN     Marketing Manager                         9000      15000
MK_REP     Marketing Representative                  4000       9000
HR_REP     Human Resources Representative            4000       9000
PR_REP     Public Relations Representative           4500      10500

19 rows selected.

SQL>

Todos los Sábados a las 8:00PM

Optimismo para una vida Mejor

Optimismo para una vida Mejor
Noticias buenas que comentar