Date Format: Mystery

want to see the 10th part of the second or 100th part of the second, Is it poosible? I would appreciate all your hints. Thanks, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pillai, Rajesh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

RE: Date Format: Mystery

Carel-Jan, This explanation helps. Thanks a lot. Could you also answer if displaying centiseconds or milliseconds or 1/10th of a second in oracle is possible or not Thanks, Rajesh -Original Message-From: Carel-Jan Engel [mailto:[EMAIL PROTECTED]Sent: Thursday, January 29

RE: UNION ALL Query: Riddle

Hi Jared, Thanks for your response. different results mean that number of records are different sometimes, and sometimes the some of the quantities are not correct. Your help is really appreciated. Thanks, Rajesh -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL

UNION ALL Query: Riddle

- Production PL/SQL Release 8.1.7.2.0 - Production CORE8.1.7.0.0 Production TNS for Solaris: Version 8.1.7.2.0 - Production NLSRTL Version 3.4.1.0.0 - Production I would appreciate any help in solving this mystery and all hints are welcome. Thanks, Rajesh Pillai -- Please see

SQL CASE Statement

ur hints. Thanks, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pillai, Rajesh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: SQL CASE Statement

Hi Jared, Here is an example - The following part of unix script does not work-

Re: dc_used_extents ,dc_free_extents and dc_histogram_defs

.. And there used to be all these dc_ parameters that one could set, giving the dba control over the dictionary cache, which was not a part of the shared pool. And then came Oracle V7, with the shared_pool_size, wresting that control. Regards

Re: ** can two processes use the same rollback extent

And to further refine that statement and IIRC, a transaction will not use an extent E, that already has an active transaction in it, when the transaction has filled up the previous extent S, and is now looking to wrap into a new extent E. However, a fresh transaction can always be allocated space

How do I corrupt a raw datafile?

In the process of testing my rman recovery scripts? How do I corrupt a datafile created on a raw volume? DD, CAT, VI, RM ? Thanks in Advance Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services--

RE: How do I corrupt a raw datafile?

Thats precisely what I did. Logged in as Oracle. 1. Tried dd if=/dev/null of=/dev/vx/rdsk/.../tools_01 2. cat sqlnet.log /dev/vx/rdsk/.../tools_01 3. echo Mary has a little bambi /dev/vx/rdsk/.../tools_01 All ran successfully. I see the timestamp on the raw volume

RE: Datatype conversions

tt2 ; C1 -- 123.5 44567.9 1.23456 SQL HTH, Rajesh Rajesh Dayal Senior Oracle DBA (OCP 8,8i,9i) International Information Technology Company LLC -Original Message- Sent: Monday, November 03, 2003 4:30 PM To: Multiple recipients of list ORACLE-L Subject

Re: What is a local write wait?

Thanks KG. There were underlying OS I/O issues. The SA is looking to fix the same. Regards Raj __ Rajesh L. Rao DCI - Triad, Oracle DBA IBM Global Services, JPMC Account Phone: 516 5746065 E-mail: [EMAIL PROTECTED

RE: [ORA-000060: Deadlock detected] Finding BOTH pieces of code that

to be wrong. HTH Rajesh Dayal Senior Oracle DBA (OCP 8,8i,9i) International Information Technology Company LLC -Original Message- Sent: Tuesday, November 04, 2003 1:39 AM To: Multiple recipients of list ORACLE-L Subject:Fwd: [ORA-60: Deadlock detected] Finding BOTH

RE: Re: char(1) VS varchar2(1)

Extremely precious info. Thanks a lot for sharing this !!! Rajesh Dayal Senior Oracle DBA (OCP 8,8i,9i) International Information Technology Company LLC -Original Message- Sent: Monday, November 03, 2003 7:14 AM To: Multiple recipients of list ORACLE-L Subject:Fwd

What is a local write wait?

Was creating an index with a degree of 4, and in unrecoverable manner? There were few waits for an event called local write wait. Can anyone shed more light on this wait? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat

Table Size

Hi All, Couldsomebody help me in finding the actual size of an oracle table in GB. TIA, Rajesh

RE: Table Size

All the tables already exist and have data. Thanks a lot for your response, Rajesh -Original Message-From: Goulet, Dick [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 15, 2003 12:45 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Table Size Raj, Does

RE: Table Size

Title: Message Allan, I cannot run stats on the table Regards, Rajesh -Original Message-From: Nelson, Allan [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 15, 2003 12:54 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Table Size If you are running stats

Re: Using ' in Update statement

The one thing that I missed in my reply were the ;-) signs. I say hear hear to Mladen and Jared. My attempt at sarcasm fell flat like the Elle show. I was going thru my latest acquistion of Effective Oracle by Design by Tom Kyte, and was unduly influenced by the goodies he spoon fed me ;-).

RE: RAC and Standby Dr

Thanks for the reply, Pete. We recommended EMC SRDF to keep the production and DR in sync, but the budget cannot provide for it. Now, with a standby DR, what I am scared of is, it would take me say 15 minutes tops, to activate the standby in case of a production site failure. But then, making

RAC and Standby Dr

Folks, A project team here is flirting with the idea of having standby databases for the two production RAC nodes. The two standy nodes will be at a DR site. Any gotchas with this configuration? Regards Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET:

RE: Using ' in Update statement

You guys are mean !! Tom Kyte would have given me 10 ways of writing the statement, would have traced every one of them under different versions and on different platforms, pointed out the number of logical reads, elapsed time, et all, and told me which one is better. Regards Raj

Re: FIRST_ROWS hints

Very Much expected behaviour. Your increase in the db_block_size from 8 to 16, is making the optimizer choose full table scans, where applicable, since you have to scan through only half the number of blocks now. A nested loop will starting throwing the initial results faster. A sort merge join

OT - Microsoft Security Bulletin MS03-040 (828750)

Microsoft issued this critical update on the 3rd, which I found out about, when I did a Windows Update from my IE.

RE: Oracle Press OCP exam guide frustrations

Documentation then only I Open them ;-). HTH, Rajesh Dayal Senior Oracle DBA (OCP 8,8i,9i) International Information Technology Company LLC -Original Message- Sent: Tuesday, September 16, 2003 2:14 PM To: Multiple recipients of list ORACLE-L Subject:Fwd: Oracle Press OCP exam

RE: SQLPLUS on UNIX

Hi Rajuveera, Put these two lines in your .profile EDITOR=vi export EDITOR HTH, Rajesh Rajesh Dayal Senior Oracle DBA (OCP 8,8i,9i) International Information Technology Company LLC -Original Message- Sent: Saturday, September 13, 2003 11:09 AM To: Multiple recipients of list

RE: _cpu_count vs cpu_count

. HTH, Rajesh Rajesh Dayal Senior Oracle DBA (OCP 8,8i,9i) International Information Technology Company LLC -Original Message- Sent: Friday, September 12, 2003 8:34 PM To: Multiple recipients of list ORACLE-L Subject:Fwd: _cpu_count vs cpu_count Hi! I just noticed

RE: Re: test

). And yes, will silently be watching the testG launch through net. My Damagement Doesn't think it's worth attending these launches. ;-(( Regards, Rajesh Dayal Senior Oracle DBA (OCP 8,8i,9i) International Information Technology Company LLC -Original Message- Sent: Sunday, September 07

test

Test

test

test

Search the web by email! mailto:[EMAIL PROTECTED] adding your search to the subject line like this: search summer vacations test -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --

Re: Multiple Datafiles and performance?

Tim, Indexed access is a purely sequential activity from an I/O standpoint, putting aside the reality that a buffer cache exists. First, we access the root block of the index and read its contents in order to know where to perform the next I/O (i.e. a branch block). Then we read that branch

Re: Multiple Datafiles and performance?

Tim, For arguments sake, the I/O steps that you mention is for a single user. Assume thousands of users, in which case, everyone would be hitting the same disk volume. Whereas, if they were spread, the I/O would be spread across 2 different volumes. Having said that, I dont recommend spreading

Re: RE: why does block cleanout incur redo?

Excerpts from one of my notes, collated from excellent papers or websites by Steve Adams, Jonathan Lewis, and KGopal. The first block of every rollback segment, also called the segment header, has a structure called the transaction table, which keeps track of all the active transactions in

RE: last column in a table is added with a DEFAULT

I know, with earlier version of Oracle, columns likely to have null values were placed at the end of the table, to save on some minuscle bytes of space. If the null columns fall between columns with data values, then one byte is used for their storage. Else, they require no storage. But no,

Re: Corrupt Inactive RedoLog Goup.

Sorry, I skipped mentioning that, but we did try it, for the members. Got an ORA-01514: error in log specification. No such log. ORA-01517: log member: 'F:\ORACLE\ORADATA\TCP1\LOG3TCP1.ORA' When we used the group number, we got an:

Corrupt Inactive RedoLog Goup.

Members, Production 8.1.6.3 database on Windows NT 4.0. We noticed an entry in the alert log, citing that a log group could not be archived since the 25th of July.. We have 3 log groups with 2 members each. I notice that the 3rd redolog group has a status of Inactive with Archived=No. This group

cursor_sharing=SIMILAR and 9i

A quick update. Having multiple ORA-600 errors thrown at me randomly when I try to do a select from any of the V$ tables. Not always. 3 out of 5 attempts spew out ORA-600's and while this is in progress, the database freezes for a few seconds. Oracle Support says its coz of the

RE: Redo Logs Problem

logs) have come out to be Oracle Bugs, memory leaks, and improper user action etc. Rajesh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Naveen Nahata Sent: Monday, August 04, 2003 11:04 AM To: Multiple recipients of list ORACLE-L Subject: RE: Redo

RE: Redo Logs Problem

Just Out of curiosity. How come changing the TS to LMT would reduce the excessive Redo generation. Regards, Rajesh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of VIVEK_SHARMA Sent: Monday, August 04, 2003 9:49 AM To: Multiple recipients

Re: elapsed_time in 9i v$sqlarea

Thanks Mladen. So, I was looking at the wrong place. Since I was referring to the column elapsed_time in v$sqlarea, I expected to find it documented under v$sqlarea. I did not have the foresight or the hindsight to look at v$sql : -) Thanks Raj -- Please see the official ORACLE-L FAQ:

