Jump to content

All Activity

This stream auto-updates     

  1. Last week
  2. boobalganesan

    Value in a range

    Hello SCB, Write a SELECT query with ID and ID_INDICATOR in the WHERE condition and put the below condition. "AND 57 between RANGO_MIN and RANGO_MAX" Adding the above condition will return you the desired row. Thank you, Boobal Ganesan
  3. scb

    Value in a range

    I have a table that contains ranges for each pair of columns id_indicator / id. For example, for the pair id_indicator / id with value Ind1 / 1, if the percentage is 57%; I need to know that this percentage must correspond to the color "naranja" (column color_indicador). What better solution could I implement, please? Thank you very much in advance. Regards,
  4. 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
  5. ch_dba

    Automatic Failovers

    Hi, I don't quite understand your answer - "it depends on your release of Oracle". What does the Oracle release have to do with the difference between using Data Guard vs Active data Guard as it relates to Automatic Fail-overs? My Oracle version is 11gR2 (11.2.0.3) btw. Regards,
  6. Earlier
  7. RussellLantz

    Duration of Backup

    Thank you so much for the query. My problem is also solved.
  8. 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!
  9. 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!
  10. ch_dba

    Automatic Failovers

    Hi All, I'm a new member here... I just need some information. I want to setup Automatic Failover (between Primary and Standby Database). Can this be done via "normal" Data Guard or do you need Active Data Guard (which incurs additional licensing cost) to do the trick? Also, if it can be done via "normal" Data Guard, can you please point me to a setup document? Regards,
  11. Raj_K

    help on database type

    hi can you please help me which database should I use to store and append the pdf files
  12. Thanks So Much Burleson!!!
  13. burleson

    DISTINCT DATABASE STORAGE USAGE IN ASM

    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!
  14. burleson

    Urgent Help!

    http://www.dba-oracle.com/remote_alerts.htm
  15. Hey Guys, I am working in a RAC environment and have been struggling to get a perfect query to view ASM Storage usage based on specific and each databases in the ASM. Simply, i want a result that shows a database and how much size that database is using (in total) in my ASM I tried out some query out, but they don't return what i want. My desired outcome looks like the below table GNAME DBNAME MB GB #FILES ---------- ---------- -------------- ---------------- ---------------- DATAC1 MISU2 5,867,345 5,867 1,245 RECOC1 MISU2 5,901,360 5,763 1,119 Thanks Guys!!!!!
  16. can not see sessions in weblogic enterprise manager to kill some of them , i login with admin user to enterprise manager ,also application work fine but i see red down arow in wls_form and cluster_forms see bellow links
  17. Jade

    Urgent Help!

    Thanks for the Response.. Could you please advice on this or any thoughts...
  18. 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
  19. Jade

    Urgent Help!

    Gurus, I would like to know comprehensive list of DBA related tasks especially Oracle DBA,Daily/Weekly/Monthly or Quarterly Routine Checklist/Tasks. Thanks, Jade
  20. datacoach

    DBSAT Reporter Error.

    Ok thanks will, explore further
  21. 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.
  22. datacoach

    DBSAT Reporter Error.

    Hi, I tried to run the DBSAT for the first time and ran into an error at the "Running the Reporter", I have tried to search the Oracle Support Knowledge Center and also google for a solution but unfortunately can't get any answers. See output below; Please advise. [oracle@sample607 dbsat]$ ./dbsat report db04 Database Security Assessment Tool version 2.0.2 (May 2018) This tool is intended to assist in you in securing your Oracle database system. You are solely responsible for your system and the effect and results of the execution of this tool (including, without limitation, any damage or data loss). Further, the output generated by this tool may include potentially sensitive system configuration data and information that could be used by a skilled attacker to penetrate your system. You are solely responsible for ensuring that the output of this tool, including any generated reports, is handled in accordance with your company's policies. Archive: db04.zip [db04.zip] db04.json password: inflating: db04.json Traceback (most recent call last): File "/home/oracle/dbsat/./sat_reporter.py", line 18, in <module> import sat_analysis as sat File "/home/oracle/dbsat/sat_analysis.py", line 13, in <module> import xlsxwriter ImportError: No module named xlsxwriter Error: Unexpected error occurred while running DBSAT Reporter.
  23. You are welcome! Please let us know how much time you saved.
  24. Lucas Scabora

    Bulk dynamic insert operations into an index-organized table

    Hello, thanks for all the help. I think that will be better to export the tables as CSV files using this (your) tutorial: http://www.dba-oracle.com/t_export table_to_csv.htm If the data are into files, I usually sort each file's lines directly in bash using the following tutorial (splitting according to the available memory): https://unix.stackexchange.com/questions/350046/sort-large-csv-files-90gb-disk-quota-exceeded Thanks again for everything. If I come up with a solution inside Oracle I will let you know. Best regards.
  25. 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!
  26. Lucas Scabora

    Bulk dynamic insert operations into an index-organized table

    Hello, Thanks for the advice. I'm loading an IOT from another table already existing in Oracle.The PLSQL procedure tries to transform the following table:id , column-------, --------------1 , A1 , B1 , C2 , Xinto the following table (as IOT):id , column1 , column2-------, -------------- , ------------------1 , A , B 1 , C , NULL2 , X , NULLSo the procedure manages a cursor that sorts the first table by its id, and iterates over the rows trying to fill the row of the resulting table. This is performed by dynamically creating a string corresponding to the VALUES clause of an insert operation. When the id changes or the number of columns exceeds N, I insert the current row (EXECUTE IMMEDIATE) and start a new one. Additionally, I added a sequential number with the id to compose the PK due to its unique constraint.Moreover, according to the value of N (in the example, N = 2), I will perform a PIVOT operation limiting the number of columns. If the number of rows (with the same id) is greater than N, other rows are allocated to store that. The only index/constraint is the primary key, which I think is required for the IOT approach.Following your advice, I will test the parallel and append hints and use the NOLOGGING feature. Moreover, I will further evaluate the possible database's bottlenecks with the AWR report.While evaluating the query processing, it is mostly I/O bound. Unfortionally I cannot alter the hardware of the machine.A (partial) solution that I adopted is generating a CSV file with the resulting table and loading it with SQLLDR. It works, but generating more than 20GB of data and copying it into the database seems redundant.
  27. 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!
  1. Load more activity
×