RE: RAID or NOT to RAID? What's the diff???

Guy Harrison - Oracle SQL High Performance Tuning Jonathan Lewis - Practical Oracle 8i and at the moment - Couchman and Schwinn - Oracle 8i DBA Certification Exam Guide. Regards Lee -Original Message- Sent: 14 August 2001 18:07 To: Multiple recipients of list ORACLE-L On Mon, Aug

Speed up Truncate tables

Hi All, Is there any way to speed up the truncating a big table with 12 million rows? Basically, I implemented truncating that big table on Production, but it affected the performance much, so I had to stop it in the middle of way. All the rows were truncated but the HWM was not shrunk at

RE: RAID or NOT to RAID? What's the diff???

Oh yes, and when I save up some money after buying the Certification book, I should be purchasing DBA 101, can't remember who wrote that one though :-) Lee -Original Message- Sent: 15 August 2001 08:50 To: Multiple recipients of list ORACLE-L Guy Harrison - Oracle SQL High

RE: rman/standby

Title: RE: rman/standby Ravindra, Two thoughts 1) Why not copy the archivelogs as they are created by setting the log_archive_dest_1 parameter in your init.ora. This will make 2 copies of the archivelog file, the 2nd one of which can be either be local or to the remote server. 2) In RMAN

RE: Speed up Truncate tables

Title: RE: Speed up Truncate tables Chuan, Are you sure you were using the TRUNCATE TABLE command rather than DELETE It sounds as if you are running a delete, especially if the HWM was not shrunk John -Original Message- From: Chuan Zhang [mailto:[EMAIL PROTECTED]] Sent: 15 August

RE: Splitting a database: pro and cons

Title: RE: Splitting a database: pro and cons Quick thoughts Downside Resource overhead of another instance (system temp tablespace memory etc) Support requirements Conectivity between the 2 instances via db_links although if theye are on the same server network traffic is negated Upside

An SQL question , not easy ;-)

Dear gurus ! I have a table of phone calls , 2 fields : CALL_START DATE , CALL_END DATE . I need an SQL statement or a PL/SQL block to calculate the maximum number of SIMULTANIOUS phone conversations. Please help !!! Thanks a lot in advance ! Andrey. -- Please see the official ORACLE-L FAQ:

FW: An SQL question , not easy ;-)

Dear gurus ! I have a table of phone calls , 2 fields : CALL_START DATE , CALL_END DATE . I need an SQL statement or a PL/SQL block to calculate the maximum number of SIMULTANIOUS phone conversations. Consider there are 4 calls , one started at 12:10 and ended at

RE: I admit this is dumb. NT/W2K Services?

Title: I admit this is dumb. NT/W2K Services? Hi Lisa, Yes, I agree it can be confusing. The service is a background process that provides an environment for Oracle to execute in - I don't know about the specifics in this case, but Oracle on Unix is comprised of two logical parts, the VOS

RE: An SQL question , not easy ;-)

Quick and dirty solution: Pick a time and look for all calls which started before that time and ended after that time. That will tell you how many calls were in progress at that time. Repeat this at, say, half hour intervals, and graph the results. This will show you a trend. Where it looks

Re: FW: An SQL question , not easy ;-)

Give me some time :-))) Jan Pruner Dne st 15. srpen 2001 12:40 jste napsal(a): Dear gurus ! I have a table of phone calls , 2 fields : CALL_START DATE , CALL_END DATE . I need an SQL statement or a PL/SQL block to calculate the maximum number of SIMULTANIOUS phone

Re: Locally Managed Tablespaces and autoextend

Quick follow up to the bitmap sizing for larger files: I've quoted this 20-30,000 figure in my book as applying to both 'ordinary' LMTs and 'temporary' LMTs. However following our discussions, and a conversation with Ken Robinson from Oracle, I've run a couple of tests on 8.1.7 and the 2-bytes

Re: Performance analysis (enqueue and buffer busy waits)

Ignore (or at least treat very lightly) the comments about DBWm. Excessive database writes can cause log file sync waits, as dbwr calls lgwr to write the log protecting the blocks it is about to write. In this case, you will see v$session_event for the db writers showing log file waits.

