Jump to content

All Activity

This stream auto-updates     

  1. Today
  2. Hi Sanjay, Yes, setting OICA to 10 should force index usage, but ONLY until you find and fix the real cause of the problem. This is only a stopgap measure.
  3. Yesterday
  4. this values is already set to 100, do you want me to decrease it ? SQL> show parameter optimizer_index_cost_adj NAME TYPE VALUE ------------------------------------ -------------------------------- ------------------------------ optimizer_index_cost_adj integer 100 SQL>
  5. Last week
  6. burleson

    Which one is better, Oracle DBA or SQL DBA?

    Traditionally, Oracle DBA’s earn far more because Oracle is robust and complex.
  7. Since Oracle has more configurations to do during setup/installation, this task it usually left to the Oracle DBA
  8. Hi Sanjay, Why did you did not notice this when you upgraded your test instance? First, you were right in disabling OPTIMIZER_ADAPTIVE_FEATURES! This is a common issue, and I have notes here: http://www.dba-oracle.com/t_12c_upgrade_slow_performance.htm As a temporary stopgap, you can set optimizer_index_cost_adj to a value of 10: Please read this carefully: http://www.dba-oracle.com/oracle_tips_cost_adj.htm Good luck!
  9. burleson

    alter user sys password question in 12cR2 database

    Hi Rich, Many thanks for posting the answer! Take care . . .
  10. Hi Arasu, Are you seeking someone to write this for you? If so, call 800-766-1884.
  11. richchen65

    alter user sys password question in 12cR2 database

    Hi Don, This problem will happen after applying 2018 JULY PSU (Bug 28538439) .. The solution: 1. Apply 2018 OCT PSU patch (Patch No# 28662603) 2. Apply Bug 28538439 hotfix 3. Setting hidden parameter _enable_ptime_update_for_sys=TRUE and restart the database. The solution works for me. Thank you for running this forum for all Oracle experts around the world. Rich
  12. catherine12297

    Advantage of Oracle Goldengate over Streams

    Oracle Streams is a built-in feature of the Oracle Database that allows information sharing among multiple Oracle databases. With Oracle Streams, transaction changes and events are captured, propagated and applied within an Oracle database or between Oracle databases, creating a flexible replication solution for a homogeneous all-Oracle environment. Given the strategic nature of Oracle Golden Gate, Oracle Streams will continue to be supported, but will not be actively enhanced. Rather, the best elements of Oracle Streams will be evaluated for inclusion with Oracle Golden Gate.
  13. Facing huge performance issue with all sessions after upgrade from 10.2.0.5 to 12.1.0.2 recently. DB is single instance only and after upgrade all session taking more than expected time. 1. 4-5 min query taking around 1 hour and more. 2. All queries doing lots of IO as compare to old report. 3. CPU reaching to 100% every time. 4. Most Important thing is after upgrade database is not using old indexes and even tuning and access advisor not suggesting to create new indexes. Steps I already implemented are as below. SQL> show parameter DISK_ASYNCH_IO NAME TYPE VALUE ------------------------------------ -------------------------------- ------------------------------ disk_asynch_io boolean TRUE SQL> show parameter _optimizer_aggr_groupby_elim NAME TYPE VALUE ------------------------------------ -------------------------------- ------------------------------ _optimizer_aggr_groupby_elim boolean FALSE SQL> show parameter _optimizer_reduce_groupby_key NAME TYPE VALUE ------------------------------------ -------------------------------- ------------------------------ _optimizer_reduce_groupby_key boolean FALSE SQL> show parameter optimizer_dynamic_sampling NAME TYPE VALUE ------------------------------------ -------------------------------- ------------------------------ optimizer_dynamic_sampling integer 0 NAME TYPE VALUE ------------------------------------ -------------------------------- ------------------------------ optimizer_adaptive_features boolean FALSE SQL> show parameter OPTIMIZER_ADAPTIVE_FEATURES NAME TYPE VALUE ------------------------------------ -------------------------------- ------------------------------ optimizer_adaptive_features boolean FALSE Please suggest ASAP as this prod DB and we getting WAR room on daily basis.
  14. Hi Burleson, I tried but getting error error occurred in xml processing invalid number
  15. Hi Arasu, and welcome to the forum! You can easily achieve this using PL/SQL by looping through with a FOR loop, querying all_tab_columns, for all columns that have a string datatype. For each table name, you use “execute immediate”, building the SQL statement that looks for your string, using the table_name and column_name. See example here: https://lalitkumarb.wordpress.com/2015/01/06/sql-to-search-for-a-value-in-all-columns-of-all-atbles-in-an-entire-schema/ As to performance, there will be a full table scan of strings in all_tab_columns. This can be made faster using parallel hints in the generated SQL. Good luck!
  16. I have around 2000 tables in my oracle database. whatever the user enters in search page, I should search that value in all fields of all tables of database. My database contains several millions of records. Performance is an import point to consider. I am looking for a solution. Could someone help
  17. burleson

    alter user sys password question in 12cR2 database

    Hi Rich, Yeah, I understand your issue, and your real-world observation demonstrates that Oracle has changed the mechanism for tracking password changing for the SYS user. Again, I have not seen this, but I believe you! I researched this on the web and I found nothing, sorry. Can you use the MOSC bug database? It could be a bug, but I recommend that you report your observation to MOSC via a service request. Again, sorry that I could not help, but i’m Sure that Oracle support can help: http://support.oracle.com Let us know what you find. Good luck!
  18. richchen65

    alter user sys password question in 12cR2 database

    Hi Don, I think I didn't describe the question clearly. This question is from the internal auditors who will check the password changing policy is enforced or not. They rely on the timestamp in PTIME column of sys.user$ to determine if the password was changed periodically. Prior to 11gR2 , the timestamp in PTIME of SYS will be updated soon after the password was changed but not in 12cR2. In 11gR2: SQL> alter user sys identified by xxxx; --- Done without error SQL> select ctime, ptime From sys.user$ where name = 'SYS'; --- Ptime will be the password changed time In 12cR2: SQL> alter user sys identified by xxxx; --- Done without error SQL> select ctime, ptime From sys.user$ where name = 'SYS'; --- Ptime will NOT be changed ..in my case , same as ctime Rich
  19. burleson

    What hardware to practice on?

    Hi, ideally, a server with multiple CPU’s would help you study parallel operations and data warehouse operations. As for RAM, it’s cheap to get many gig of storage, and getting SSD would also be useful! If you want to learn RAC you will need two little servers. Be careful, they must meet the certification requirements: http://www.dba-oracle.com/t_rac_hardware_compatibility.htm Server specs change all the time, and I don’t know of mini server technology! Sorry that I cannot be more help. Good luck!
  20. burleson

    Pre insttal of Oracle 18c

    Hi, The 18c preinstall steps for Windows are here https://docs.oracle.com/en/database/oracle/oracle-database/18/ntdbi/index.html Good luck!
  21. IAMADBA

    What hardware to practice on?

    Hello all, I want to buy computer hardware/equipment in order to practice my DBA skills, install 12c, Linux, etc. What is a good one to buy? Any suggestions? I currently have nothing. Thanks.
  22. btidba

    Pre insttal of Oracle 18c

    Hi, I am about to upgrade my Windows Oracle server 11.2.0.4 to 18c,i have read that I should insure before doing this installation some pre-requisites must be checked. There is a preinstall package for Linux ,how about Installing 18c under Windows ?is there any similar package? If yes then please advise how to install it. Thanks!
  23. btidba

    How to apply correctly some known patches

    Hi Thank you! Regards
  24. burleson

    alter user sys password question in 12cR2 database

    Hi Rich, Sorry, I cannot find any changed behaviors in 12c r2 for the prime column in SYS.user$. Could this be a PDB vs CDB issue? This query has always worked for me: select name, ctime, ptime FROM sys.user$ WHERE name = 'SYS'; Please see if you can document this new behavior in a script, and share it with us! Good luck!
  25. Dear Oracle experts, The password changed time will be recorded in the column (Ptime ) in sys.user$ prior to 11gR2 . I found out the Ptime value won't be updated in 12cR2 after the sys password was changed. Any idea ? Rich
  26. burleson

    How to login

    Hi, You make a good point about the degree requirements, but the median Oracle DBA job pays over $100,000 per year, and it’s rare to snag a good job without a four year degree. It’s competitive! i’m sorry If I sounded insulting, but there are loads of kids who take two week DBA boot camps and then are told that they can expect high paying jobs! I assume that as a CPA you have a degree. As for certification, the OCP used to be designed such that you would not pass without work experience. When I got certified, Oracle required proof of at least fours of full time job experience, but that was dropped. FYI, here are the minimum requirements to consult for us: http://www.dba-oracle.com/jobs.htm Note that a BS in business satisfies our requirements. Please feel free to post new questions here! Good luck! PS - With a CPA, you could be a stellar “Oracle Applications DBA”. The only barrier to entry is finding food eBusiness Suite training. I have some notes here: http://dba-oracle.com/googlesearchsite_proc.htm?cx=000522505899594707971%3A4-ldikxixw4&cof=FORID%3A10&ie=UTF-8&q=Dba+applications+&sa=Search&siteurl=www.dba-oracle.com%2Ft_roles_granted_user.htm&ref=www.google.com%2F&ss=4829j3061175j12
  27. IAMADBA

    How to login

    Thank you for your quick response and assistance. I will check those links to digest that information. I know a lot of people who are Oracle DBAs and they don't have a college degree or if they do, they say it doesn't translate to DBA work. I know one person who only went to High School and he's been a DBA for 8 years. Given this data, this is why I thought there was no reason that I could not also become an Oracle DBA. I study every day and refer to the dba-oracle.com website frequently. I plan to take the OCA exam as well. This exam does not require a Bachelor's degree. In addition, I read a lot of job postings for DBAs and none of them ask to complete six months of Oracle University classes. So far I am understanding Oracle database pretty well and I have even typed over 100 pages of notes this past summer and posted them online for anyone to refer to. I am already a CPA in the United States but I find IT much more interesting than Accounting. This is why I chose to switch. I have seen some General Ledger and E-Business/Fusion books from Oracle so maybe there is a job out there where I can blend Oracle and CPA. I have to see what direction I should go in. Thank you for your time.
  1. Load more activity
×