 | | | Oracle List | | Dear All
I like to use the NOLOGGING workaround for DOMAIN index provided by metalink.
http //metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id NOT&p_id 135046.1
We atype shortcud (win key the flag) R
Then type cmd.
You too can go to the short cut too and to avoid it close automatically sometimes you need.
To change the behavior of it for example to av
If you 've got about 6 hours and about 24 GB
of disk space free I 've got a script that will get
you to height 24. You 'll have to double the
time and space to see what happens if you
try to get in your sqlnet.ora file add the following lines
TRACE_LEVEL_CLIENT admin
TRACE_DIRECTORY_CLIENT <location > # Where to put trace files
TRACE_FILE_CLIENT cli # Filename prefix
TRAThe 8.1.7 Administrator 's Guide suggests that the DBA should
force users to change their passwords periodically. I cannot however
find command in the SQL Reference which automates this function.
I get it now. Since you can 't create a non-prefixed global partitioned index (the part I didn 't think about) Oracle will only have to check one partition in the global index to enforce uniqueness in tOr alternatively use fdisk to create DOS partition. If your windows is installed
on disk C use fdisk C then delete the primary partition if it 's not a FAT partition
and create the new primarySince it is raw you have to use the lvm/fdisk/format command to know its
size. Detailed command name depend on your os and lvm type.
If you have added it as the dbfile simply query the
v$datafile <apologies for the off topic post Jared >
For anybody who is at the Hotsos Symposium in Dallas and still here
Wednesday evening it looks like it should be beautiful patio weather.
I think that mI could not get much of help from Oracle documentation about this. I think
this is one of the poorly documented feature of Oracle ( Or I may be looking
at the wrong place ). Is there any body out thThanks Stephane Faroult
I don 't udnerstand how Oracle admin roles
I have the impression there is a formula like
#roles*user*xbytes
To determine the role memory usage.
Or it is only a way toSolaris 2.9
Oracle 9i 64 bit
Have successfully executed tg4ifmx
Have successfully tested odbc
Can use tnsping for either heterog. services or the gateway for informix (have configured both).
HoArun
On the Ottawa Oracle User Group website under downloads there is a paper
which was presented in January 2003 called Programming with Advanced
Queueing. You can down load it from there. TI asked a question about hard parses on Friday. What I am trying to do is tell whether my variable inlist code is incurring a hard parse or not before moving forward. Here is the test I am doing.
1Is optimizer_mode inside pl/sql program will be always 'ALL_ROWS '
irrespective of what has been set in instance or session level?
Thanks and Regards
Satheesh Babu.S
Bangalore
DISCLAIMER Hello all
I seem to remember that an index does not need to be partitioned on the
same key as a table. Does anyone know does this refer to hash
partitioned indexes? I have read through the doHello list
Can any one give me an example how can I delete log files <2hrs to my
system time.
--
Best Regards
Jaffar OCP DBA
Banque Saudi Fransi
Saudi Arabia
Try with "merge ".
On 03/08/2004 03 04 58 AM "Kommareddy Srinivas (MED Wissen Infotech) " wrote
> HI All
>
> I want to perform date load from table A to table B. Its failing with unique
> Hi all
DB 9i Solaris 2.8
When I tried to enable a trigger its hung for long time. I checked the
sessions for any waits. I see that the session is waiting on library cache
locks.
i fur
What is your "hypothetical " explanation for why a single user with a 5000 row
update causes ITL Waits and Latch Misses and "slowly but surely cripple
the system " ? Are you sure about the "surely "Friends
If you 're in the Atlanta area around March 22-23 you may want to register
for our 2004 Georgia Oracle Users ' Conference. Tom Kyte (asktom.oracle.com)
and Rich Niemiec (TUSC) are headlinDoesn 't seems to be down but really slow...
/Johan
On 10/30/06 Niall Litchfield <niall.litchfield@(protected) > wrote
> Appears to be down for me. Perhaps it 's all the Linux people pointing
> up2datThis is a forum for Oracle technical issues and other related issues.
The language used in the post below is wholly inappropriate.
This is not a forum for name calling criticism of articles orOthers have answered most of this I 'll add a summary...
1. You can tell whether timed_statistics was activated by checking your
raw trace data. If you see any non-zero value for a tim field it wIn that case maybe it was so fast that the CPU time was in the hundreds or even thousands of a second range.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
jerome.whittle@(protected)
6Juan Cachito Reyes Pacheco wrote
>
> Hi somebody know why there is parameter MAX_ENABLED_ROLES
> The first impression I got is because they take too much memory so is
> better limit them.
>
I think there will be some minimum requirements for the processor abilities
but speed is not an issue. For example I have 8.1.7 running on an Intel
166 MHz box with 128 MByte RAM and it runs fYou might consider MAXIMUM AVAILABILITY as well. As long as the standby is
up it behaves like MAXIMUM PROTECTION. However if the standby fails the
primary will stay up and running at the cost oJay wrote
>
> Dear All
>
> I have Madrake Linux V 9.0 at home. Is it possibel to install 10G on this
> platform?
>
> Thanks
> Jay
Jay
Try
./runInstaller -IGNORESYSPREDoes each latch chain have its own latch? Or does the DB_LRU_LATCH_CHAIN paramter determine how many total latches there are in the buffer cache?
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transition |
|
|