Re: FW: An SQL question , not easy ;-)

1. Create table CC with 2 fields: DT DATE, CALL_COUNT NUMBER . 2. Fill table CC with tuples with DT started from MIN(CALL_START) up to MAX(CALL_END) and CALL_COUNT = 0. Step of DT value is 1 minute (or second = 36mil tuples/year). 3. for every tuple in a table of phone calls update table CC

Re: An SQL question , not easy ;-)

Pursuing Guy's method in a non-procedural way: select ts.timestamp, count(*) from ( select to_date('1-jan-2001','dd-mon-') + (rownum / 1440) timestamp from short_narrow_table_of_numbers where rownum = 1440 )ts, phone_calls where

RE: An SQL question , not easy ;-)

Thanks Guy ! The problem is that i need it in one non-interactive PL/SQL block . Thanks a lot !! -Original Message- Sent: Wednesday, August 15, 2001 1:00 PM To: Multiple recipients of list ORACLE-L Quick and dirty solution: Pick a time and look for all calls which started before that

RE: Datafile Migration Tool

Like the block editor Oracle used to make available ? BDE or something like that? DUL tool would be cool, too. Especially, if it handled the odd-ball cases like LMTs and IOTs. I would only use DUL on production if it was total S.O.L. and there was nothing left (besides READING won't make the

RE: An SQL question , not easy ;-)

How about: - declare l_count pls_integer := 0; begin for rec in ( select call_start time, 1 incr from table union all select call_end time, -1 incr from table order by 1 ) loop l_count :=

mambar for Oracle by luminate

Anybody using Mamba without the luminate.net service. Opinions of it. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204

RE: Speed up Truncate tables

Check the extent sizes... truncate can take a VERY long time if there are a very large number of extents. At one point we had a large table with approximately 60,000 extents (accidentally created with INITIAL/NEXT 80k MAXEXTENTS UNLIMITED), which took about 2.5 hours to truncate. After

OT -- Dilbert on 2-day classes that teach everything

http://www.dilbert.com/comics/dilbert/archive/dilbert-20010723.html Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique

RE: An SQL question , not easy ;-)

David, Here's the output from your suggestion based on a table with the following rows; CALL_STARTCALL_END - - 01-AUG-2001 12:10 01-AUG-2001 12:40 01-AUG-2001 12:15 01-AUG-2001 12:30 01-AUG-2001 12:25 01-AUG-2001 12:55 01-AUG-2001 12:45 01-AUG-2001 12:47

RE: Locally Managed Tablespaces and autoextend

Thanks for investigating and sharing this with us - Babette -Original Message- Lewis Sent: Wednesday, August 15, 2001 7:16 AM To: Multiple recipients of list ORACLE-L Quick follow up to the bitmap sizing for larger files: I've quoted this 20-30,000 figure in my book as applying to

Re: NYOUG

Rachel Carmichael wrote: wish we could... we are not setup to record the presentations. One of these years, when we become a rich users group (or is that an oxymoron?) Hey, I'm lucky I can persuade people to give me the slides and papers... there are a few people on this list who still owe

RE: How can I get my DB back if I lost one of my rollback segment

When you restored, did you restore the control files etc... EVERYTHING from the cold backup? It should not have been looking at the new file at all if you added it after the backup. Now... rewrite your cold backup script to read the names of the datafiles, logfiles and controlfiles to be

RE: Datafile Migration Tool

Hi, Oracle'e block editor is called BBED and it will be in your $ORACLE_HOME/bin. DUL will not be in standard oracle instalations and it is a support tool. --- Babette Turner-Underwood [EMAIL PROTECTED] wrote: Like the block editor Oracle used to make available ? BDE or something like that?

Re: RMAN cold backups continued

living on the bleeding edge are we?, let me try it on my 9.0.1 and let you know. joe [EMAIL PROTECTED] 08/15/01 10:07AM Thanks to everyone who replied yesterday. It appears I had already been onthe right track, as I did attempt backups with the database in noarchivelogmode and mounted