elapsed_time in 9i v$sqlarea

What's elapsed_time in v$sqlarea? I believe this was introduced in Oracle 9i. What is the unit for it? Strangely, the Oracle 9i Server Reference manual seems to have missed this altogether. I executed a query, the execution time of which was approximately 9 seconds. But when I look up v$sqlarea,

elapsed_time in 9i v$sqlarea

What's elapsed_time in v$sqlarea? I believe this was introduced in Oracle 9i. What is the unit for it? Strangely, the Oracle 9i Server Reference manual seems to have missed this altogether. I executed a query, the execution time of which was approximately 9 seconds. But when I look up v$sqlarea,

Re: buffer busy waits and v$filestat

Thanks, Mladen, for that helpful quick reply. The reason I ask is, one of our clients claims that they see a intermittent database performance degrade (queries get timed out), during times when the RMAN backup runs. Using an OS monitoring tool, they see a spike in I/O. The RMAN backups have 4

buffer busy waits and v$filestat

Folks, Say a session issues a read request, and finds another session already reading the block into the buffer cache. If this session waits N ms on a buffer busy waits event, does this N ms of wait get added to the read times in v$filestat? Or is the readtim in v$filestat purely physical I/O?

RE: iAS Apache name-based virtual hosting

both should be working. HTH, Rajesh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Boivin, Patrice J Sent: Tuesday, July 22, 2003 5:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: iAS Apache name-based virtual hosting I have

