Search Discussions

191 discussions - 1,096 posts

  • Hello, does anyone know of any tool that would take input from (preferably a table and) a query and help generate nice eye candy. I want something like Quest spotlight, but more resource friendly ...
    Apr 13, 2007 at 12:20 pm
    Apr 18, 2007 at 10:46 am
  • I am using RMAN without the repository. I want to plan in case we have a total site loss and all I have left are my tape backups which are all compressed backupsets. So my control files with my ...
    Apr 17, 2007 at 8:42 pm
    May 7, 2007 at 5:32 pm
  • My manager is proposing to cluster two Solaris 5.9 servers in order to create a "high availability" solution. At this stage he is a bit unclear as to what software he would be using for the cluster, ...
    Schauss, PeterSchauss, Peter
    Apr 11, 2007 at 8:24 pm
    Apr 17, 2007 at 12:44 am
  • Does any implement this type of maintenance on indexes regularly? Theoretically, this should be good practice on tables that witness large number of updates or deletes. For those who do not, can you ...
    Apr 10, 2007 at 3:39 pm
    Apr 18, 2007 at 7:36 pm
  • Folks What could be the approach to Convert a Large 3 TB NON-RAC Production Database with Datafiles existing on cooked/Mounted Filesystem (UFS) to a 3 instance RAC using "ASM"? NOTE - Production ...
    Apr 18, 2007 at 7:09 am
    Apr 22, 2007 at 6:53 am
  • Folks An internal Test Database has 1 of it's Tablespace's of 700 GB which in turn Contains only 1 Table. What is the ideal Approach to DROP the same? Personally I think the following approach is ...
    Apr 23, 2007 at 8:04 pm
    Apr 25, 2007 at 6:21 pm
  • Hi all, I got a requirement from the developers to build a new table which has a column that will hold every second of every business day. That is the only column in the table. The table will be ...
    Ram RamanRam Raman
    Apr 23, 2007 at 7:11 pm
    Apr 25, 2007 at 6:56 pm
  • The president of the company would like to know how many transactions per month are running through the database. He wants to include all selects, inserts, updates, and deletes. What would be the ...
    Sandra BeckerSandra Becker
    Apr 11, 2007 at 4:23 pm
    Apr 12, 2007 at 1:48 pm
  • Hi Group, I have a question about dblink. I always hear that - dblinks are not good in production system. dblink, ohh!! not in critical production system dblink are not safe Can anybody please let me ...
    Thotangare, Ajay \(GTI\)Thotangare, Ajay \(GTI\)
    Apr 30, 2007 at 2:43 pm
    May 1, 2007 at 3:48 pm
  • Hello, I have been asked to set specific roles when a user logs into oracle from a specific application. Meaning if the user is using for example Toad we only want that user for that session to have ...
    Laura penaLaura pena
    Apr 4, 2007 at 2:26 pm
    Apr 13, 2007 at 1:34 pm
  • We need to set up a process where Oracle users (currently few and mostly ODBC using Access) are notified and can change their password dynamically every 90 days. We were wondering what other ...
    Apr 4, 2007 at 3:49 pm
    Apr 6, 2007 at 3:38 am
  • Hello. We do not seem to have a switch INST_ID for ALTER SYSTEM KILL SESSION command. So, if I need to kill the session, I necessarily need to login to the same instance in RAC. Has any of you have ...
    Shivaswamy RaghunathShivaswamy Raghunath
    Apr 12, 2007 at 7:27 pm
    Apr 14, 2007 at 5:35 am
  • Gurus, We all hear about Oracle books and manuals that we should read. What about non Oracle things we need to know to be a DBA? For eg couple of days ago David Litchfield posted a link to an Oracle ...
    Orlando LOrlando L
    Apr 9, 2007 at 4:14 am
    Apr 10, 2007 at 5:50 pm
  • Hello wise ones! I was just approached with a question/problem. A developer (not a DUHveloper, this guy is usually pretty good) wants to investigate using temporary tables for intermediate ...
    Stephen AndertStephen Andert
    Apr 3, 2007 at 8:29 pm
    Apr 5, 2007 at 5:29 pm
  • Yes, I know the first one is "use *nix" but I am tired of fighting about it and my boss made the decision. The main question I have is whether to create an oracle-specific account or just use an ...
    Stephen AndertStephen Andert
    Apr 10, 2007 at 5:28 pm
    Apr 20, 2007 at 1:21 am
  • Folks, I've got an odd problem on our production database where it seems physical writes and row lock waits are happening on SYS.DUAL. These are not causing any major performance problems, but it ...
    Herring Dave - dherriHerring Dave - dherri
    Apr 12, 2007 at 2:41 pm
    Apr 14, 2007 at 5:07 am
  • I *know* there is an RMAN report or a SQL query that can be run to show exactly which files will be needed to do a database restore. Problem is, I can't remember how to do it, and can't seem to find ...
    Jared StillJared Still
    Apr 12, 2007 at 4:26 pm
    Apr 13, 2007 at 5:29 am
  • Folks, I've got a rather aggravating query which performs "well" (45 min.) under CPUApr2006 but under CPUOct2006 it choses a "poor" path (around 4 1/2 hrs consistently). I'm working ...
    Herring Dave - dherriHerring Dave - dherri
    Apr 30, 2007 at 8:04 pm
    May 2, 2007 at 1:43 pm
  • My environment is an Oracle client running on Linux 2.6.9-42.Elsmp. We we try to run the Peregrine client we get: 10465 04/27/2007 05:54:14 Could not load shared library ./sqoracle.oci10.so ...
    Schauss, PeterSchauss, Peter
    Apr 27, 2007 at 6:45 pm
    May 1, 2007 at 2:05 pm
  • Greetings, I successfully completed the CRS installation and have moved on to Install Oracle and configure ASM. My first try encountered some problems and so I wanted to begin again and did the ...
    William WagmanWilliam Wagman
    Apr 4, 2007 at 10:59 pm
    Apr 5, 2007 at 7:09 pm
  • As an exercise, or thought experiment, how would I "throttle" (ie control the rate of) an Oracle Database session's I/O ? For CPU utilisation, I could use "nice" or "renice" but what about I/O ? We ...
    Hemant K ChitaleHemant K Chitale
    Apr 2, 2007 at 3:28 pm
    Apr 4, 2007 at 5:02 pm
  • hi all, what's the best & most robust package these days, whether Oracle supplied (DBMS_AQ?) or third party, to do asynchronous PL/SQL development (9i or 10g). I have various scenarios, multiple ...
    Cosmin IoanCosmin Ioan
    Apr 27, 2007 at 3:08 pm
    May 2, 2007 at 7:56 am
  • Are there any technical limitations in regards to running multiple databases across the same set of servers in the same cluster? -- http://www.freelists.org/webpage/oracle-l
    Ethan PostEthan Post
    Apr 30, 2007 at 7:19 pm
    May 1, 2007 at 11:40 pm
  • All I'm going to be talking about the perils of email notifications for Oracle databases next week - namely that you either don't monitor what you should, or you get drowned in alerts, often ...
    Niall LitchfieldNiall Litchfield
    Apr 17, 2007 at 3:08 pm
    Apr 18, 2007 at 4:16 pm
  • We have ORACLE version on LINUX server. I tried to export and import a user (schema) to another database. Does there has way just import schema's data, but not import procedures, functions ...
    Dba1 mccDba1 mcc
    Apr 17, 2007 at 6:44 pm
    Apr 18, 2007 at 12:02 am
  • If I am making tape backups and I am using redundancy 4. How do I restore older backups after the controlfile recycles? Or do I set control_file_record_keep_time to a sufficiently large number? do I ...
    Apr 10, 2007 at 7:40 pm
    Apr 13, 2007 at 5:45 am
  • Oracle, RHEL4 I know next to nothing about java so I don't know how to help one of my developers. He has a piece of java code that works when run on the production app server or using ...
    Sandra BeckerSandra Becker
    Apr 6, 2007 at 6:43 pm
    Apr 10, 2007 at 9:06 pm
  • I know Mark Strickland is using Business Objects, but not sure about who else. As a DBA, I often get requests to tune BO-generated queries, and so far they have all been fairly complex and ugly ...
    Charles SchultzCharles Schultz
    Apr 30, 2007 at 6:35 pm
    May 3, 2007 at 1:31 pm
  • Hi all: Is there a way in oracle (9i or 10g) to monitor access to the specific columns? I'd like to see which of the existing columns are never being accesses and remove them. Do I need to set up ...
    Apr 19, 2007 at 8:12 pm
    Apr 25, 2007 at 9:26 pm
  • Hi Can somebody suggest good method to delete all record older than 2 years from the current date. This script will run on the last sunday of each month. I will write the logic for Last sunday in ...
    Sanjay MishraSanjay Mishra
    Apr 20, 2007 at 1:07 am
    Apr 20, 2007 at 5:12 pm
  • Dear List: I have been compiling a list of limitiations that are imposed on RMAN when the catalog database is in the controlfile only. While Oracle recommends using a repository database, the ...
    Jared StillJared Still
    Apr 17, 2007 at 11:46 pm
    Apr 19, 2007 at 2:48 pm
  • How can you login with sysdba when SQLNET.AUTHENTICATION is set to NONE? We have a server that got put into a different domain. In order for users outside the domain to connect, we had to change ...
    J. DexJ. Dex
    Apr 13, 2007 at 3:46 pm
    Apr 17, 2007 at 12:51 am
  • Hi I had single instance Oracle 8i Database earlier and now new environment is created with Oracle 10g RAC. There are several perl program been used to perform some application and I appreciate if ...
    Sanjay MishraSanjay Mishra
    Apr 4, 2007 at 4:54 pm
    Apr 6, 2007 at 2:16 pm
  • We have TOAD 9.0 version. Can anyone tell me how to use TOAD to export table and save as format which EXCEL can accept (possible csv)? Thanks.
    Dba1 mccDba1 mcc
    Apr 26, 2007 at 2:08 pm
    Apr 26, 2007 at 6:23 pm
  • Can I refresh materialized view FAST when a primary table doesnt have a primary key ? As per oracle it should work with ROWID option while creating MV logs. SQL create table temp(no number); Table ...
    Chirag DBAChirag DBA
    Apr 20, 2007 at 12:50 am
    Apr 23, 2007 at 2:39 pm
  • Hi all, I have just started a new contract and our installation is largely sybase with some oracle servers knocking about. Today I was talking to one of my coworkers and we got into the 'it should ...
    David MossDavid Moss
    Apr 12, 2007 at 6:41 pm
    Apr 20, 2007 at 4:29 am
  • Guess the fun never ends. I'm (still) on Oracle on RHEL3, 32-bit. I have sga_max_size and sga_target set to 1456M. Nothing SGA related has been adjusted in a few months. One memory-related ...
    Don SeilerDon Seiler
    Apr 11, 2007 at 8:16 am
    Apr 18, 2007 at 5:05 pm
  • We've scoured the documentation and are still a little fuzzy :-) on this ... We're trying to convert some SQL*Loads from conventional to direct and the Oracle Documentation states that one of the ...
    Jonathan KnightJonathan Knight
    Apr 5, 2007 at 8:04 pm
    Apr 9, 2007 at 2:20 pm
  • We manage several non-production 10g databases that are currently shut down and backed up cold every weekend. We'd like to begin backing them up using rman, both to avoid these weekly shutdowns and ...
    Apr 5, 2007 at 7:11 pm
    Apr 6, 2007 at 12:56 pm
  • Hi all I'm trying to find out a way to deal with direct path read/write temp waits. I am loading a table as a select from another table insert /*+ append */ into table1 (select col1, col2, sum .. ...
    Apr 25, 2007 at 5:08 pm
    May 4, 2007 at 4:28 pm
  • Dear Gurus, Could you please help me with my questions below? if TX1 starts and commits (no matter what mode: immediate, wait, batch, nowait). after that TX2 starts and commits (whatever mode). are ...
    Jessica MaoJessica Mao
    Apr 25, 2007 at 7:37 pm
    Apr 27, 2007 at 7:23 pm
  • dear all, I have followed metalink suggestion as of Note:68836.1, but when truncate bigtable reuse storage, I got problem with SMON that hold fet$ dictionary table. the the server was restarted ...
    Ujang JaenudinUjang Jaenudin
    Apr 17, 2007 at 12:40 pm
    Apr 17, 2007 at 2:23 pm
  • I recently attended the Oracle RAC class, and in the class, it was claimed that 10gR2 removes any geographical limitations on the implementation of RAC nodes. In other words, as long as your network ...
    Michael FontanaMichael Fontana
    Apr 16, 2007 at 8:09 pm
    Apr 17, 2007 at 12:45 am
  • We created an outline for a SQL statement that was using the incorrect index. We tested it in QA where it worked fine and then we put it in production across a couple of RAC databases that run ...
    Wayne AdamsWayne Adams
    Apr 13, 2007 at 7:54 pm
    Apr 16, 2007 at 5:08 pm
  • Hello, In Oracle 8, when performing a select query on another database threw DB link, Oracle opens a transaction that could only be closed by commit or rollback. That could be harmful when developers ...
    Marc DemlenneMarc Demlenne
    Apr 3, 2007 at 12:07 pm
    Apr 5, 2007 at 12:34 am
  • Need a contact for Veritas backups. We currently backup our production database (RHEL4 on Dell server) to disk. We then use Veritas 6.x (latest patch level) to do an OS backup of the RMAN ...
    Sandra BeckerSandra Becker
    Apr 27, 2007 at 5:55 pm
    May 1, 2007 at 12:08 am
  • I have an issue where i am unable to stop dbas updating/deleting information from sys.aud$ table has anybody got any ideas/methods of protecting the audit trial, as sending the information to a log ...
    Peter DixonPeter Dixon
    Apr 26, 2007 at 12:30 pm
    Apr 26, 2007 at 3:04 pm
  • Dear all, the paper below presents the results of an investigation about "the formula used by the Cost Based Optimizer to estimate the cardinality of an equijoin, when both the columns referenced in ...
    Alberto Dell'EraAlberto Dell'Era
    Apr 25, 2007 at 3:43 pm
    Apr 26, 2007 at 2:53 pm
  • Any body has exp imp parfile example for all the 4 types of exp imp...i will adjust that according to my requirment. Arif -- http://www.freelists.org/webpage/oracle-l
    Arif GulzarArif Gulzar
    Apr 22, 2007 at 3:22 am
    Apr 23, 2007 at 3:09 pm
  • I am trying to find the records where there are non printable characters, i am not having success with it select * from njcrc.tblprogram where REGEXP_INSTR(description,'[[:cntrl:]]') Above sql pulls ...
    Dd yakkaliDd yakkali
    Apr 13, 2007 at 4:18 pm
    Apr 20, 2007 at 2:19 am
Group Navigation
period‹ prev | Apr 2007 | next ›
Group Overview
grouporacle-l @

251 users for April 2007

Jared Still: 66 posts Allen, Brandon: 42 posts Rjamya: 30 posts Niall Litchfield: 28 posts Kerber, Andrew W.: 27 posts William Wagman: 22 posts Bobak, Mark: 20 posts Don Seiler: 20 posts Dennis Williams: 15 posts Hemant K Chitale: 15 posts Kevin Closson: 14 posts Ryan_gaffuri_at_comcast.net: 14 posts Stefan Knecht: 14 posts Alexander Fatkulin: 12 posts Fmhabash_at_gmail.com: 12 posts Reidy, Ron: 12 posts Alberto Dell'Era: 11 posts Eric Jenkinson: 10 posts GovindanK: 10 posts LS Cheng: 10 posts
show more