RE: An SQL question , not easy ;-)

Note that whenever a call starts, this increases the current number of calls by 1, and whenever a call ends, this decreases the current number of calls by 1. Hence you can uncouple the start and end times - you don't need to know that a given start time and a given end time belong to the same

RE: An SQL question , not easy ;-)

I'm working on this one, almost got a solution... ;-) Kev. -Original Message- Sent: 15 August 2001 14:05 To: Multiple recipients of list ORACLE-L Thanks Guy ! The problem is that i need it in one non-interactive PL/SQL block . Thanks a lot !! -Original Message- Sent:

Lost of all Control Files

Hi gurus, When my DB is starting I am getting an error of corrupt block in controlfile (block 1, block #1) Ora-00202 'c:\oracle\oradata\control01.con' Ora-00207 I have 3 controlfiles, no copies, sorry, shame. In the init.ora I commented the line of the control file No1, then it

RE: An SQL question , not easy ;-)

Yes, so the maximum is 3, between 12:25 and 12:30. To explicitly show the maximum (and a little histogram) you could amend it as follows: - declare l_count pls_integer := 0; l_max_count pls_integer := 0; begin for rec in ( select call_start time, 1

Re:mambar for Oracle by luminate

Yes, it's pretty good although it does take quite a punch out of the server running it. What I really like is that it provides a deep look into the database for non-dba types without allowing them to do anything harmful to the database. I was somewhat surprised when I spent a little time

RE: I admit this is dumb. NT/W2K Services?

Title: RE: I admit this is dumb. NT/W2K Services? DING! (That's the light bulb going on in my head) That makes complete sense. Thanks Guy for outlining this in email. I understand now. It took me ~4 hours to create my very first ORA-600 on my w2k oracle database and crash it. :) That

Re: RE: UNCUT ORACLE-L The Motion Picture

She was from the Tammy Fae school of makeup application. Big hair too. Charles Wolfe

RE: RMAN cold backups continued

I found the problem--O/S enviroment variable NLS_LANG must be set. Thanks. Paul Baumgartel MortgageSight Holdings, LLC [EMAIL PROTECTED] -Original Message- Sent: Wednesday, August 15, 2001 9:10 AM To: '[EMAIL PROTECTED]' Thanks to everyone who replied yesterday. It appears I had

RE: OT -- training

Yes. It does. But, as someone pointed out earlier, as an individual it's only partially deductible. If you're a business then it is an expense that can be offset against income (and thus is 100% deductible). If you're not already a DBA (or at least in an IT field) then it's probably not

RE: RAID or NOT to RAID? What's the diff???

some hack writer who haunts this list. don't believe anything she says :) From: Robertson Lee - lerobe [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RAID or NOT to RAID? What's the diff??? Date: Wed, 15 Aug 2001 00:40:23

RE: Speed up Truncate tables

truncate doesn't change the hwm unless you drop storage also, depending on the number of extents (not the number of rows), it can take a long time to free up storage if you do truncate table ... drop storage. Oracle has to update the UET$ and FET$ tables for each extent you release. From:

OT: HANSEN Inventory and Work Order System

We have decided to get Hansen's IWOS system to interface with out Utility Billing System and I am looking for any information about it from organizations which may already have it. Operating System Number of Utility Billing Accounts? How long have you been using it? size and growth ? Are you

Re: RMAN cold backups continued

running it on 9.0.1 on linux no problems, only change to your script was location of where to put the files. i've not doing the controlfile thing, i've got a repository. joe [EMAIL PROTECTED] 08/15/01 10:07AM Thanks to everyone who replied yesterday. It appears I had already been onthe

RE: Speed up Truncate tables

Title: RE: Speed up Truncate tables Chuan, You can use the 'REUSE STORAGE' clause of truncate table. That's a heck of a lot faster if you have a whole load of extents allocated to the table. What it does is mark the table as empty and keep all extents. However, I have a feeling that if

RE: Lost of all Control Files

If all three are corrupted, you have to run the "create controlfile" statement and to make sure that you list all your data files and redo logs. You will loose the archiving and RMAN (if you have it) info though. At least you will not forget now to backup control files regularly ;-).

RMAN cold backups continued

Thanks to everyone who replied yesterday. It appears I had already been on the right track, as I did attempt backups with the database in noarchivelog mode and mounted but not open. Hot backups, with DB in archivelog mode, worked fine. However, cold backups, performed in the manner stated

Re: Designer 2000 install on Linux

Thanks for the advice Jared- Have you tried wine? I've looked at win4lin, but they don't seem to support my distribution/kernel level (Suse/2.4.7). Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Either lead by example, or become a terrible warning jkstill@cybco

Re:Checking if Oracle Connection still valid

Yusron, One item I have noted from those who love OCI is that they rarely if ever include the sqlca.h file which defines a structure called sqlca (wonder where that name came from).This is regrettable since it works with OCI just as well as Pro*C. There is a data point in sqlca called

Re: Splitting a database: pro and cons

I'm currently engaged in trying to join two databases that were split. The databases are supposed to be twin images of each other but, of course, they're not. But you may be taking a different route. WIll any objects in database A be twinned in database B? Do you have lookup tables that will

FW: An SQL question , not easy ;-)

