Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About burleson

  • Rank
    Advanced Member

Recent Profile Visitors

1,342 profile views
  1. Hi Satish and welcome to the forum! I have done this before, but these notes may help: https://oracle-base.com/articles/12c/multitenant-rman-backup-recovery-cdb-and-pdb-12cr1 Good luck!
  2. Oracle Forms 11g db connectivity issue

    Hi, and welcome to the forum! It sounds like the problem is inside the sqlforms app, and not within the database engine. Try this sqlforms forum: https://community.oracle.com/community/development_tools/forms Good luck!
  3. Hi Pratik, and welcome to the forum! i have never used the Erickson application, but there is no way to disable Oracle logins unless there were too many password attempts. you cannot login via sqlplus? You can also lock and unlock users with these commands: http://www.dba-oracle.com/t_passwords_locking_changing_expiring.htm http://www.dba-oracle.com/concepts/alter_users.htmI I would contact the application vendor for support. Good luck!
  4. DBUA to upgrade from 10gR2 to 12cR2

    Hi, And welcome to the forum! To be safe, I always go through each intermediate release. Each release has data dictionary updates, and the safe way is to migrate to 11g and then 12c: However, there are tricks for upgrading with multiple releases: This may help: https://gavinsoorma.com/2014/12/minimal-downtime-database-upgrade-from-oracle-10g-to-oracle-12c/ http://www.dba-oracle.com/t_goldengate_upgrade_to_oracle12c.htmGood luck!
  5. Hi Sam, and welcome to the forum! this is a DBA forum, but I think your best approach is to use substr with regexp_count See this example here: http://www.dba-oracle.com/t_regexp_count.htm Good luck!
  6. Hi, and welcome to the forum! Here is how I use Rman to backup on multiple channels: http://www.dba-oracle.com/t_oracledataguard_286_rman_commands.htm Hope this helps. . .
  7. complex query and aggregate function in Materialized view

    Hi Kanha, and welcome to the forum! I have some good notes on this: http://www.dba-oracle.com/t_with_clause.htm http://www.dba-oracle.com/t_materialize_sql_hint.htm
  8. Hi, and welcome to the forum! First, separate the query from the create materialized view statement. If the query takes the most time, try using parallel query to increase build time. Here are my notes on creating a materialized view with the atomic clause: http://www.dba-oracle.com/t_materialized_view_atomic_refresh.htm Hope this helps. Good luck!
  9. Hi Luveshan, This is an Oracle forum, but I have been aa DBA since 1983, and I can say that moving from ms-sql is a good thing!! You may want to ask this in a MySQL forum. Good luck!
  10. How to check blocking queries in SQL Server?

    Hi, mi think that this sql server script collection may have what you want http://www.dba-sql-server.com/sql_server_scripts.htm
  11. Oracle EBS Session Table

    Hi Rotan, and welcome to the forum! We are a DBA forum, you need a EBS forum: https://community.oracle.com/community/orac...-business_suite Good luck!
  12. Recommended Option for Max_Dump_File_Size

    Hi Simon, and welcome to the forum! I find that it is best to monitor the diag directories from the OS level! I use a cron to poll the directory fullness, and when it crosses 90%, I automatically remove the oldest trace files! Please read: http://www.dba-oracle.com/t_windows_monito...trace_files.htm Good luck!
  13. SQL Developer slow to load some user's table lists

    Hi Emol, Many thanks for posting the solution!
  14. instance caging

    Hi Rama, The best way to measure cpu is with OS utilities like. Inside oracle, use statpack (or awr) snapshots to see relative cpu consumption: http://www.dba-oracle.com/t_awr_report_cpu.htm Good luck!
  15. instance caging

    Hi Rama, and welcome to the forum! First, make sure that you have a good reason for instance caging! I rarely see a reason for it since sharing CPU resources is a good thing! You have ten databases sharing 40 processors, that is a good thing! The only reason to cage is when one database consumes all of the processors! If you cage, you also lose the power of parallel query. Lastly, if you cage, one database may be starved for CPU while the other processors sit idle, a real waste! Here is how I do instance caging: http://www.dba-oracle.com/t_instance_caging.htm Also, VMware is a way to segregate processing resources: http://www.dba-oracle.com/t_vmware.htm Good luck!