Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral


About burleson

  • Rank
    Advanced Member

Recent Profile Visitors

4,496 profile views
  1. burleson

    Automatic Failovers

    Hi, This article explains how your release level relates to your automatic failover options: http://www.dba-oracle.com/oracle_tips_failover.htm
  2. burleson

    Automatic Failovers

    Hi, It depends on your release of Oracle, but look at fast start failover: http://dba-oracle.com/googlesearchsite_proc.htm?cx=000522505899594707971%3A4-ldikxixw4&cof=FORID%3A10&ie=UTF-8&q=Data+guard+automatic+failover&sa=Search&siteurl=www.dba-oracle.com%2Ft_storing_insert_photo_pictures_tables.htm&ref=www.dba-oracle.com%2Ft_store_insert_pdf_file_oracle_table_blob.htm&ss=35780j74043766j41 Good luck!
  3. burleson

    help on database type

    Hi Raj, and welcome to the forum! Please read carefully: http://www.dba-oracle.com/t_store_insert_pdf_file_oracle_table_blob.htm Good luck!
  4. burleson


    Hi Oye, Here are all of the ASM views that you need: http://www.dba-oracle.com/t_oracle_asm_dictionary_tables.htm http://dba-oracle.com/googlesearchsite_proc.htm?cx=000522505899594707971%3A4-ldikxixw4&cof=FORID%3A10&ie=UTF-8&q=ASM+disk+script+&sa=Search&siteurl=www.dba-oracle.com%2Ft_oracle_asm_dictionary_tables.htm&ref=www.google.com%2F&ss=8426j5672842j15 Good luck!
  5. burleson

    Urgent Help!

  6. burleson

    Urgent Help!

    Hi Jade, Urgent???? I spent six years in college studying computer science, programming, and Information Systems before any company would let me manage a multi-million dollar database. Anyway, please read: http://www.dba-oracle.com/t_job_duties.htm
  7. burleson

    DBSAT Reporter Error.

    Hi, I have no experience with dbsat, but the error looks like a pathing issue. It’s having trouble finding the software.
  8. You are welcome! Please let us know how much time you saved.
  9. Hi Lucas, Do the math. At an optimistic platter disk I/O speed of ten milliseconds, multiply by one and a half trillion! Sadly, time takes time! The only other idea I have is to try a parallel CTAS with an order by clause. http://www.dba-oracle.com/t_create_table_select_ctas.htm There are also 3rd party sorting tools that are faster than Oracle: http://www.dba-oracle.com/t_oracle_sorting.htm Let us know your fastest option. Good luck!
  10. Hi Lucas, and welcome to the forum! Are you loading the IOT from a flat file, or another table? Please read: http://www.dba-oracle.com/t_insert_tuning.htm One point five trillion rows is gonna take awhile! Are you CPU bound during the procedure or I/O bound? You may benefit from deploying SSD or adding more CPU’s. Have you explored parallel DML? http://www.dba-oracle.com/t_parallel_dml_updates_inserts.htm Look at using a hash partitioned IOT: http://www.dba-oracle.com/t_index_organized_tables.htm Also, take an AWR or STATSPACK report for a five minute interval and post the results. please read: http://www.dba-oracle.com/t_identify_find_bottlenecks_with_awr.htm Good luck!
  11. burleson


    Users do not have allocated memory. Sorry, this question makes no sense to me. Try opening a service request on MOSC: http://support.oracle.com
  12. burleson


    To make the tablespace readable to a PDB, it depends on whether you are on 12.1 or 12.2: https://oracle-base.com/articles/12c/multitenant-default-tablespace-clause-12cr2
  13. burleson


    Hi Kapul, and welcome to the forum! First, note that users are never affiliated with a tablespace. This may answer your question: http://www.dba-oracle.com/t_create_user_12c.htm Good luck!
  14. burleson

    Import of Schema

    Hi Vikas, and welcome to the forum! if you are referring to impdp, the data is naturally packed, and naturally reorged. You rebuild the indexes from scratch, so they are pristine! The stats remain valid! Good luck!
  15. burleson

    How to make dataguard switchover seamlessly

    Hi Camillelola, sans welcome to the forum! Are you looking a switchover of failover? Is this a failover to physical standby or logical standby? You might want to explore the fast start failover technique. Please read: http://www.dba-oracle.com/fast_start_failover.htm I have lots of good notes on DG failover/switchover automation: http://dba-oracle.com/googlesearchsite_proc.htm?cx=000522505899594707971%3A4-ldikxixw4&cof=FORID%3A10&ie=UTF-8&q=Data+guard+failover&sa=Search&siteurl=www.dba-oracle.com%2Ffast_start_failover.htm&ref=www.google.com%2F&ss=7331j3261415j19 Good luck!