oops, should be not :o) select a.call_start, count(b.call_start) interruptions from phone_call a, phone_call b where a.call_start = b.call_start and a.call_end b.call_start group by a.call_start Cheers Greg -Original Message- Sent: 15 August 2001 15:43 To: '[EMAIL PROTECTED]' Or

Oracle HRMS System Administrator Needed in San Jose..

This client, a world leader in the electronic manufacturing industry, in San Jose, CA is currently seeking an Oracle HRMS System Administrator. You will facilitate and maintain the setup of the Application so the users can work in a stable environment that produces expected results. Must be very

RE: Partition attached to Synonym

Hi All, Once again sinking into the depths of Oracle code. BUG INFO Bug:1716968 / Bug:1273906 Base Bug:743019 Fixed In Ver: 9.0.2 Abstract: CANNOT DROP PARTITION IF ADDED VIA SYNONYM - ORA-2149 Still waiting for instructions on how to cleanup my

Re: computer history stories - Now: IQ, etc.

Apologies for reviving a dead thread, but I was incommunicado for a week and just now saw this rather interesting thread. One of my pet rants is about the difference between knowledge and understanding. I am not sure of the clinical definitions of the words used in this discussion, but will

RE: Datafile Migration Tool

Hense transportable tablespaces. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North,

RE: An SQL question , not easy ;-)

Or use a self-join select a.call_start, count(b.call_start) interruptions from phone_call a, phone_call b where a.call_start = b.call_start and a.call_end b.call_start group by a.call_start -Original Message- Sent: 15 August 2001 16:02 To: Multiple recipients of list ORACLE-L Yes, so

Usage of Number type for table columns

List, In one of our applications, my boss wants to define all the numeric columns as NUMBER or leave it as floating point. He wants to define all the tables like this wherever numeric column is defined in the table. Example: Location_ID NUMBER We know, from our application character, that

user holding session even after a re-boot

I have Oracle 7.3.4 running on Windoze NT4.0. I have been trying to determine if I have an application problem or a database problem. I have an application called MP2 that is causing a user to have their PC freeze up when they try to print from the application. I ran a trace on their session

RE: Speed up Truncate tables

I had the same problem when truncating a huge table (24 Mill rows). It turned out that the reason my table was taking so long was the amount of extents I had on it. I could look at what was actually happening during a truncate and it had to go and take each individual block and put them back

RE: An SQL question , not easy ;-)

Is this not flawed in that given these results: eventtimeevent - 01-AUG-2001 12:10:00 start add 1- 1 01-AUG-2001 12:15:00 start add 1- 2 01-AUG-2001 12:25:00 start add 1- total 3 01-AUG-2001 12:30:00 end subtract 1 - 2

RE: Datafile Migration Tool