RE: iAS Apache name-based virtual hosting

Title: Message This section is not same across diff releases. Check this note 167194.1 for complete examples of these methods. HTH, Rajesh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Boivin, Patrice J Sent: Tuesday, July 22, 2003 6

RE: iAS Apache name-based virtual hosting

hostname1 ErrorLog logs/error_log CustomLog logs/access_log common /VirtualHost HTH, Rajesh http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boivin, Patrice J Sent: Monday, July 21, 2003 2:14 PM

RE: RAC or Oracle Fail Safe

a feeling of hung database or some other error. I think users will have a hung screen with/without some ORA error message. Hope this helps you decide, Regards, Rajesh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Hussain Ahmed Qadri Sent

RE: RAC or Oracle Fail Safe

Regards, Rajesh -Original Message- HREF="">mailto:[EMAIL PROTECTED]] On Behalf Of Hussain Ahmed Qadri Sent: Wednesday, July 16, 2003 8:44 PM To: Multiple recipients of list ORACLE-L Subject: RAC or Oracle Fail Safe Hello all, We have setup a Microsoft Cluster Server (

RE: RAC or Oracle Fail Safe

recovery might be required depending on specific cases. -- And this means that the user has to log in again, do I get it right? Yes you are right here. HTH, Rajesh -Original Message- HREF="">mailto:[EMAIL PROTECTED]] On Behalf Of Hussain Ahmed Qadri Sent: Thursday, July 17,

