Tag: #oratidbit

Posted on

Oracle Tidbits September 2019 #oratidbit #OOW19

“Oracle *daily* TidBits” (#oratidbit) published on Facebook &Twitter, during weekdays in September 2019. Hope you find these helpful to learn something new or to remind you of its existence and use.

#OraTidbit Oracle Developer Studio includes a compiler suite, an analysis suite, and a graphical integrated development environment (IDE). They provide a development environment that is optimized for developing applications with the best performance on Oracle Sun hardware.
#OraTidbit Oracle Machine Learning provides a notebook-style application designed for advanced SQL users and provides interactive data analysis that lets you develop, document, share, and automate reports based on sophisticated analytics and data models.
#OraTidbit #OracleCloud Work Requests in Oracle Autonomous Database let you track the progress of database lifecycle management operations such as creating, terminating, backing up (manual), restoring, scaling, and cloning.
#OraTidbit #OracleCloud Autonomous Transaction Processing database includes automated index management tasks such as creating, rebuilding, and dropping indexes based on changes in the application workload.
#OraTidbit #OracleCloud Autonomous Transaction Processing database includes gathering real-time statistics automatically while a conventional DML workload is running. This helps the optimizer generate more optimal plans.
#OraTidbit #OracleCloud Autonomous Transaction Processing database includes gathering statistics automatically on a more frequent basis (default is 15 minutes). High-frequency automatic optimizer statistics collection complements the standard statistics collection job.
#OraTidbit You can use Oracle Enterprise Manager to discover and manage dedicated Autonomous Transaction Processing databases, provided you are using Enterprise Manager version 13.3 with EM DB Plugin Bundle Patch 13.3.2.0.190731 (or higher).
#OraTidbit gridSetup.sh can be used with the -dryRunForUpgrade option for dry run testing of Oracle Grid Infrastructure upgrade and enables you to verify whether the system is ready for an upgrade. This mode does not perform an actual upgrade.
#OraTidbit The LOG_FILE_NUM_<listener_name> and LOG_FILE_SIZE_<listener_name> parameters in the listener.ora specifies the number of log file segments and the size of each log file segment. If the log grows beyond the number of segments, then the older segments are deleted.
#OraTidbit Oracle Data Safe is a fully-integrated Cloud service focused on the security of your data. It provides a complete and integrated set of features for protecting sensitive and regulated data in Oracle Cloud databases.
#Oratidbit #AutonomousDB Oracle Autonomous Data Warehouse (#ADW) supports dedicated deployments now. Autonomous Transaction Processing (#ATP) dedicated were available since June 2019.

There were no #OraTidbit tweets/fb posts during the OOW week. Here are a few of my #OOW19 tweets.

#OOW19 #CodeOne Highlights from Oracle OpenWorld 2019 – Larry Ellison’s Key-Notes
https://t.co/Y1DiHth767
#OOW19 Review: Oracle Analytics Deep Dive
#OracleAnalytics
https://t.co/pVu4tEYJRC
#OOW19 #CodeOne All the OpenWorld 2019 downloads!
Why dig around for hours in the catalog? Here are all of the downloads registered in the OpenWorld catalog!
https://t.co/Lztn15OBSN
#OOW19 #Exadata #Gen2
Oracle Gen 2 Exadata Cloud at Customer
https://t.co/L0lRLQozbB
#OOW19 #Exadata #X8M
Oracle Unleashes World’s Fastest Database Machine
Exadata X8M, industry’s first database machine with integrated persistent memory and RoCE, delivers 2.5X performance increase and 10X lower latency
https://t.co/CH8PG2DehT
#OOW19 #DataCenter #OracleCloud
Oracle Cloud Puts Data Center Expansion Pedal to the Metal.
Between now and the end of next year, the company expects to launch one new region every 22 days on average.
https://t.co/quvY1wBSpG
#OOW19 #CloudSecurity
Oracle OpenWorld 2019 – Oracle beefs up cloud security, announces three new features to build on Autonomous Database success
https://t.co/h7xvHPPkI8
#OOW19 “One More Thing”
The Oracle Cloud Free Tier – The New “Always Free Service”s announced at OOW19
https://t.co/yzwOXBWsjn
#OOW19 #VMWare #HybridCloud
New Oracle Cloud VMware Solution will Enable Customers to Run VMware Workloads on Oracle Cloud. Oracle to Offer Technical Support for Oracle Products Running on VMware Virtualized Environments.
https://t.co/HMGcOECh0x
#OOW19 “One More Thing”
Best and Cheapest Oracle APEX hosting: Free Oracle Cloud
https://t.co/BGidXWI5pU
#CodeOne #unconference #Groundbreakers @groundbreakers https://t.co/KyOj40J0G1
#OOW19 #AutonomousLinux #Linux
In an Industry First, Oracle Brings Autonomous Operation to Linux
https://t.co/v7NlAhKfBp
Posted on

Oracle Tidbits: June 2019 #OraTidbit

“Oracle *daily* TidBits” (#oratidbit) published on Facebook &Twitter, during weekdays in June 2019. Hope you find these helpful to learn something new or to remind you of its existence and use.

#oratidbit Oracle Data Pump in #db19c has a new transform parameter OMIT_ENCRYPTION_CLAUSE that causes Data Pump to suppress any encryption clauses associated with objects using encrypted columns.
#oratidbit Deferred Insert is a special type of insert in #db19c for which the database allocates buffers from the large pool. Deferred inserts are automatically committed and cannot be rolled back.
#oratidbit Enable deferred insert (#db19c feature) for a table by using the MEMOPTIMIZE FOR WRITE clause in ALTER TABLE or CREATE TABLE. Initiate deferred insert using the /*+ MEMOPTIMIZE_WRITE */ hint in the INSERT statement.
#oratidbit #db19c Starting in Oracle Database 19c, the SQL*Plus table PRODUCT_USER_PROFILE (PUP table) is desupported. The SQL*Plus product-level security feature is unavailable in Oracle Database 19c.
#oratidbit #db19c Starting with Oracle Database 19c and Oracle Grid Infrastructure 19c, Rapid Home Provisioning is renamed to Fleet Patching and Provisioning (FPP).
#oratidbit Using Fleet Patching and Provisioning to patch and upgrade Oracle Restart automates and standardizes the processes that are implemented in Oracle RAC database installations. This also reduces operational demands and risks, especially for large numbers of Oracle Restart deployments.
#oratidbit Oracle Big Data SQL supports queries against non-relational data stored in multiple big data sources, including Apache Hive, HDFS, Oracle NoSQL Database, Apache HBase, and Apache Kafka. It enables unified query for distributed data.
#oratidbit #oraclecloud Autonomous Database (ADW/ATP) automatically backs up the database for you. The retention period for backups is 60 days. You can restore and recover your database to any point-in-time in this retention period.
#oratidbit #oraclecloud Autonomous Database supports restricted access using a network Access Control List (ACL) to accept connections from addresses specified on the ACL and rejects all other client connections.
#oratidbit #oraclecloud Autonomous Database supports Application Continuity. Enable using the DBMS_CLOUD_ADMIN.ENABLE_APP_CONT procedure for a service.
#oratidbit #OracleRAC Starting with Oracle Grid Infrastructure 19c, the Grid Infrastructure Management Repository (GIMR) is optional for new installations of Oracle Standalone Cluster. Reduces functionality in CHAG, CHACTL, TFA.
#oratidbit #OracleRAC In Oracle Grid Infrastructure 12.2, Oracle announced that it would no longer support the placement of the Oracle Cluster Registry (OCR) and voting files directly on a shared file system. This desupport is now rescinded starting with 19c (19.3).
#oratidbit V$PASSWORDFILE_INFO provides information about the database password file. IS_ASM column indicates where the password file is stored.
#oratidbit Oracle #db19c still supports the DBMS_JOB package. You must grant the CREATE JOB privilege to the database schemas that submit DBMS_JOB jobs.
#oratidbit Flash-based Enterprise Manager Express is deprecated in Oracle Database 19c. Starting with #db19c, Enterprise Manager Express uses Java JET technology for the user interface.
#oratidbit #db19c Oracle Streams desupported in Oracle Database 19c 19.1. The streams views such as DBA_STREAMS*, ALL_STREAMS*, V$STREAMS* are desupported.
#oratidbit #thinkautonomous #APEX Each Autonomous Database (ATP/ADW) instance includes a dedicated instance of Oracle Application Express; you can use this instance to create multiple workspaces.
#oratidbit #thinkautonomous Autonomous Database (ATP/ADW) supports Microsoft Azure cloud storage with Oracle Data Pump.
#oratidbit #db19c AutoUpgrade enables you to upgrade one or many Oracle Database instances at the command-line, using a single command, and a single configuration file. AutoUpgrade runs preupgrade tasks, fix-ups where needed, database upgrade, and post-upgrade tasks.
#oratidbit #db19c Oracle Real Application Testing supported multitenant databases at the root container database (CDB) level. Starting with Oracle Database Release 19c, you can capture and replay the workload from within an individual pluggable database (PDB).