Posts

Posts

  • Karthik Ramachandran
    ATP : Network Latency / ATP Db Read Replicas/ caching1
    Topic posted July 2, 2019 by Karthik RamachandranRed Ribbon: 250+ Points, tagged Performance, REST API, Storage, Transaction Processing in Data Management > Autonomous Transaction Processing public
    Title:
    ATP : Network Latency / ATP Db Read Replicas/ caching
    Summary:
    ATP Database / Oracle Application Container Cloud : Network Latency / ATP Db Read Replicas/ caching
    Content:

    we are using ATP database & hosted the REST service in Oracle Application Container Cloud. So we will be consuming that service from our Oracle Commerce Cloud Application.

    https://www.oracle.com/database/autonomous-transaction-processing.html

    https://docs.oracle.com/en/cloud/paas/app-container-cloud/index.html

    So I have few question related to the above topic -

    1) We are global application, Oracle Commerce Cloud will be accessed around the globe. How the ATP database in Ashburn region will respond to network latency in other end of globe like (China, India, Singapore). Do we have any read replicas of ATP database in different location.

    2) We are using Oracle Application Container, how to handle load balancing to ATP database.

    3) Is there caching mechanism available for Application Container code.

    4) How do you decide the number of instance in Application Container Cloud. Like do oracle have any recommendation how many instance or memory needed for specific number of users.

  • Pramoda Vyasarao
    Object storage access via Cloud console to business users2
    Topic posted June 30, 2019 by Pramoda VyasaraoGreen Ribbon: 100+ Points, tagged Transaction Processing in Data Management > Autonomous Transaction Processing public
    Title:
    Object storage access via Cloud console to business users
    Content:

    Hello,

    Allow group Data_Team to manage objects in compartment ABC where all {target.bucket.name='BucketA', any {request.permission='OBJECT_CREATE', request.permission='OBJECT_INSPECT’}}
     
    With this policy defined, I plan to create business users and assign them to the group Data_Team. Here is my question, appreciate any insights on this.
     
     Can users of Data_Team (group) use cloud console UI to upload files to the object storage bucket? Or is it just via APIs / CLI ?
    In this  use case , business users procure large lists of external data in XLS/CSV files.  If we can achieve the above, I'm thinking of allowing business users to upload files to Object storage via a browser and then developers can access & load them to tables. In Cloud console UI, Data_Team should just see Object storage link enabled (no other option).
     
     
    Regards,
    Pramoda 
  • Ranveer Tiwari
    How to deploy DB Code in ATP, as we dont have OS Access...2
    Topic posted June 26, 2019 by Ranveer TiwariRed Ribbon: 250+ Points, tagged DBCS, Transaction Processing in Data Management > Autonomous Transaction Processing public
    Title:
    How to deploy DB Code in ATP, as we dont have OS Access where we can use Shell Script?
    Summary:
    How to deploy DB Code in ATP, as we dont have OS Access where we can use Shell Script?
    Content:

    How to deploy DB Code in ATP, as we don't have OS Access where we can deploy bulk code using a Shell Script?

    Version:
    Code Deployment, ATP, OS Access, DBCS
  • Pramoda Vyasarao
    Error while fetching data from an external table ( for a...1
    Topic posted June 24, 2019 by Pramoda VyasaraoGreen Ribbon: 100+ Points, tagged Transaction Processing in Data Management > Autonomous Transaction Processing public
    Title:
    Error while fetching data from an external table ( for a file from OCI object storage)
    Content:

    Hello,

     

    I followed the instructions from the below link 

    https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/load-data.html#GUID-07900054-CB65-490A-AF3C-39EF45505802

    Scripts used 
     
    SET DEFINE OFF
    BEGIN
     
    dbms_cloud.create_credential (
        'pramod_obj_store_cred',
        ‘user_email@gmail.com',
        'r4u.tH{BT_t(JePKkI6X’); — token from the OCI object store user 
    END;
    /
     
     
    BEGIN  
       DBMS_CLOUD.CREATE_EXTERNAL_TABLE(   
          table_name =>'happiness_report_2019_ext',   
          credential_name =>'pramod_obj_store_cred',   
          format => json_object('type' value 'csv', 'skipheaders' value '1'),   
          column_list => 'country varchar2(100),                   
                         ladder number,
                         sd_ladder number,                 
                         positive_effect number,                 
                         negative_effect number,                 
                         social_support number,                    
                         freedom number,     
                         corruption number,   
                         generosity number,
                         gdp number,
                         life_expectancy number');
       END;
    /
     
     
    Error message 
     
     
    Creating a token for the object storage cloud account 
     
     
     
    CSV file is available in the object storage bucket  (URL path) 
     
     

     

     
    Version:
    18C
  • Pramoda Vyasarao
    Oracle Advanced Analytics & Oracle Data Miner on ATP
    Topic posted June 24, 2019 by Pramoda VyasaraoGreen Ribbon: 100+ Points, tagged Transaction Processing in Data Management > Autonomous Transaction Processing public
    Title:
    Oracle Advanced Analytics & Oracle Data Miner on ATP
    Content:

    Hello,

     

    I've tried Machine learning SQL notebook on our trial ATP instance. I was keen to try Oracle data miner option using SQL Developer on ATP.  I get an error message saying 'data mining repository is not installed' (screenshot attached). Does ODM not work on ATP? 

    Thanks

    Pramoda

    Image:
  • Pramoda Vyasarao
    Max size of files on Object storage2
    Topic posted June 20, 2019 by Pramoda VyasaraoGreen Ribbon: 100+ Points, tagged Storage, Transaction Processing in Data Management > Autonomous Transaction Processing public
    Title:
    Max size of files on Object storage
    Summary:
    Maximum file size
    Content:

    Hello,

    I am downloading large files from https://www.data.gov for my Machine learning use cases. The plan is to load these into Object store and access them as external tables. What's the maximum file size? I remember it as 2GB in a training , please confirm?

    Regards,

     

  • Pramoda Vyasarao
    APEX applications on ATP1
    Topic posted June 20, 2019 by Pramoda VyasaraoGreen Ribbon: 100+ Points, tagged Apex, DBCS, Transaction Processing in Data Management > Autonomous Transaction Processing public
    Title:
    APEX applications on ATP
    Summary:
    Building APEX applications on ATP
    Content:

    Hello,

    If a company is using autonomus database cloud service, what options they have to develop & host APEX applications ?

    1. Does APEX come along with ATP service?

    2. Or the company has to sign up for an APEX cloud service and then connect that to ATP DB?

    Thanks for any insights on this.

    Regards,

     

     

  • Keith Laker
    NEW FEATURE: Set CPU/IO Shares for Autonomous Transaction...5.0
    Topic posted May 15, 2019 by Keith LakerSilver Medal: 2,000+ Points, tagged Monitoring, Performance, Transaction Processing in Data Management > Autonomous Transaction Processing public
    Title:
    NEW FEATURE: Set CPU/IO Shares for Autonomous Transaction Processing
    Summary:
    Autonomous Transaction Processing now allows customers to change the CPU/IO shares for the consumer groups within their ATP instance (high, medium, low, tp, tpurgent).
    Content:

    Autonomous Transaction Processing now allows customers to change the CPU/IO shares for the consumer groups within their ATP instance (high, medium, low, tp, tpurgent). This allows for use cases where, for example, a workload running in the LOW resource group requires a greater share of CPU/IO resources than HIGH and MEDIUM.

    The "Set Resource Management Rules" pop-up form on the administration section of the service console has been extended to allow the modification of CPU/IO shares across the different resource groups.

    It is also possible to change the resource shares within a script, application call and/or via a SQL prompt using the cs_resource_manager package.

    For more information relating to ATP click here.

  • Ranveer Tiwari
    REST JSON PUT/GET Method details to upload/download csv...
    Topic posted April 19, 2019 by Ranveer TiwariRed Ribbon: 250+ Points, tagged DBCS, REST API, Transaction Processing in Data Management > Autonomous Transaction Processing public
    Title:
    REST JSON PUT/GET Method details to upload/download csv files in/from Object Cloud Storage
    Summary:
    REST JSON PUT/GET Method details to upload/download csv files in/from Object Cloud Storage
    Content:

    Please Help, we need to upload & download files from Object cloud storage using REST MEthod

    https://<IdentititydomainURL>.oraclecloud.com/v1/<Customerid>/<BucketName>

    REST JSON PUT/GET Method details  to upload/download csv files in/from Object Cloud Storage

    Version:
    v1
  • Cyrille Cailloux
    audit actions on ATP2
    Topic posted February 20, 2019 by Cyrille Cailloux, tagged Security, Transaction Processing in Data Management > Autonomous Transaction Processing public
    Title:
    audit actions on ATP
    Content:

    Hello,

    is there a way to see what actions has been done on a database like restore, stop, start etc? I did a restore today and I can't find anywhere a log telling me that the database has been restored, at what date, how much time it took, who did it etc.

    thank you

    Cyrille