Search Discussions

69 discussions - 201 posts

  • Oh, and perhaps one other piece of advice I personally would pass along to junior DBAs... Start using sql*plus as much as you can, and write your own set of scripts for it. Because in doing so you ...
    Stefan KnechtStefan Knecht
    Dec 23, 2010 at 7:14 am
    Dec 31, 2010 at 3:23 am
  • hi, well, for a wannabe your quite good analyzing. I'd glad to have some wannabes like you.. first: the high free buffer waits indicates that you're reading a lot from disk. As the dbw usually writes ...
    Dec 7, 2010 at 4:57 pm
    Dec 9, 2010 at 2:14 pm
  • Hi All, I am asking for some help on this urgent standby db error. Problem Description: I added 3 new datafiles on my production instance. The resulting redo logs were shipped to my standby ...
    Guang MeiGuang Mei
    Dec 22, 2010 at 2:47 pm
    Feb 3, 2011 at 10:04 pm
  • Hi List I have a client with storage technology that allows copy on write snapshots to create a writeable copy of a storage volume. They are looking at potentially using this technology to provision ...
    Niall LitchfieldNiall Litchfield
    Dec 20, 2010 at 12:07 pm
    Dec 23, 2010 at 12:15 am
  • Mark, Yeah, I realized my goof with logminer as soon as I sent it. =) Oh well. Fortunately, I am not overly worried about the overhead associated with SQL_TRACE; that is an interesting idea. I am not ...
    Charles SchultzCharles Schultz
    Dec 15, 2010 at 1:31 am
    Dec 16, 2010 at 5:26 pm
  • In the recent past we have come across of an exact situation but managed to convince the management to go for Data Guard instead of EMC SRDF. Regards, Jaffar -- Best Regards, Syed Jaffar Hussain ...
    Syed Jaffar HussainSyed Jaffar Hussain
    Dec 2, 2010 at 2:53 pm
    Dec 21, 2010 at 10:24 am
  • You can use rman duplicate command with skip tablespaces command. From: Sandra Becker To: oracle-l Date: 23/12/2010 01:00 PM Subject: Critical data recovery 10gR2 Sent by ...
    Dec 23, 2010 at 6:14 pm
    Dec 27, 2010 at 2:09 pm
  • Martin, Even if there's no technical reason involving the Oracle optimizer, it just makes sense to write code that's easily maintainable and understandable. I would consider mixing the syntax like ...
    Ron CriscoRon Crisco
    Dec 22, 2010 at 2:20 pm
    Dec 25, 2010 at 4:30 am
  • Hi all, I'm just now starting to look at APEX, literally 3 days ago. So far I haven't done anything fancy, but exploring the interface it seems you ought to know about web 2.0 technology as well ...
    Martin BachMartin Bach
    Dec 17, 2010 at 8:13 am
    Apr 1, 2011 at 7:06 pm
  • Thanks to Ilmar and Tim for the scripts. This should get me where I need to go. WGB -----Original Message----- From: oracle-l-bounce_at_freelists.org On Behalf Of Ilmar Kerm Sent: Monday, December ...
    Blanchard, William GBlanchard, William G
    Dec 21, 2010 at 9:12 pm
    Dec 23, 2010 at 6:22 pm
  • Hi List, We have a requirement in generating triggers for a set of configured tables in our database ( Oracle 10g) . I am thinking to write a procedure which reads the table names configured and ...
    Sreejith S NairSreejith S Nair
    Dec 6, 2010 at 12:10 pm
    Dec 7, 2010 at 12:46 am
  • Hi, I've a requirement for our internal testing. I need to create a RAC database with 2 instances in a single server without using VMWare or something else. Its like, i'll install the clustureware in ...
    Sandeep Kumar BSandeep Kumar B
    Dec 23, 2010 at 12:53 am
    Dec 27, 2010 at 11:19 am
  • Hi All, We have Oracle 10g dataguard configuration - primary and DR site. Per day 3G logs are transferred to DR site.It fully utilize the network bandwidth.(2MBPS) Is there any possible way for an ...
    Dec 22, 2010 at 2:57 am
    Dec 22, 2010 at 4:56 pm
  • Kerberos is your answer. Metalink and oracle has notes. And yes, it even works, done that myself. You login like that in SQLNav, Oracle Forms, sqlplus: connect / That's it. Then oracle works just ...
    Dec 21, 2010 at 10:47 am
    Dec 21, 2010 at 5:38 pm
  • Hi, List, Lately I installed a agent on an RAC cluster, all discovered targets showed up fine in grid control except the ASM instances, which showed up as "unknown" in grid ...
    Li LiLi Li
    Dec 15, 2010 at 9:14 pm
    Dec 16, 2010 at 7:10 pm
  • Does anyone know, how are flash card failures monitored on Exadata storage server? Also does anyone has the links to Exadata documentation? Oracle seems to have hidden it from public. Is it available ...
    Vishal GuptaVishal Gupta
    Dec 2, 2010 at 11:13 am
    Dec 4, 2010 at 1:57 pm
  • Hello, Kind of out of left field here but I was curious about how many people here use Synonyms and the types of synonyms they are normally using, i.e; table/view/column? Sincerely, Joshua D. Drake ...
    Joshua D. DrakeJoshua D. Drake
    Dec 1, 2010 at 12:31 am
    Dec 2, 2010 at 12:38 pm
  • Well after pointing my web browser to the pass4sure website I did find prices next to the exams. I suggest you might want to purchase the training material, or did you ask the list to provide a ...
    Martin BachMartin Bach
    Dec 30, 2010 at 10:36 am
    Dec 30, 2010 at 5:55 pm
  • Hi, I recently checked this new oracle feature and come to a conclusions that 'oracle restart' doesn't restart automatically resources (e.g. listener) if being stopped manually using regular tools ...
    Goran bogdanovicGoran bogdanovic
    Dec 27, 2010 at 10:50 am
    Dec 27, 2010 at 5:29 pm
  • Hello All, We have an Oracle 10gAS middle-tier server that connects to an Oracle database in dedicated server mode. A consultant told me that in shared server mode the Oracle dispatcher will ...
    Sam BootsmaSam Bootsma
    Dec 21, 2010 at 9:51 pm
    Dec 22, 2010 at 1:35 pm
  • Tim & Andreas I do know this, and it actually gives more flexibility, but it still remains the case that oracle's best database based dev tool *by default* rejects sql statements in code that run in ...
    Niall LitchfieldNiall Litchfield
    Dec 20, 2010 at 6:17 pm
    Dec 20, 2010 at 7:30 pm
  • If anyone want to have fun, just run this simple testcase: use your rdbms binaries (linux and hp-ux tested, but others will also work). create a small pfile: db_name=test db_block_size=2048 ...
    Martin BergerMartin Berger
    Dec 17, 2010 at 5:29 pm
    Dec 17, 2010 at 5:57 pm
  • Did this impact *every* query accessing this table? What were the differences in the execution plans? What were the differences in the execution profiles (changes in physical i/o, consistent gets, ...
    Daniel FinkDaniel Fink
    Dec 8, 2010 at 10:48 pm
    Dec 12, 2010 at 11:13 pm
  • How large is the alert.log that you consider using parallel query ? Hemant K Chitale http://hemantoracledba.blogspot.com sent from my smartphone On Dec 9, 2010 7:04 AM, "Lei Zeng" wrote: Hi: I have ...
    Hemant K ChitaleHemant K Chitale
    Dec 9, 2010 at 12:01 am
    Dec 10, 2010 at 12:38 am
  • If you need to audit objects on database level, you'll have to write several triggers: http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14251/adfns_triggers.htm#CHDGIJDB for each of ...
    Igor NeymanIgor Neyman
    Dec 6, 2010 at 7:17 pm
    Dec 9, 2010 at 12:33 am
  • yes, if load and HA is not that much then RAC is not required do think of keeping database on one host and appliations on another host additioanlly implement parallel concurrent processing (PCP) then ...
    Subodh DeshpandeSubodh Deshpande
    Dec 2, 2010 at 2:54 pm
    Dec 6, 2010 at 11:51 am
  • All, will appreciate any urls/links for any whitepapers/docs for setting up /managing/troubleshooting logical standby . Thanks in advance Kart -- http://www.freelists.org/webpage/oracle-l
    K RK R
    Dec 3, 2010 at 12:59 am
    Dec 4, 2010 at 12:30 am
  • Hi, We are trying to install the latest GI on a Solaris 10 box. During the linking stages of the install it threw errors so we tried re-linking, but that has not helped. This is what I see in the ...
    Peter HitchmanPeter Hitchman
    Dec 2, 2010 at 10:37 am
    Dec 2, 2010 at 3:15 pm
  • <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" Stephan, Only interesting thing I can see is that the only reason the ALL_ALL_TABLES view is being referenced is to determine if the ...
    Tim GormanTim Gorman
    Dec 1, 2010 at 9:26 pm
    Dec 2, 2010 at 1:16 pm
  • Hi, Yesterday, after adding a datafile to a busy system, performance degraded. Run the ASH report during problem period, noticed a SQL with sql_id=6s8fdgnw2u49h as the top SQL ...
    Dec 1, 2010 at 12:53 am
    Dec 1, 2010 at 1:36 am
  • I may be misunderstanding something here, but I was under the impression based on what I've read that if you want to exclude objects from being flashbackable then you would put them in a tablespace ...
    Dan PeacockDan Peacock
    Dec 28, 2010 at 2:56 pm
    Dec 28, 2010 at 3:07 pm
  • I'm mainly a MySQL dba now, but I got a request today to find out if it's possible to install the 9.2 Instant Client on Linux RHEL5. From what I've found, not only is it not available for RHEL5 but ...
    Walt WeaverWalt Weaver
    Dec 28, 2010 at 2:38 am
    Dec 28, 2010 at 3:38 am
  • Hi all I was wondering if we can limit parallel slaves spawned per session. I know that with database resource manager we could do it but it seems to me that we must have different CPU for each ...
    Dec 17, 2010 at 11:16 am
    Dec 20, 2010 at 9:27 am
  • Mostafa, If you can pry some funding loose, you might look at BEZVision (http://www.bez.com/bez-db_tour.htm). Have worked with, not for, the company before on earlier versions and it's damn good ...
    Goulet, RichardGoulet, Richard
    Dec 15, 2010 at 6:11 pm
    Dec 19, 2010 at 7:15 am
  • The best I could find was: Requirements: Maximum CPU - 2 sockets RAM - OS Max Database Size - no limit Windows, Linux, Unix, 64-Bit Support ...from ...
    Stephens, ChrisStephens, Chris
    Dec 16, 2010 at 6:49 pm
    Dec 16, 2010 at 11:35 pm
  • Hello Everyone, We did a switchover to the backup site past weekend and then switched back to the primary site. After the switchback, the recovery process on the standby site failed with the ORA 600 ...
    Gupta, Deepender KGupta, Deepender K
    Dec 13, 2010 at 5:53 pm
    Dec 14, 2010 at 4:46 pm
  • A quick update. Oracle support called me and asked me to try setting the environment to the auxiliary instance instead of target. And voila, the error is gone! rman target sys/xxxx_at_mytarget ...
    Yong HuangYong Huang
    Dec 13, 2010 at 5:12 am
    Dec 13, 2010 at 10:54 pm
  • Hello, Rich, Brandon, Jared, Jack, Thank you for the feedback on the Oracle Database 11g: Interactive Quick Reference (IQR) that my team produced. At this point in time, it is by no means a ...
    Jenny Tsai-SmithJenny Tsai-Smith
    Dec 9, 2010 at 7:37 pm
    Dec 10, 2010 at 10:10 pm
  • Good day everyone, We are in need of preparing a backup server for one of the business critical RAC databases at our company. Since the DRC setup will take some considerable time, application owner ...
    Syed Jaffar HussainSyed Jaffar Hussain
    Dec 8, 2010 at 1:29 pm
    Dec 8, 2010 at 2:45 pm
  • Oracle SunOS 5.10 Hi, We regularly run a script to update multilingual data in an index-organised table. The script deletes records with a particular key, then runs lots of individual insert ...
    Dec 8, 2010 at 9:56 am
    Dec 8, 2010 at 10:14 am
  • Ah, I probably have not encountered problems with it because I normally create a service name to match the alias. Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog ...
    Jared StillJared Still
    Dec 7, 2010 at 2:01 am
    Dec 7, 2010 at 2:43 am
  • Hi all, Oracle on Windows 2K3. I can't figure out what I am missing in the following. Could you please help. CREATE TABLE wm_trans ( TRAN_TYPE VARCHAR2(3 BYTE), TRAN_CODE VARCHAR2(3 BYTE), ...
    Eugene PipkoEugene Pipko
    Dec 6, 2010 at 10:57 pm
    Dec 6, 2010 at 11:09 pm
  • Don't forgot Good Book about SQL. SQL and Relational TheoryHow to Write Accurate SQL Code ByC. J. Date http://oreilly.com/catalog/9780596523084/ and video http://oreilly.com/catalog/0636920002710 ...
    Surachart OpunSurachart Opun
    Dec 3, 2010 at 6:11 pm
    Dec 6, 2010 at 9:52 am
  • Well when you see ASH/AWR report it has to display some information as top five even you are ideal. Other point if my query has to read all blocks with FTS then how can you avoid this. But one thing ...
    Taral DesaiTaral Desai
    Dec 1, 2010 at 8:26 pm
    Dec 5, 2010 at 3:14 pm
  • So no one runs VMs on Windows laptops? I am actually shopping for one right now, but both experiences here are Mac and I also noticed on recent webinar from Tanel/Cary/Kerry I think at-least two of ...
    Dec 5, 2010 at 2:09 am
    Dec 5, 2010 at 4:42 am
  • Just to add some questions: if the messages below represent "normal" application connection requests that use already established connection pool physical connections, why the port, assigned by the ...
    Radoulov, DimitreRadoulov, Dimitre
    Dec 2, 2010 at 10:35 pm
    Dec 3, 2010 at 4:01 am
  • Just to add that you'll need Perl (to emulate the GNU date usage in the original script). This shouldn't be a problem though, with a properly set environment, you should have access at least to the ...
    Radoulov, DimitreRadoulov, Dimitre
    Dec 28, 2010 at 10:45 am
    Dec 28, 2010 at 10:45 am
  • Your example doesn't exhibit anything strange to me. In your example this does happen: the scalar subquery, as is the function call, is executed four times. Scalar subqueries that appear in the ...
    Toon KoppelaarsToon Koppelaars
    Dec 28, 2010 at 4:44 am
    Dec 28, 2010 at 4:44 am
  • A client recently upgraded one of their databases from 10gR2 to 11gR2, but have left the compatible parameter to 10.2.0 in case they needed to downgrade. They will be bouncing the system in January ...
    Daniel FinkDaniel Fink
    Dec 27, 2010 at 2:21 pm
    Dec 27, 2010 at 2:21 pm
  • My bad in writing this message. This was a log range starting 21925 -- 21936 and everyone in between. -- http://www.freelists.org/webpage/oracle-l
    Dec 22, 2010 at 3:28 pm
    Dec 22, 2010 at 3:28 pm
Group Navigation
period‹ prev | Dec 2010 | next ›
Group Overview
grouporacle-l @

99 users for December 2010

: 11 posts Jared Still: 9 posts Niall Litchfield: 8 posts Subodh Deshpande: 6 posts Amaral, Rui: 5 posts Goulet, Richard: 5 posts Harel Safra: 5 posts OKH: 5 posts Yong Huang: 5 posts Laimutis.Nedzinskas_at_seb.lt: 4 posts Martin Bach: 4 posts Nuno Souto: 4 posts Radoulov, Dimitre: 4 posts Taylor, Chris David: 4 posts Vishal Gupta: 4 posts Andrew Kerber: 3 posts Daniel W. Fink: 3 posts David Roberts: 3 posts Goran bogdanovic: 3 posts Gus Spier: 3 posts
show more