RE: ORA-00600: internal error code, arguments: [19944], [], [], [

Title: RE: ORA-00600: internal error code, arguments: [19944], [], [], [], [], [], [], [] Good solution ;-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Jamadagni, Rajendra Sent: Monday, July 07, 2003 10:30 PM To: Multiple recipients of list

Friday Humor - RMAN

Excerpt from the 9i RMAN Guide : If you specify DEVICE TYPE DISK, then you must back up to random access disks. You can make a backup on any device that can store an Oracle datafile: in other words, if the statement CREATE TABLESPACE tablespace_name DATAFILE 'filename' works, then 'filename' is

RE: SORT_AREA_SIZE question

Since we are talking of Sort area sizes here, I tried to collect some statistics on the amount of memory used by each dedicated Oracle connection. As I understand it, the PGA is allocated in chunks upto the SORT_AREA_SIZE. Initially, I just started a session, and noted down the memory used using

RE: SORT_AREA_SIZE question

Thanks Dennis. My question was not about the memory release, but more of the way memory is allocated to the PGA. Given that Oracle allocates memory in small chunks to the PGA until it approaches the sort area size, if I run a huge sort, should I expect the PGA memory to increase, until it reaches

Re: SORT_AREA_SIZE question

Thanks for the reply. I did use the Metalink Note to calculate pmap, minus the shared memory, et all. The problem with pmap is how do I make out what portion of this memory is UGA, and PGA? So, I look at v$sysstat. Anyway, hope to pursue this test in a much more detailed manner, when I have the

RE: AQ, RAC and delay

With MPCD=0, Is your primary wait event shown as on-going reading of SCN to complete in the statspack reports? Oracle Support insisted we set it to 7 coz of this. Raj

Some rollback doubts

From the docs : Many active transactions can write concurrently to a single rollback segment--even the same extent of a rollback segment; however, each data block in a rollback segment's extent can contain information for only a single transaction. 1) Now, when oracle writes to the last extent in

RE: Some rollback doubts

Rajesh: I am not sure which document you are referring here. If that documentation says more than one transaction can not use a rollback segment data block means, I would say the documentation is incorrect in this case

RE: HP OpenView

I tried monitoring some of my databases with it. The interface was crappy. But management insisted we use it since we pay for it. Eventually, found it much easier to write my own unix scripts and send all alerts and warnings to a file on a server, which is then monitored by Openview. Raj

Re: Parallel Query Server died

How about writing an eulogy now for ORA-600 [ 12235 ]: Oracle process has no purpose in life? Joe Testa

RE: Need Help for 9i OCP

on this offer. Simply go to http://testprep.selftestsoftware.com/W4RT052EB6F8A396076E3EEF0024 and your discount will automatically show on all individually packaged products on the site. You got to hurry up. Cheers, Rajesh -Original Message- Sent: Saturday, May 31, 2003 1:11 AM

RE: Parallel Query Server died

After long time .. LOL . ;-) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Vladimir BaracSent: Friday, May 30, 2003 2:35 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Parallel Query Server died Kool, now some cyber funeral

RE: use of reverse key index,cost based optimizer

Assume an index on employee number. The number is assigned sequentially, and as such, the rightmost index leaf block would always be used. A possible hot block. A reverse key index can avoid this. Also, assume when an employee retires or quits, the record is deleted. But the space freed within

Locking tables in Oracle

Hi All, Does anybody has any insight of dynamic view v$locked_object? It populates its locked_mode column with numbers what does those numbers mean? TIA, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pillai, Rajesh INET: [EMAIL PROTECTED] Fat City

RE: Locking tables in Oracle