At which version of Oracle did they remove this? It is NOT in any my directories. I checked: - 8.0.3 ORACLE_HOME/bin - 8.1.5 ORACLE_HOME/bin - 8.1.6 ORACLE_HOME/bin - 7.3.4 ORACLE_HOME/bin Thanks, Babette -Original Message- Gopalakrishnan Sent: Wednesday, August 15, 2001 10:16 AM To:

RE: Checking if Oracle Connection still valid

sqlca has been around for a LONG LONG time. I used it years ago with my COBOL SQL Reports. Its the SQL Communications Area. -Original Message- Sent: Wednesday, August 15, 2001 10:02 AM To: Multiple recipients of list ORACLE-L Yusron, One item I have noted from those who love

LDAP and Oracle

Title: LDAP and Oracle Anyone use LDAP to work with Oracle to handle single login between various applications. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA

RE: OT: RE: UNCUT ORACLE-L The Motion Picture

So, would that be irrational or imaginary? BTW - I once made a mistake on a blackboard demonstration and ended up presenting Newton's Macroscope instead of Newton's Microscope. Turns out the math works as well for infinitudes as for infinitesimals. (g)

RE: user holding session even after a re-boot

I have found that if they did not close their session properly, as in the case of a reboot, that sessions can hang around until they timeout and die on their own. You can see about the timeout settings in their profiles. -Original Message- Sent: Wednesday, August 15, 2001 11:11 AM To:

RE: mambar for Oracle by luminate

Title: Message I believe they discontinued it, I used it like that, and it was ok. Didn't really give alot of information. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence

Re:RE: Checking if Oracle Connection still valid

Kevin, Very true, I remember it from way back in 85 on Version 4 of Oracle. The problem with sqlca and OCI is that it's not required and therefore often left out. Dick Goulet Reply Separator Author: Kevin Lange [EMAIL PROTECTED] Date:

WARNING Dangerous Upgrade path!

Ok, settle down. I just migrated from 80520 to 81600 on Siemens and the migrate consistently choked on the AQ$ update stuff. Something to do with objects...raw data types Oracle provided a patch which did not work. We finally had to migrate holding the database at compatible=8.0.5.2.0,

RE: Lost of all Control Files

Thanks, And what is the sintax of the create controlfile command ? How do I use it ? Now I will backup them :-) Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121 -Mensaje original-De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Djordje JankovicEnviado el:

Re:RE: Lost of all Control Files

I've stayed out of this one up till now. But based on the original I assume that all of the control files where on the same disk drive directory. Bad idea. If you have a problem with the drive and/or controller then you've been had. Place the control files on multiple spindles that are

Re: X$_kglcursor.kglnaobj

Ian and Riyaj, These table_... objects look like Java classes. The way to find this out is matching the kgl handle address and looking at the indx column of x$kglob. Matching this indx column with dba_objects.object_id. Yong Huang [EMAIL PROTECTED] you wrote: I use the following statment when

Re: Speed up Truncate tables

A truncate (reuse storage) should not do that - it simply drops the HWM to zero and updates the segment header. However, when a truncate is issued, and dirty blocks in the buffer from that object have to be written to disk before the truncate takes place, so that might be slowing things (a

RE: user holding session even after a re-boot

If the user already has his information displayed on the screen( retrieve already took place) and his/her machine freezes it is definitely application problem, may be networking problem but not back end problem. Printing problem is not an Oracle problem. If he/she is retrieving while printing

Re:user holding session even after a re-boot

Dave, Yes it is normal. The original session was communicating with the PC when the re-boot abnormally terminated the connection. It is now an orphan and will remain so until either you restart Oracle or the DB finds a way to close the session, most likely leaving it sniped. The reason is

PS lock

Hi, DBAs Anybody knows about PS lock , mode in 6, and exchange deadlocks equal to 1 in v$sysstat, can this be a problem? this is ver 8.0.5 on hp unix. thanksregards, Li -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Li, Xiangli INET: [EMAIL PROTECTED] Fat City

Re: WARNING Dangerous Upgrade path!

I think I had some issues with this also when we went from 805 to 816 on Solaris 2.6. Remeber removing all AQ params from my init.ora (job_queue* params). --- Mohan, Ross [EMAIL PROTECTED] wrote: Ok, settle down. I just migrated from 80520 to 81600 on Siemens and the migrate consistently

Re:RE: mambar for Oracle by luminate

True, but just enough. Dick Goulet Thought for the day: Never be afraid to try something new. Remember that a lone amateur built the Ark. A large group of professionals built the Titanic. Reply Separator Author: Christopher Spence [EMAIL PROTECTED]

RE: An SQL question , not easy ;-)

