of doing this.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Sent: Monday, February 04, 2002 9:55 AM
To: Multiple recipients of list ORACLE-L
Hi
I there any view which can tell us which indexes are not in use?
Thx
-Seema
also send the HELP command for other
By any chance you have your redo logs on RAID05. Looking the wait timings I
strongly feel your I/O sub system is over loaded.
Pls let us know the hardware architecture. (Disk config, raid, etc). That
would help us understanding your problem better.
Best Regards,
K Gopalakrishnan
Bangalore
Probably that user might have connected to the instance. Check V$session.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Samir
Sent: Tuesday, February 05, 2002 1:41 AM
To: Multiple recipients of list ORACLE-L
Hi list,
Can anybody help me how to identify why
Hi,
Anyone running oracle9i with multiple datablock sizes in their database...?
I am looking for the result for this query from a database which has
multiple block sizes?
SELECT *FROM X$KVIS:
You can reply to me directly if you choose to do so.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
DBA_TABLES.DEGREE?
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Gramolini
Sent: Tuesday, February 12, 2002 6:14 AM
To: Multiple recipients of list ORACLE-L
Good morning all,
It there a view which tell which tables are in parallel?I would like to
see which
Title: Fragmentation of data dictionary
Helmut,
X$
tables are NEVER stored in the disk. THey are just memory structures in the SGA
and the contents are zeroed (are reset) when you shutdown the database. THey
will not cause data dictionary fragmentation.
Best Regards,K
don't see any reason for row locks becoming table locks unless you
have an un indexed foreign key.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Mascranghe
Sent: Tuesday, February 12, 2002 4:33 AM
To: Multiple recipients of list ORACLE-L
Hi all
We are running
No need to bounce the instance. You can dynamically chance the location
using ALTER SYSTEM command.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Thomas F
Sent: Wednesday, February 13, 2002 12:49 PM
To: Multiple recipients of list ORACLE-L
Nope. Create the new
Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: K Gopalakrishnan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public
. it can not hold undo information for any transactions.,
THis condition is called as DEATH of a Rollback segment. THis is true for
SMU also.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Sent: Thursday, February 14, 2002 2:35 AM
Hi Ganesh,
Could u please
..:)
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Mladen
Sent: Thursday, February 14, 2002 12:26 PM
To: Multiple recipients of list ORACLE-L
How long does a database have to remain running in order for a rollback
segment to go to the happy hunting grounds? Have you
Thanks for the correction. I was looking some other column.
I am sorry for the mistake.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Mladen
Sent: Thursday, February 14, 2002 2:42 PM
To: Multiple recipients of list ORACLE-L
Number of wraps gets reset
There is no simple way unless the some other process is waiting for those
rows. In that case that is visible in V$SESSION.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Mascranghe
Sent: Thursday, February 14, 2002 7:18 PM
To: Multiple recipients of list ORACLE-L
select max(ktuxesqn) from X$KTuxe;
MAX(KTUXESQN)
-
956
It is not getting changed by startup force.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Mladen
Sent: Thursday, February 14, 2002 2:42 PM
To: Multiple recipients of list ORACLE-L
Number
the conversion. Otherwise this
could be a BUG.
BTW Which version of Oracle? Looks like you are on some 64 Bit Oracle?
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Sent: Friday, February 15, 2002 4:48 PM
To: Multiple recipients of list ORACLE-L
I'm finding HUGE
.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Mascranghe
Sent: Thursday, February 14, 2002 7:18 PM
To: Multiple recipients of list ORACLE-L
Is there a way to find out what rows are being locked ?
Thanks
--
Please see the official ORACLE-L FAQ: http
Tom,
Have you checked the
V$SESSION_EVENT for those sessions to find out the waits?
Best Regards,K GopalakrishnanBangalore,
INDIA
-Original
Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Tom PallSent: Friday, February 15, 2002 10:24
AMTo: Multiple
Hi,
You can order the CD Pack from Oracle Store ($39.99)
Checkout http://store.oracle.com
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Sent: Tuesday, February 19, 2002 8:38 PM
To: Multiple recipients of list ORACLE-L
Hi,
Did anyone know where to download
Steve,
Do you have the BUG#?
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Sent: Monday, February 25, 2002 3:48 PM
To: Multiple recipients of list ORACLE-L
OWS confirmed it's a bug and needs to be back ported for Linux. Sigh...
-Original Message-
Sent
,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Manning
Sent: Wednesday, February 27, 2002 2:19 PM
To: Multiple recipients of list ORACLE-L
Does itrprof seem broken for anyone else? trace files I analyzed with
it yesterday are failing now, and even tiny files aren't working
Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Kirti
Sent: Thursday, February 28, 2002 7:13 AM
To: Multiple recipients of list ORACLE-L
That's what I thought too, but it will skip extents from any LMTs in use.
And getting extents info when LMTs are is use will be slower
ITL slots for 2K block size. If you set
INITRANS
more than 41 they are simply ignored and only 41 ITLS are created in that
block.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Eskridge
Sent: Monday, March 04, 2002 4:08 PM
To: Multiple recipients of list ORACLE-L
are coming from the rdbms kernel. So they will not
have a valid
object# or the associating details with them. So that might be the reason
for your
2030 errors (I THink!!)
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
[EMAIL PROTECTED]
Sent: Monday, March 04, 2002 4
command for other information (like subscribing).
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: K Gopalakrishnan
INET: [EMAIL PROTECTED
Jared,
I think he is talking about direct grants. Not granting through a view.
SQL grant select on X$BH to system;
grant select on X$BH to system
*
ERROR at line 1:
ORA-02030: can only select from fixed tables/views
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
www.veritas.com
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Mitchell
Sent: Wednesday, March 06, 2002 5:03 AM
To: Multiple recipients of list ORACLE-L
Can anyone supply a site or information about how to use Veritas software as
it applies to
databases
Hi,
It is expected behaviour only. That is why it is recommended to do a log
switch and copy the log files once
the backup is complete
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Sent: Wednesday, March 06, 2002 12:49 PM
To: Multiple recipients of list ORACLE-L
Jonathan,
Some intelligent person at MD forgot to add the tkprof (Trace Kernel
PROFile)
with the NT versions. OWS has a patch for that.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Gennick
Sent: Wednesday, March 06, 2002 3:54 PM
To: Multiple recipients of list
Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, March 07, 2002 12:04 PM
To: Multiple recipients of list ORACLE-L
I believe someone else had asked this question before, but I did not see a
reply. Does anyone know the number of transaction
Rajesh,
The transaction slots are clearly visible in the Undo Header dumps. I
think this takes some 40 bytes space in the undo header block and this
limits the number of ***concurrent** transactions for that undo segment.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original
Steve,
I suspect this could be another BUG like your old V$sysstat.
By any chance you have set the _sql_exec_progression_cost to
lowest values?
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Sent: Thursday, March 07, 2002 12:19 PM
To: Multiple recipients
I think he is looking for number of KTUXEs per block
not KTBIT (ITLs).
Does this ITL algorithm same for undo blocks also?
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Sent: Thursday, March 07, 2002 12:41 PM
To: Multiple recipients of list ORACLE-L
Basically
Query V$SESSION. This will give the number of connections to the database.
OR look for V$sysstat ' logons current'
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Sent: Thursday, March 07, 2002 5:43 PM
To: Multiple recipients of list ORACLE-L
Hello List,
Just
Looks like it is down. Check Kevin Loney's site at
http://www.kevinloney.com/
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Kurliye
Sent: Saturday, March 09, 2002 2:23 AM
To: Multiple recipients of list ORACLE-L
Hi,
Anyone has idea - what happened to website
Ganesh,
Your comment is bit inaccurate. THis is because of the ITL Entry shortage
(no-row) and bumping PCTFREE for the respective tables will solve the
problem.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Sent: Monday, March 11, 2002 5:38 AM
To: LazyDBA.com
Ganesh,
You
can find FTS in the following methods:
1. THe
existence of the 'db file scattered read' in the V$session_event. From this we
can find the file#, Block# and #of Blocks.
Using
this info we can get the segment name from the dictionary.
2. ANy
block read using Sequential Scan
s(user_extents).
4. This give accurate info to the file level, not
segment level.
Alex.
- Original Message -----
From:
K
Gopalakrishnan
To: Multiple
recipients of list ORACLE-L
Sent: Monday, March 11, 2002 11:07
AM
Subject: RE: how to know ,t
see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: K Gopalakrishnan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
if there is a mismatch between
file headers which is signaled by
ORA-00600 [2662].
Any volunteers?
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Robert
Sent: Tuesday, March 12, 2002 11:42 AM
To: Multiple recipients of list ORACLE-L
I wonder if any Oracle database has ever yet
like _Max_Giga_SCN
which starts (!!) the SCN at higher values.
Have anyone used that?
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Kanagaraj
Sent: Tuesday, March 12, 2002 3:00 PM
To: Multiple recipients of list ORACLE-L
I think you can **artificially** force
Sinardy :
It is expected behavior only. Bit map indexes are not stored in a tree
format and sorting will have no impact.
Have a look at bit map concepts in Oracle Documentation.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Sent: Tuesday, March 12, 2002 11:38 PM
Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, March 07, 2002 12:04 PM
To: Multiple recipients of list ORACLE-L
I believe someone else had asked this question before, but I did not see a
reply. Does anyone know the number of transaction
Rajesh,
The transaction slots are clearly visible in the Undo Header dumps. I
think this takes some 40 bytes space in the undo header block and this
limits the number of ***concurrent** transactions for that undo segment.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original
Title: RE: Anyone use V$SESSION_LONGOPS ???
John:
These
are not reposts.. Infact one of my post (which I have sent long back) appeared
today.
Jared:
Any ideas?
Best Regards,K GopalakrishnanBangalore,
INDIA
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL
Query V$SESSION. This will give the number of connections to the database.
OR look for V$sysstat ' logons current'
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Sent: Thursday, March 07, 2002 5:43 PM
To: Multiple recipients of list ORACLE-L
Hello List,
Just
Steve,
I suspect this could be another BUG like your old V$sysstat.
By any chance you have set the _sql_exec_progression_cost to
lowest values?
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Sent: Thursday, March 07, 2002 12:19 PM
To: Multiple recipients
Too many archived logs?
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Rajendra
Sent: Friday, March 15, 2002 1:39 PM
To: Multiple recipients of list ORACLE-L
I know it is normal, but is it normal to expand 15 times in 3 days?? This is
9012 in AIX 4.3
Robert:
I was about to tell that. You hit the reply before me (that too on Sunday!!)
BTW THis method is available from 7.x onwards. TO be precious from 7.3.3
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Robert
Sent: Sunday, March 17, 2002 7:53 AM
To: Multiple
AFTER RESETLOGS.
But since
this is an unsupported I strongly suggest Jared' point..
A COMPLETE COLD BACKUP AFTER RESETLOGS.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Kanagaraj
Sent: Monday, March 18, 2002 10:18 AM
To: Multiple recipients of list ORACLE-L
Chris,
Just do a ORADEBUG HANGANALYZE and upload the trace file to
http://www.unal-bilisim.com 's Hanganalyzer.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Chris
Sent: Monday, March 18, 2002 10:28 AM
To: Multiple recipients of list ORACLE-L
We have
Hi,
Deadlocks happen for N number of reasons. Please post
the deadlock graph for further investigation.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
[EMAIL PROTECTED]
Sent: Friday, March 22, 2002 10:38 AM
To: Multiple recipients of list ORACLE-L
Is anyone
!!
Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
Gopalakrishnan,
Bangalore, INDIA.
__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: K Gopalakrishnan
INET
subscribing).
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: K Gopalakrishnan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538
conventional export and Import. I don't have the
exact figures .. but this will reduce the downtime if you
have faster interconnect.
Why don't you file an enhancement request with oracle
seeking this ? :-)
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Wagner
Sent
).
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: K Gopalakrishnan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego
db_file_multiblock_read_Ccount to 32).
How are you tracing that value? Have you set the
event 10046 or just selecting from the V$session_event?
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
for that table I advice forcing primary key
for that SELECT COUNT(*)..
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: K Gopalakrishnan
INET
for other information (like subscribing).
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: K Gopalakrishnan
INET: [EMAIL PROTECTED]
Fat City
Kirti,
Starting from 8.1.6 you can set to 32K. The 1MB min
value is applicable only for 8.1.5.
Best Regards,
K Gopalakrishnan
-Original Message-
Kirti
Sent: Sunday, September 30, 2001 10:50 AM
To: Multiple recipients of list ORACLE-L
But if your are not planning on using Java
/processtate dumps by setting
an event 3113. I don't think this is possible.
Have you ever trued setting event 3113 and
got an errorstack ? Just Curious.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Trassens
Sent: Monday, October 01, 2001 3:40 AM
To: Multiple recipients
AFAIK there are no books (other than the upcoming RMAN pocket reference
from Oreilly). Oracle Documentation is comprehensive and Rama's backup
Recovery handbook also has some good details abt RMAN.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
+ (91) 98451 78868
-Original Message
Hi,
If you are interested you can look for DSI Seminar series..
Data Server Internals.
Search for 'internals' in http://www.oracle.com/education.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
+ (91) 98451 78868
-Original Message-
Sent: Thursday, October 25, 2001 12:21 PM
Hi,
These are IO Slaves. Either your DBWR or LGWR will be using. They will
exit automatically if they are idle for more than a minute .
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
+ (91) 98451 78868
-Original Message-
[EMAIL PROTECTED]
Sent: Sunday, October 28, 2001 9:00 AM
Vladimir,
Have a
look at
http://www.geocities.com/kgkrish/transactions.html
This will
solve most of your questions. If not Pls let me know.
Thanks
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
+ (91) 98451 78868
-Original
Message-
From: [EMAIL PROTECTED
Hi,
The document is a draft
copy. There are few (not much tech)
errors. So take that with a pinch of salt
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
+ (91) 98451 78868
-Original
Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of K
I have no problems in accessing that.
Alternatively you can find that at
http://www.revealnet.com/newsletter/newsletter_1100.htm
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
+ (91) 98451 78868
-Original Message-
Thapliyal
Sent: Monday, October 29, 2001 11:05 AM
To: Multiple
I have no problems in accessing that.
Alternatively you can find that at
http://www.revealnet.com/newsletter/newsletter_1100.htm
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
+ (91) 98451 78868
-Original Message-
Thapliyal
Sent: Monday, October 29, 2001 11:05 AM
To: Multiple
I think 1 is NULL mode and 3 is EXCLUSIVE mode.
No idea abt 0.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
+ (91) 98451 78868
-Original Message-
Sent: Monday, October 29, 2001 10:00 PM
To: Multiple recipients of list ORACLE-L
out of curiosity...
what does the values 0 and 1 implies
Any logical read (which includes SCN verification)
Is called as consistent get.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
+ (91) 98451 78868
-Original Message-
Sent: Tuesday, October 30, 2001 1:46 PM
To: Multiple recipients of list ORACLE-L
Hi. What exactly does Consistent Gets
I don't think this is possible because few of the session level
settings will reside in PGA and it will be bit difficult to
intrude in to this private memory.
I am not aware of any events or hidden commands to do that
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
+ (91) 98451 78868
).
The first one is free and Hotsos is free for their customers.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
+ (91) 98451 78868
-Original Message-
Sent: Wednesday, October 31, 2001 3:55 PM
To: Multiple recipients of list ORACLE-L
Mike - Haven't used this, so I will be interested in how
Hi,
For V$ views you can find the details in Oracle Xi Reference Manuals.
For X$ tables the information is not documented externally.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
+ (91) 98451 78868
-Original Message-
Shrinivas (MED, Keane)
Sent: Friday, November 02, 2001 4:00 AM
By any chance HOTBACKUP is turned on?
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
+ (91) 98451 78868
-Original Message-
Sent: Sunday, November 04, 2001 6:00 AM
To: Multiple recipients of list ORACLE-L
H All,
I am facing a very typical problem. One of my client's database
], [], [], [], [],
[], [],
[]
ORA-00600: internal error code, arguments: [kgskdecrstat1], [], [],
[], [],
[], [], []
=
Have a nice day !!
Best Regards,
K Gopalakrishnan,
Bangalore, INDIA
ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
=
Have a nice day !!
Best Regards,
K Gopalakrishnan,
Bangalore, INDIA
the old
costing model which works best for partition tables.
(In the above said example the new costing mode will say
the table access cost as 28 blocks instead 10 blocks)
Please correct me (Esp:Jonathan Lewis) if I am wrong !!!
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original
for BitMap Blocks (level1?) in the
V$WAITSTAT.
Best Regards,
K Gopalakrishnan
-Original Message-
WILLIAMS
Sent: Tuesday, November 26, 2002 1:30 PM
To: Multiple recipients of list ORACLE-L
Oracle says that when a file autoextends, there is a slight delay. Does
anyone know which Oracle WAIT
make the executable in Unix
ports. But the point here is the hacker can do anything
using the BBEd and this can be done even while your
database is up and running !!
What is their take on this kind of attack(!)s?
Best Regards,
K Gopalakrishnan
-Original Message-
[EMAIL PROTECTED
Arup:
BBED is
B lock
B rowser
ED itor.
Best Regards,
K Gopalakrishnan
-Original Message-
Sent: Tuesday, November 26, 2002 6:24 PM
To: Multiple recipients of list ORACLE-L
What is BBED? I never heard of it.
From: K Gopalakrishnan [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED
the regular stats update when
you set the MONITORING options.
In a short answer, yes.. you can set the event
as suggested !!
Best Regards,
K Gopalakrishnan
-Original Message-
Rosenthal
Sent: Thursday, November 28, 2002 8:04 AM
To: Multiple recipients of list ORACLE-L
cleaning deleted
Rick:
ANjo Kolk classifies this wait event under one of
the IDLE wait events.i.e nothing to worry if you
see them in excessive.
Best Regards,
K Gopalakrishnan
-Original Message-
Sent: Tuesday, December 03, 2002 3:10 PM
To: Multiple recipients of list ORACLE-L
Hey all,
Does anyone
.
THere are some kernel events to trace the reconfigurations,
and an underscore parameter (I think it is _imr_active !)
to disable the 29740 usually not recommended.
For investigation , review the check point, LMON trace files
and check the OS log files.
Best Regards,
K Gopalakrishnan
-Original
... but I can take an
explanation
Raj
=
Have a nice day !!
Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: K Gopalakrishnan
INET: [EMAIL PROTECTED]
Fat
immediately notify corporate MIS at (860)
766-2000 and delete this e-mail message from your computer, Thank
you.*2
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: K Gopalakrishnan
INET: [EMAIL
of physical I/Os to the disk
happened?
=
Have a nice day !!
Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: K Gopalakrishnan
INET: [EMAIL PROTECTED]
Fat
you want to be removed from). You may
also send the HELP command for other information (like subscribing).
=
Have a nice day !!
Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
--
Please see the official ORACLE-L FAQ: http
containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
=
Have a nice day !!
Best Regards,
K Gopalakrishnan,
Bangalore, INDIA
Mogens:
Yes. You are right. You have to bump the SCNs globally
(i.e. across all data files to higher number, say 1 Billion)
using the event 10015 and ADJUST_SCN. Then we can safely
open the database and rebuild that.
KG
Best Regards,
K Gopalakrishnan
-Original Message-
Norgaard
Read Only Dependencies in the KGL.
Best Regards,
K Gopalakrishnan
-Original Message-
Mike (NESL-IT)
Sent: Friday, January 10, 2003 8:39 AM
To: Multiple recipients of list ORACLE-L
Ron,
that's a bit of a puzzle because it should have been available since 7.3.2.
Which user are you
The only one parameter.. control_files.
Rest are optional.
Best Regards,
K Gopalakrishnan
-Original Message-
WILLIAMS
Sent: Monday, January 13, 2003 7:44 AM
To: Multiple recipients of list ORACLE-L
Hemant - I was just going from my hastily written class notes. Sorry about
Rajesh:
You can schedule statspack snaps at 30 minutes
interval and then compare the response times
at each interval.. But the question is
'what do you mean by average response time?'
KG
Best Regards,
K Gopalakrishnan
-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, January
!!
Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: K Gopalakrishnan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list
Kirti:
I think the interval is changed to 5 minutes from
3 hours starting from 9i (rel2?).
Best Regards,
K Gopalakrishnan
-Original Message-
Kirti
Sent: Wednesday, January 29, 2003 8:19 PM
To: Multiple recipients of list ORACLE-L
Lisa,
Monitoring, by itself, does not fire any
Kirti:
Sorry for the typo. It is 15 minutes.
--- K Gopalakrishnan [EMAIL PROTECTED] wrote:
Kirti:
I think the interval is changed to 5 minutes from
3 hours starting from 9i (rel2?).
Best Regards,
K Gopalakrishnan
-Original Message-
Kirti
Sent: Wednesday, January
are written to dictionary from SGA once in 15 minutes and then
the tables are examined to get the stale stats.
Metalink note 102334.1 has some details..
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
--- Deshpande, Kirti [EMAIL PROTECTED] wrote:
Gopal,
I should have waited a bit longer
Title: Message
Hi,
THe
syntax is incorrect. Incorrect HINTs are treated as
comments.
replace the comma with blank space and your hint will
work
as
expected.
Best Regards,K Gopalakrishnan
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf
Jonathan:
How about calling the DBMS_SYSTEM.READ_EV procedure?
I think this is simpler than going to the UGA dumps..
THe restriction with DBMS_SYSTEM is, you can not get
the event settings of the other sessions. But Dumps
can.
Best Regards,
K Gopalakrishnan
-Original Message
Hi,
It is just telling that you are doing HARD PARSE.
Hard Parse is indicated in the trace file as
'misses in library cache';
Best Regards,
K Gopalakrishnan
-Original Message-
Gorbounov,Vadim
Sent: Thursday, February 13, 2003 6:49 AM
To: Multiple recipients of list ORACLE-L
Dear
from the V$resource_limit to the lm_%
parameters to get an idea about the resource utilization.
BTW Do you see Dynamic resources/locks allocated message
in the alert logs?
Best Regards,
K Gopalakrishnan
-Original Message-
MARREIROS,RUI (HP-Portugal,ex1)
Sent: Thursday, February 13
101 - 200 of 281 matches
Mail list logo