Mladen, What does it mean if locked_mode column is populated with 0 or 3 or 6. What kind of locking does it shows (RS, X etc...)? Thanks a lot, Rajesh -Original Message-From: Gogala, Mladen [mailto:[EMAIL PROTECTED]Sent: Thursday, March 27, 2003 1:09 PMTo: Multiple

max_commit_propagation_delay

OPS 8.0.6.3 on Sun Nodes. We have this currently set to 0, and Oracle has recommended that we leave it at the default of 700, while making a general recommendation to improve the performance of this database. But from what I have gathered so far from Metalink, this would not suit us, since,

Re: max_commit_propagation_delay

Thanks for the update Jonathan. The recommendation was made by Oracle Support, after they noticed a lot of on going read of SCN to complete waits from a system dump. Almost 40% of the waits. In some of my statspack report, I even see this waits accouting for 70% of the total. Setting this

9i RAC - GFS

Attached in a quote from an Oracle Rep, asking us to avoid Global file systems on Sun Cluster nodes for 9i RAC. It is very clear that binaries and/or datafiles on GFS are not supported today. The reason for this is the proxy I/O that GFS is based on can be a real performance and scalability

RE: log buffer space

Dear AK, So far we don't know your log buffer size. Can we have a glimpse of this parameter, log_buffer ? Rajesh -Original Message- Sent: Friday, March 14, 2003 8:14 PM To: Multiple recipients of list ORACLE-L Do you guys think , adding more log file can help ? I think it should

Threat to Fast exports

Please have a look at following note: 223399.1 having title ALERT: EXPORT with large BUFFER can silently produce a dump file with corrupted data. Looks like all major versions on all platforms are affected. Really scary one.. Rajesh -- Please see the official ORACLE-L FAQ: http

RE: Oracle version??

available there... And that YP-ZP I mean XP, I would really hate to see a Oracle Database on that ;-)... Cheers, Rajesh -Original Message- Sent: Thursday, February 27, 2003 11:59 AM To: Multiple recipients of list ORACLE-L In the registry My Computer\HKEY_LOCAL_MACHINE

RE: Oracle version??

this location. HTH, Rajesh -Original Message- Sent: Thursday, February 27, 2003 7:09 AM To: Multiple recipients of list ORACLE-L List, Can Oracle version be determined based on size of Oracle.EXE file on Windows? I am looking for a valid way of determining the patch level without having

RE: Urgent - Help ....

Hi Harsha, You can modify column length as done in second step below: SYSTEM@OHIL create table test121 (col1 number (5)) tablespace users ; Table created. SYSTEM@OHILalter table test121 modify col1 number(8) ; Table altered. SYSTEM@OHILdrop table test121 ; Table dropped. Cheers, Rajesh

RE: DBMS_JOB : Can submit but does not execute

You have to run the job after you submit it. SQL exec dbms_job.run(24); Also make sure all init.ora parameters are set eg (job_queue_interval , job_queue_processes ) HTH, Rajesh -Original Message- Ling Catherine (CSC) Sent: Tuesday, February 18, 2003 8:14 PM To: Multiple recipients

RE: how to make sql prompt like USER@DATABASE ?

, Rajesh mm... what if i logged in with SYSTEM first then conn sys/pswd@db? it's still show SYSTEM @db. - Original Message - From: Rajesh Dayal To: Multiple recipients of list ORACLE-L Sent: Saturday, February 15, 2003 6:53 PM Subject: RE: how to make sql prompt like USER@DATABASE

RE: Reconfiguring datafiles

send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: how to make sql prompt like USER@DATABASE ?

dual / spool off @myprompt.sql set heading on set term on set feedback on Alternatively you can create a file with above lines, put that file in bin and call it anytime to make your prompt… Cheers, Rajesh Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED

Re: 2k and 8k block size

My question was specific to RAC: With a larger block size, is one not increasing the chances of pinging for the blocks? Or I dont need to worry about it with Cache fusion? A new worry for me now is that, though the block size was changed from 2K to 8K, the recommendation was to keep the SGA the

Re: 2k and 8k block size

The purpose of this feature, I believe, is to accomodate transportable tablespace restores, so that it is possible to say,transport a tablespace from a 2K block size database, to a 4k block database. Raj

2k and 8k block size

An 8.0.6 ops database being migrated to 9i RAC database on Solaris 8. The 8.0 database had an block size of 2k. Multiblock read count is 8. This is an OLTP database, all transactions almost always work on a single row. None of the row sizes exceed the block size. Hardly any chained or migrated

RE: Bind variables

Try exec sql alter session set events . Rajesh -Original Message- Sent: Monday, February 10, 2003 11:54 AM To: Multiple recipients of list ORACLE-L It worked well from SQLplus but not from procedure. Did I miss something ? SQLcreate or replace procedure testtrace 2

2k and 8k block size

An 8.0.6 ops database being migrated to 9i RAC database on Solaris 8. The 8.0 database had an block size of 2k. Multiblock read count is 8. This is an OLTP database, all transactions almost always work on a single row. None of the row sizes exceed the block size. Hardly any chained or migrated