My apologies David, I was reading Andreys initial email as give me the number of concurrent calls being made of which there are 4. Kev (eating humble pie by the spadeful!) ;-) -Original Message- Sent: 15 August 2001 16:02 To: Multiple recipients of list ORACLE-L Yes, so the maximum

Re:Usage of Number type for table columns

Rao, The boss is somewhat right, but are you absolutely certain that the current program interface to the data will remain forever? What is the likelihood of someone having to correct the data via SQL*Plus or some other method where the restrictions will have no effect. The main reason of

Re: An SQL question , not easy ;-)

Andrey, At first glance, I think this SQL statement gives you the answer. It gives you a count of the simultaneous calls for each call. If you like this, then all you have to do is find the row with the maximum count. select a.call_start,a.call_end,count(*)+ 1 from pc a, pc b where

RE: Usage of Number type for table columns

I hate to be on the side of management but much time is spent going back and resizing fields and applications because the field defined is no longer big enough. Been there and done that many times. -Original Message- Sent: Wednesday, August 15, 2001 10:41 AM To: Multiple

Re:RE: Datafile Migration Tool

Chris, True, but you can't transport them across OS platforms. Dick Goulet Reply Separator Author: Christopher Spence [EMAIL PROTECTED] Date: 8/15/2001 6:56 AM Hense transportable tablespaces. Do not criticize someone until you walked a mile

Re: LDAP and Oracle

No, but I'd also be mighty interested to hear about the details. My problem here is that I've got a couple of applications (heck, most of the applications - including all the Oracle ones) that are not LDAP compliant. Most have their own internal security setup. David A. Barbour Oracle DBA, OCP

RE: user holding session even after a re-boot

Where can I find their profiles. If your talking about the .profile then is there a Windoze equivalent cuz I'm not on unix. :( Dave -Original Message- Sent: Wednesday, August 15, 2001 11:41 AM To: Multiple recipients of list ORACLE-L I have found that if they did not close their

RE: Datafile Migration Tool

Hi Babette, I think you are -UNIX. Check M$ and you will find that under /ORANT/bin. --- Babette Turner-Underwood [EMAIL PROTECTED] wrote: At which version of Oracle did they remove this? It is NOT in any my directories. I checked: - 8.0.3 ORACLE_HOME/bin - 8.1.5 ORACLE_HOME/bin -

RE: Lost of all Control Files

hi, if you have 3 controlfiles (it means that you have two copies of your controlfile), so if there is a problem with one controlfile, you had to change the parameter control_files in the init.ora so that you eliminate the corrupted file. Best Regards, Nabila Mekkaoui DBA Oracle

RE: computer history stories - Now: IQ, etc.

I have a simplistic view of things: Knowledge = ideas linked by associations, purely intellectual in nature. You can do the word association game re. these, quite fun. Understanding = experience involving the whole person, including movement, emotions and intellect. So to understand, you

RE: user holding session even after a re-boot

Title: RE: user holding session even after a re-boot Well, that sounds like an optimal environment, Kevin. I've seen Oracle client zombie sessions hang around for days and chew up CPU. I had to write a shell script to identify these sessions and kill them in both the OS and in Oracle. This

RE: An SQL question , not easy - GOT IT . MANY THANKS !!!!!!!

Dear Gurus ! Lots of thanks to everybody who replied. I've got numerous great solutions from U - now i need to choose one among them ;-) This is a great list with genius people subscribed ! I love to belong to Oracle DBAs brotherhood. Thank U all very much have a great day ! -Original

