Jump to content

burleson

Members
  • Content count

    13,395
  • Joined

  • Last visited

Community Reputation

0 Neutral

1 Follower

About burleson

  • Rank
    Advanced Member

Recent Profile Visitors

3,553 profile views
  1. burleson

    10046 trace

    Hi Raj, and welcome to the forum! Depending on your OS, you will find the file in your trace/dump directories. see here for details; http://www.dba-oracle.com/t_find_trace_file.htm Hope this helps. . .
  2. burleson

    AWR snapshots on ADG

    Hi Zaw, and welcome to the forum! You can easily check your AWR setting on the ADG instance: http://www.dba-oracle.com/t_awr_automatic_snapshot_settings_modify.htm AWR is usually enabled at install time and you can check your retention period. Please read: http://www.dba-oracle.com/t_awr_retention_period.htm Hope this helps . . .
  3. Hi, and welcome to the forum! First you need to test your connectivity via tnspimg and sqlplus. Please read: http://www.dba-oracle.com/teas_prae_util23.htm If you can connect in sqlplus, you will need to check other factors: http://www.dba-oracle.com/t_enterprise_manager_unable_to_connect_to_db_instance.htm Finally, see MOSC, there are known issues with Firefox in 12c: http://support.oracle.com Hope this helps. . .
  4. burleson

    Index Full Scan

    Hi Vidhu, and welcome to the forum! Based the specific where clause in your SQL, the optimizer realized that an index range scan was less expensive than an index fast full scan. Also, what release are you on, and what are your optimizer parameter values? http://www.dba-oracle.com/t_sql_optimizer_parameters.htm You can verify that the optimizer made the best choice by forcing an index fast full scan with the index_ffs hint! http://www.dba-oracle.com/t_index_fast_full_scan.htm Hope this helps . . .
  5. Hi, and welcome to the forum! Just curious, how big was this table? A CTAS always does a full table scan, but not setting db_cache_size defaults to only 64K! Always remember, Disk I/O is in milliseconds, the most expensive operation in any database! Hope this helps!
  6. Hi Franz, and welcome to the forum! Can you please post your query syntax? This might help, have a gander: http://www.dba-oracle.com/t_advanced_sql_first_last_value.htm
  7. burleson

    Advantage of Oracle Goldengate over Streams

    Hi, and welcome to the forum! Good question! Goldengate is like a Ferrari, and Streams is a Volkswagen. They will both get you to your destination, but in different ways! See here: http://dba-oracle.com/googlesearchsite_proc.htm?cx=000522505899594707971%3A4-ldikxixw4&cof=FORID%3A10&ie=UTF-8&q=Streams+GoldenGate+&sa=Search&siteurl=www.dba-oracle.com%2Ft_streams_desupported_goldengate.htm&ref=www.google.com%2F&ss=9595j6481019j18 Good luck!
  8. burleson

    Exporting 700gb data - Recommendations Needed

    Hi again, What is the mapping of data files to tablespaces to tables? I would expect that this monster table resides in it’s own tablespace, and the tablespace consists of many data files. Please advise . . . Thanks!
  9. burleson

    RMAN bkp full "stupid" question

    Hi, The rule is to only nuke archived redo logs after you have a fully recoverable savepoint. Disk is super cheap, just keep them!
  10. burleson

    Exporting 700gb data - Recommendations Needed

    Hi Richard, and welcome to the forum! Wow! 700 gig is a monster! expdp is not a fast table copy method. Will making a copy of the table over a database link work for you? http://www.dba-oracle.com/t_fast_copy_data_oracle_table.htm If the table is in it’s own tablespace, then it is easier! Did you set parallelism to cpu_count-1? http://www.dba-oracle.com/t_optimal_parallel_degree.htm Sad to say, but “time takes time”, but I don’t know how the data blocks are laid out? Are you using ASM? Partitioned tables? This is a tough question! I have a fast clone method: http://www.dba-oracle.com/oracle_tips_db_copy.htm But maybe you need a third party tool like Delphix? I have never used it, but I heave that it is great for high speed data cloning. https://www.delphix.com/blog/data-virtualization/what-delphix Once you get a copy, have you considered SSD storage? Copying from SSD is 300 to 600 times faster than platter disk: http://www.dba-oracle.com/t_ssd.htm Hope this helps. . .
  11. burleson

    select Long Raw??

    Thanks for posting the tip!
  12. burleson

    How to create stored procedure in package

    Huh? I don’t understand your question! Just write the stored procedures you want and then encapsulate them into a package! Do you understand how to write DML? if you don’t understand PL/SQL, Try this reference: http://www.rampant-books.com/book_1701_plsql_definitive_ref.htm Good luck!
  13. burleson

    RMAN bkp full "stupid" question

    Hi, This is not a stupid question! First, what kind of backup are you taking? Cumulative, incremental? Please review: http://www.dba-oracle.com/t_rman_backup_types.htm If archive logs are deleted, the safe approach is a full cold backup, or a full hot backup. These types of RMAN backups only needs archived redo logs that are created after the backup begins. For the full story, see this great RMAN book: http://www.rampant-books.com/book_1002_rman_backup_recovery.htm Good luck!
  14. burleson

    How to create stored procedure in package

    Hi, and welcome to the forum! Procedues and functions are created, and then encapsulated into packages. Please read: http://www.dba-oracle.com/t_create_package_body.htm Hope this helps . . .
  15. burleson

    Trace file

    Hi Linda, and welcome to the forum! Using 100% CPU is not a problem, the server is designed to ramp up fast! http://www.dba-oracle.com/t_high_cpu.htm http://www.dba-oracle.com/t_cpu_utilization_metrics.htm If the task runs for more than a few minutes, take a AWR or statspack report in a one minute interval! That will tell you what is happening! http://www.dba-oracle.com/t_taking_awr_statspack_snapshot.htm
×