RE: hw info on Tru64 system

of the following commands: $ uname -a HTH, Rajesh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Vladimir Barac Sent: Thursday, February 06, 2003 2:57 PM To: Multiple recipients of list ORACLE-L Subject: OT: hw info on Tru64 system Good day

Using Soft Links for Datafiles

Resending. Any takers? - Forwarded by Rajesh Rao/JPMCHASE on 02/07/03 11:51 AM - Rajesh

RE: SQL*Net Connection under-performing

Rajesh , List tnsping for tbasun Database (below) 10 ms whereas tnsping for bby01 Database (below) is 10,000 ms Qs. Is is due to the Multiple ADDRESS Entries with LOAD_BALANCE = yes for tbasun ? NOTE - tnsnames.ora file put on the Database Server itself

Using Soft Links for Datafiles

We are in the process of creating a 9.2 RAC database. And we are being forced to follow a standard whereby, all files are to be in a directory structure, say /local. No standards have yet been defined, if one were using raw volumes. And since we will be using raw volumes for the datafiles, to

RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris and

have to use it, I never do it after shutdown immediate Just my 2 cents, Rajesh -Original Message- Sent: Monday, February 03, 2003 12:49 PM To: Multiple recipients of list ORACLE-L I have to say that I still have an emotional response to 'shutdown abort', despite knowing

RE: Windows 2000 Cluster on oracle

Yes you can go for Active-Active cluster configuration of RAC or else Active-Passive configuration of Oracle Fail Safe on Windows Cluster. Both of these are available on Windows 2000 cluster. Let me know, if you want more info. HTH, Rajesh -Original Message- Sent: Tuesday

RE: Oracle doesn't start up with domain user

Check the file and folder permissions of installation files as well as database files. Give full permissions to local administrator on all the files (from root level) , things should work fine after that. HTH, Rajesh -Original Message- Csillag Sent: Tuesday, January 28, 2003 4:19 PM

RE: simple question on DDL

Well, then even Tom's vague on this one. DDL locks are automatically placed against objects during a DDL operation to protect them from changes by other sessions. Well, then even an insert statement makes changes to DD objects. Ain't locks taken then? DDL Starts by commiting. Why not declare a

Re: over-normalized?

How many join table operations do you perform, in most of the queries? As more tables are added to the join, you take a performance hit? Plus, all the space for the indexes on the additional tables? An update could end up having to write to multiple tables. So, I guess, you have to walk the tight

Re: Slow database, too MANY buffers???

Wouldnt this indicate hot blocks? How do I deduce from this, I have a large value for db_block_buffers? Thanks Raj Jonathan Lewis

Re: over-normalized?

A valid point. But say, what if an primary key, such as, employee number has to be changed, or reused? Aaaah!!! Forget it. Typed that in just for arguments sake ;-) Thanks Raj

Re: CBO not using the index even though it is faster when hinted ....

How do you know an index scan would be faster? Did you get the query to use an index? What hint? Do you have the tracing stats for both with and without an index? First, you dont have a where clause filter on an indexed column? If all the columns in the select were indexed, maybe u could have

Shared Pool - How much free memory?

I have this application which issues a lot of dynamic SQL's with literals, for each customer who logs in. And on querying v$sgastat, I see 21Mb of free memory. Does shared_pool_reserved_size show up as free memory in v$sgastat? If not, I might have some further questions? Thanks Raj -- Please

Re: simple question on DDL

That raises another doubt. For an simple insert statement, could also update the UET$ or FET$ tables? So, if the purpose was to preserve all changes to the data dictionary, What's different between OBJ$, COL$ and these space management tables? Thanks Raj

RE: simple question on DDL

Thanks Dan. The gist of your response was that all changes to the data dictionary are immediately commited. Seems to make sense to me. Maybe, thats one reason why one cannot free space below the high water mark. Coz changes to UET$ has been committed, even though the data was rolled back. I sent

Re: from Non-Archive-Mode to Archive-Mode

Arup, My initial reaction was that you were suggesting setting the parameter to know the frequency of your log switches. But now to clearly understand your point of view, and for my curiousity, how does one derive the amount of redo log generated in bytes using the SCN Numbers? Thanks Raj

RE: Database Verification

Just use RMAN to backup your databases. It will warn you about corruptions. Raj Stephane

  1   2   3   4   >