RE: Speed up Truncate tables

Chuan, Kevin is correct. If your truncate table is taking a *long* time (and the table is not locked by another process), it's because your storage params are incorrect for the amount of data you are holding. Look at initial and next in comparison with the number of extents (DBA_EXTENTS view)

Urgent Help Required ORA-65535

Hi All, I am facing a very different problem. I am using Oracle as a XA Resouce Manager for Encina. The Encina applications built using Oracle 8.0.6 are working fine. When we moved the Oracle version to Oracle 8.0.6.3 the applications are not able to connect to the database. It gives the

RE: user holding session even after a re-boot

I was talking about the connection profiles that you can use to set resource limits when you run the create profile command. With this you can create a profile for a set of users that you can then attach to a user either when you create it or thru the alter user command. The profile lets you

RE: user holding session even after a re-boot

Title: RE: user holding session even after a re-boot DBA_PROFILES, and if a user has been assigned a profile other than default, it will be in DBA_USERS -Original Message- From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 1:56 PM To: Multiple

Re: Usage of Number type for table columns

In this case, I think your boss is right. If you feel the need to have some integrity checking at the DB level, use FKs. CHECK and possibly NOT NULL constraints will subject you to the type of application/database maintenance a well-thought out plan should endeavor to avoid. Just be sure that

RE: An SQL question , not easy ;-)

I think I have an alternative solution that, if you're using 8.1.6 or better, would provide a pure SQL solution. It's probably not the tidiest SQL, but it works (as far as I can tell): SELECT c1 AS start_time , c2 AS end_time , total FROM (SELECT LAG (call_time, 1) OVER (ORDER BY

RE: Splitting a database: pro and cons

Our setup is one application per database (9 instances and growing), not all databases are integrated, but the majority are. Some of the things to consider : If one database goes down, the others have to right away. Or at least those ones that have integration. As we are a distrubuted

Re:RE: user holding session even after a re-boot

Kevin, I believe that is because Oracle on NT is a single multi-threaded process where one can handle this easier. On HP-UX and most other Unix variant OS's that I know Oracle runs as a bunch of independent processes, including the dedicated servers, and consequently it's harder. BTW: the

RE: Lost of all Control Files

If did 'alter database backup control file to trace' prior to your control files going bad check your user dump directory. Open that control file (it'll have .trc extension). They syntax will be right there. You will have to edit it deleting unnecessary info. HTH, [Lyuda Hoska]

Re: auditing ... getting offending SQL ??

On Mon, 13 Aug 2001, [EMAIL PROTECTED] wrote: Who is the vendor for EZSQL? Do you have a web site for them? www.google.com, type in ezsql and the first thing you get is http://www.ezsql.net/ -- Galen Boyer It seems to me, I remember every single thing I know. -- Please see the official

RE: An SQL question , not easy ;-)

Hi All: There's one really neat thing about this thread...it's helped me solve an on-going problem. I've got managers who want to see graphs of their system's usage. Using this mechanism applied against the DBA_AUDIT_TRAIL view works perfectly. Thanks! Mike ---

RE: JMS vrs AQ

Never got an answer from my JMS person here. Which we don't technically have one. I do know we have two topics, one used for all the price feeds, and one for the heartbeat and trade updates. I believe it is on a Raid 1 (Veritas VM) volume. There are a few disks for Export and other such unix

Re: computer history stories - Now: IQ, etc.

Boivin, Patrice J wrote: P.S. Are Orasoruses herbivores, or carnivores? i thought they were omni[back]vores.;-) -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] One ping to

Re[2]: Usage of Number type for table columns

Wednesday, August 15, 2001, 2:10:58 PM, David wrote: If for whatever reason this becomes a four-digit number (skip the technical explanations of why that will NEVER happen, just think of the logical approach - we dial 1 to get long-distance, why not a an additional digit(s) to access a region,

RE: Speed up Truncate tables

You are correct, unless your using 9i, you cannot alter the initial extent without dropping the table. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978)

  1   2   >