Search Discussions

193 discussions - 1,062 posts

  • Hi all, I've been trying to figure out a way that I can have my users allowed to login to the server (HP-UX) with their own account and run a shell script that's owned my me ... but I don't want them ...
    Fred SmithFred Smith
    Feb 16, 2006 at 6:29 pm
    Feb 20, 2006 at 3:39 pm
  • Hello all, I have a small dilemma I need to resolve. We have several large databases that do not shutdown quickly due to active processes (usually AQ stuff but not always) and this has caused ...
    Feb 27, 2006 at 4:37 pm
    Feb 28, 2006 at 10:12 pm
  • Hi list, I need to quckly compare tables in 2 schemas to verify contents are identical. Counting blocks/rows, using tools to compare schemas is not possible. Something similar to checksum mechanism ...
    Ranko MosicRanko Mosic
    Feb 22, 2006 at 7:39 pm
    Feb 27, 2006 at 12:43 pm
  • Hi all, First post. Am looking for advice/recommendations on 3rd party monitoring tools specifically for 10g. Here's a list of some of the things I'd like to monitor...many instances across many ...
    Doug BritnellDoug Britnell
    Feb 9, 2006 at 3:52 pm
    Feb 12, 2006 at 3:12 am
  • hi all, I want to run os command from pl/sql block but don know how to do that. My objective is to put database name,host name,os with version on the top of the report which i used to send using ...
    Onkar N TiwaryOnkar N Tiwary
    Feb 1, 2006 at 6:21 am
    Feb 2, 2006 at 3:34 pm
  • Hi I was wondering if anyone know any source about effective Oracle RDBMS Capacity Planning. I mean effective because in the past I have seen many so called "Capacity Plan" which failed miserably in ...
    LiShan ChengLiShan Cheng
    Feb 23, 2006 at 10:25 am
    Feb 24, 2006 at 4:16 pm
  • Hi I was wondering how to restore an Oracle 9i RMAN backup from a location where it was not backed up to. For example I backed up the database to F:\, I then take this backup to another Server where ...
    Li-Shan ChengLi-Shan Cheng
    Feb 7, 2006 at 10:10 pm
    Feb 8, 2006 at 6:01 pm
  • It takes a long time to get connected to our Oracle 8i database. Once connection got established the performance is OK. However it may take few minutes to get connected. We are in dedicated mode. Any ...
    Inessa WeinerInessa Weiner
    Feb 3, 2006 at 4:16 pm
    Feb 3, 2006 at 10:03 pm
  • I am trying to save an encrypted password for the listener and although it responds that the command was completed successsfully, it isn't turning on security and doesn't seem to be working. Any ...
    J. DexJ. Dex
    Feb 16, 2006 at 6:55 pm
    Mar 2, 2006 at 11:16 pm
  • I have a log table that is logging various PLSQL calls. Assume the table looks like this... PROCEDURE_ID 1 2 1 1 1 1 1 2 1 1 2 1 Looking at this I can see that the max times 1 was called ...
    Ethan PostEthan Post
    Feb 8, 2006 at 5:46 pm
    Feb 9, 2006 at 5:50 pm
  • Hi, I have a standby database, 10.2 non-managed. I want to know what was the last timestamp of the transaction that is applied to the standby database. I can get the maximum sequence# and last SCN ...
    Sandeep DubeySandeep Dubey
    Feb 9, 2006 at 4:50 pm
    Feb 9, 2006 at 9:04 pm
  • Hi I was asking my self, and I decided to ask people who knows better about it: Which is the difference if I set all tablespace to nologging vs if I set the hidden parameter to disable logging ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Feb 2, 2006 at 5:27 pm
    Feb 3, 2006 at 12:29 pm
  • Hi all, I have a table structure similar to: Acct_id, site_id, cr_date, ndc This table will store approximately 700 million rows. There will be approximately 10 distinct acct_id and distinct ...
    Sandeep DubeySandeep Dubey
    Feb 21, 2006 at 9:48 pm
    Feb 24, 2006 at 2:37 pm
  • Hi All, After tracing the QMON process which was doing lots of buffer gets, I found this culprit. None of the three tables involved in the query have more than 2 blocks. I know the nested loop is ...
    Nahata, Naveen (US - Glen Mills)Nahata, Naveen (US - Glen Mills)
    Feb 13, 2006 at 4:03 pm
    Feb 15, 2006 at 1:55 pm
  • I've just become aware of an instance that has 130 schemas with a total of 15,000 tables, 12,700 of which have no optimizer statistics. Even though things run relatively well without the stats we are ...
    Orr, SteveOrr, Steve
    Feb 13, 2006 at 4:12 pm
    Feb 14, 2006 at 9:52 am
  • I am a PL/SQL newbie and the following gives me errors while executing. a_strng := NULL; open b_cursor; loop fetch b_cursor into a_ATWRT; a_strng := a_ATWRT || a_strng; exit when b_cursor%NOTFOUND ...
    Roger XuRoger Xu
    Feb 8, 2006 at 9:11 pm
    Feb 9, 2006 at 1:09 am
  • HI I want to share this info, not asking. Some years ago I changed the optimizer parameters, and this solved a query, from minutes to seconds OPTIMIZER_INDEX_COST_ADJ = 10 OPTIMIZER_INDEX_CACHING = ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Feb 7, 2006 at 4:46 pm
    Feb 7, 2006 at 8:58 pm
  • Hi all, http://acmqueue.com/modules.php?name=Content&pa=showpage&pid=363&page=1 Came across this link (from a SQLServer newsletter of all places!) This is a very interesting Q & A from a "Cary" clone ...
    John KanagarajJohn Kanagaraj
    Feb 21, 2006 at 6:20 pm
    Feb 23, 2006 at 2:56 pm
  • Hi:, 3 Node RAC Veritas Cluster Foundation 4.0 Solaris 2.9 We are experiencing some problem related to IPC (ORA-27504: IPC error creating OSD context) and wanted to know what is the network ...
    Sami SeeranganSami Seerangan
    Feb 24, 2006 at 1:48 am
    Feb 27, 2006 at 5:48 pm
  • I suggested to my client we switch to a centralized naming solution when we do the upgrade to 10g since we have to touch all the current clients anyway. However, I see Oracle no longer supports Names ...
    Michael RayMichael Ray
    Feb 8, 2006 at 10:14 pm
    Feb 14, 2006 at 10:01 pm
  • Hi, In order to get x-windows for oracle installation, I am trying to use CYGWIN and it gives error : could not find xterm. Does anyone have experience with using CYGWIN or is there another ...
    A JoshiA Joshi
    Feb 2, 2006 at 6:49 pm
    Feb 8, 2006 at 4:52 am
  • Hi, Sorry for the non Oracle specific question but I was wondering what you guys out there were using to build models (LDMs, PDMs etc.) ? I would prefer cheap or free tools if possible but any ...
    Robertson Lee - lerobeRobertson Lee - lerobe
    Feb 24, 2006 at 9:59 am
    Feb 28, 2006 at 9:05 am
  • Hi, We are facing problem with ORA-04030 on Windows 2000 Standard Edition with Oracle 9.2 We have 4G of RAM on the server, but Windows can not handle process bigger then 2G. We have adjusted our SGA, ...
    Luc DemancheLuc Demanche
    Feb 21, 2006 at 8:57 pm
    Feb 22, 2006 at 6:26 pm
  • � Hi, The DB is Oracle 9i on an HP-UX 11.11 system. My question concerns direct I/O. I've read numerous papers and vendor documentation (Oracle and HP) on the merits of bypassing the HP buffer cache ...
    Khemmanivanh, SomckitKhemmanivanh, Somckit
    Feb 13, 2006 at 11:11 pm
    Feb 15, 2006 at 5:07 pm
  • We have tables with LOB columns which are showing chained/migrated rows. I want to know how to reduce the chaining/migration of rows for such tables? Will putting these tables on tablespace with ...
    Hitender chughHitender chugh
    Feb 3, 2006 at 3:59 am
    Feb 6, 2006 at 8:51 pm
  • Win2K domain WinXP clients AIX5.2, Oracle 9i server Good morning all, We are looking for a solution which will allow us to let users authenticate their database connections using their Windows logon ...
    Ruth GramoliniRuth Gramolini
    Feb 28, 2006 at 3:38 pm
    Feb 28, 2006 at 10:46 pm
  • Tom Kyte made a nice mention of our little community in the current issue of Oracle Magazine. Page 81 if you have the print version. Online at ...
    Jared StillJared Still
    Feb 23, 2006 at 8:54 pm
    Feb 27, 2006 at 3:33 pm
  • Hi all. I have noticed too many threads in the Task Manager related to the ORACLE.EXE process for 10.2. So I run a simple testcase program on a test server with no activity and I fired 10 SQLPLUS ...
    Paolo DesalvoPaolo Desalvo
    Feb 23, 2006 at 8:53 pm
    Feb 24, 2006 at 2:29 pm
  • Hello everybody, I don't believe that change vectors are disappearing from REDO files. Presumably they are not. But the fact is that due some optimization or other reason Log Minder is not capable to ...
    Jurijs VelikanovsJurijs Velikanovs
    Feb 21, 2006 at 4:44 pm
    Feb 24, 2006 at 12:19 am
  • OS: Sun Solaris 2.8 Database: Oracle We plan on implementing the ODM (Oracle Disk Manager), on our database in a few weeks. The datafiles currently are on vxfs-based filesystems. Apparently ...
    Deepak SharmaDeepak Sharma
    Feb 15, 2006 at 10:25 pm
    Feb 21, 2006 at 12:32 am
  • Could ORA1194 be due to some Datafiles having being ADDED AFTER the LAST Cold backup of 10 Feb 2006, BUT Before occurrence of the CRASH around 6 pm on 11 Feb 2006, which continue to exist in the ...
    Feb 12, 2006 at 5:34 am
    Feb 12, 2006 at 8:00 pm
  • Hello List, Look into the queries below, why the result of first two queries is starting with a blank space, and to get rid of this I have to substr from position 2 rather than 1. select ...
    Krishan GuptaKrishan Gupta
    Feb 8, 2006 at 9:32 pm
    Feb 9, 2006 at 1:51 pm
  • Hello List, Being one of the fan of oracle, I truly disapointed to read the following blog. Has any come across of this link or not? Now, Oracle experts, tell us how to definy with this comment in ...
    The Human FlyThe Human Fly
    Feb 7, 2006 at 3:15 pm
    Feb 8, 2006 at 8:15 pm
  • https://metalink.oracle.com/metalink/plsql/showDoc?db=NEW&id=1696291.993 -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-l
    Jared StillJared Still
    Feb 5, 2006 at 1:20 am
    Feb 6, 2006 at 6:19 pm
  • I find utl_file too slow for reading and writing large text files. In fact it seems faster to read/write files from a Windows Visual Basic client application over NFS then to read/write using ...
    John DunnJohn Dunn
    Feb 22, 2006 at 4:03 pm
    Feb 23, 2006 at 12:42 am
  • -- http://www.freelists.org/webpage/oracle-l
    Henry PorasHenry Poras
    Feb 14, 2006 at 3:43 pm
    Feb 15, 2006 at 8:14 am
  • Hi I have heard that will be the terminal release for Oracle9i and that it is not too far off in the future. Anyone have any better info on when it will be released? I am trying to decide ...
    Ben PoelsBen Poels
    Feb 13, 2006 at 9:18 pm
    Feb 14, 2006 at 1:40 pm
  • Anyone running this combination? We are considering migrating to this and I found on Metalink (notes 231901.1 & 222404.1) that patch 2896876 is required to support this. I'm hesitant to run anything ...
    Allen, BrandonAllen, Brandon
    Feb 13, 2006 at 6:50 pm
    Feb 13, 2006 at 8:13 pm
  • Folks, Does anyone know what the value "session param valu" in column x$ksmlru.ksmlrcom means? Thanks Amir -- http://www.freelists.org/webpage/oracle-l
    Hameed, AmirHameed, Amir
    Feb 8, 2006 at 4:43 am
    Feb 9, 2006 at 6:03 pm
  • I would like to take a moment to say goodbye to a co-worker, a friend and a mentor. Lex was also a friend to many on this list. Lex had cancer and passed away on February 1st. All I have to say is ...
    Feb 3, 2006 at 3:12 am
    Feb 3, 2006 at 6:31 pm
  • Hi I am installing a 2 node 10gR2 RAC in my labtop using vmware. I have come across some doubts Setup: Host OS: Windows XP PRO SP2 Guest OS: CentOS 4.2 VMWare Workstations 5.0 I am using a external ...
    LiShan ChengLiShan Cheng
    Feb 26, 2006 at 7:28 pm
    Feb 28, 2006 at 7:50 am
  • i am working on a project that has a bunch of sql server databases (the one that comes for free) all over the country. each of these databases will be submitting a substantial amount of data to an ...
    Chris StephensChris Stephens
    Feb 10, 2006 at 9:10 pm
    Feb 17, 2006 at 1:21 pm
  • Dbms_stats tells me there are 2000 rows, but count(*) says there are about 3.2 million. Can anybody explain to me what is going on? Please see below. Thanks. SQL exec ...
    Sam BootsmaSam Bootsma
    Feb 16, 2006 at 9:12 pm
    Feb 16, 2006 at 9:54 pm
  • Oracle,Sun Solaris, 3 Node RAC,Veritas Cluster Foundation Recently we set password for our listener. Since then the listener stopped writing into logfile. I checked the log status and set to ...
    Sami SeeranganSami Seerangan
    Feb 10, 2006 at 9:38 pm
    Feb 15, 2006 at 1:28 pm
  • After spending 6 futile months trying to convince my management to spring for the Hotsos profiler I gave up and downloaded OraSRP last year. Since then I've fallen in love with the OraSRP profiler ...
    Feb 3, 2006 at 7:47 pm
    Feb 13, 2006 at 10:32 pm
  • When a user connects to my HP-UX 10g database from Excel via ODBC and runs a SQL select statement joining 2 tables, a 10046 trace clearly shows that statement running quickly, then another mysterious ...
    Fedock, John (KAM.RHQ)Fedock, John (KAM.RHQ)
    Feb 8, 2006 at 8:46 pm
    Feb 9, 2006 at 6:22 pm
  • Table A: Lastname (Mike) Firstname (Johnson) Phone(323-442-5678) Table B: Lastname-Firstname(MikeJohnson) StreetAddress(1242 Main St.) Zip(76222) How do I join these two tables? select ...
    Roger XuRoger Xu
    Feb 1, 2006 at 9:07 pm
    Feb 5, 2006 at 5:56 pm
  • Hello list, We have faced a very very strange problem when accessing or desc v$access table. Database : Oracle 9i Rel.2 (9205) OS : AIX 5.3 JFS2 Filesystem. CPU = 30+ No. Connections = 1000+ We are ...
    The Human FlyThe Human Fly
    Feb 27, 2006 at 4:37 pm
    Feb 28, 2006 at 7:44 am
  • I need to "unhack" file$. A well meaning DBA deleted a row from file$ while trying to remove an unneeded datafile from a tablespace. Currently, I can see the file thru v$datafile and it's status is ...
    John d parkerJohn d parker
    Feb 21, 2006 at 7:21 pm
    Feb 22, 2006 at 12:28 am
  • Anyone have a good way of managing output from V$LOGMNR_CONTENTS.SQL_UNDO when the undo statements span 3 rows within V$LOGMNR_CONTENTS? I'm on Oracle and need to undo about 200,000 INSERTs ...
    Herring Dave - dherriHerring Dave - dherri
    Feb 18, 2006 at 6:46 pm
    Feb 19, 2006 at 12:22 am
Group Navigation
period‹ prev | Feb 2006 | next ›
Group Overview
grouporacle-l @

230 users for February 2006

LiShan Cheng: 45 posts Bobak, Mark: 36 posts Jared Still: 34 posts Mladen Gogala: 34 posts Tanel Põder: 25 posts Juan Carlos Reyes Pacheco: 24 posts Radoulov, Dimitre: 22 posts Oracle-l-bounce_at_freelists.org: 20 posts David Sharples: 19 posts Niall Litchfield: 18 posts Allen, Brandon: 17 posts Ray Stell: 17 posts Ranko Mosic: 16 posts Joseph Amalraj: 15 posts Jurijs Velikanovs: 15 posts Kevin Closson: 14 posts Deepak Sharma: 13 posts Herring Dave - dherri: 13 posts Mercadante, Thomas F (LABOR): 13 posts Norman Dunbar: 13 posts
show more