 | | | Oracle List | | Vikram
Only diff. in RAC is that you would need to create two thread log groups if
it is 2 node RAC and assign one to each database instance.
I mean there is instance specific redo thread.
Suppose yAt http //download-east.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_rls.htm#i998159 <http //download-east.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_rls.htm#i998159 >
sthref6221CONTEXT_SDoes anyone know how big the first_rows buffer is? (If I use the hint how
does Oracle determine how much data to bring back to me initially?)
Hi
Please let me know how to identify that a session is executing a
Create Table As Select from v$ tables
Thanks
Joseph Amalraj
For errors in "da vinci code " http //www.daviWhat is the best web site out there that presents information explanation
and possiblity of a tutoratial on data normalization and normal forms?
thanks.
Hey List
I think I found my problem - but have no idea how to solve....
When checking the CMAN log 's I found
(CONNECT_DATA (SERVICE_NAME red.domain.de)(CID (PROGRAM sqlplus@(protected))(HOST red)(USER rThat means the listener does not know what you are trying to connect to
what is the output of lsnrctl status on the server?
On 25/04/06 Mathias Diehl <md@(protected) > wrote
>
> but sqlplus does Vivek
That is a pretty wide-open question. If you are really starting with no
knowledge why don 't you use Google and search with those terms and the term
"tutorial " or "best practices ". Perhaps youWe are experiencing occassional instances of sqlldr hanging. sqlldr is
generating no errors there appears to be plenty of room in the tablespace
and there are no errors in the alert log.
Anyone seePL/SQL pipelined function in 9i and up. Before 9i it 's a bit more
complicated.
Go to http //www.asktom.oracle.com/ and do a search on "variable in
list ". Lots of hits lots of examples.
-Mark
Guys say I 'm in a development environment and to be sure I dont have
gaps in my archive log or I just feel like resetting them to 0 I d to
to reset the logs without going through the trouble ofIn windows you can set the "working directory " for your sql scripts by
setting the SQLPATH environment variable. This is a handy feature.
Today I tried to set that in unix and it woudnlt recognJuan
I think you have to execute dbms_registry.removed( 'ORDIM ')
HTH
Fairlie
Juan Carlos Reyes Pacheco <juancarlosreyesp@(protected) > wrote
running the @(protected) \oracle\ora92\ctx\admin\dr0It would have to be a very old release indeed.
IIRC Oracle 7 sent the password encrypted.
There were exceptions the first logon attempt was encrypted.
Subsequent attempts ( as in you typed the pa
Quite possibly.
In the absence of any other directive the continuous
checkpointing mechanism sets the effective size of
log_checkpoint_interval to 90% of the smallest log
file. This means you couList
Or shop is in the process of migrating the applications from desktop to Citrix. The admin 's would like to install the oracle client on the Citrix servers rather than the desktop. I have been unSo am I.
Carel-Jan
On Mon 2006-04-24 at 12 16 -0400 Bobak Mark wrote
> This should be a great event! I plan to attend!
>
>
> --
> Mark J. Bobak
> Senior Oracle Architect
> ProQuest InformatHi All
I allow myself doing a bit of advertising for an event that I 'm organizing in Z?rich Switzerland. If this is a nuisance for somebody my apologies! I do that because it 's a particular event. Greetings
Oracle Version 9.2.0.5
Is there a way to map controlfile timing to the last Archive log that was
in the Souce Database while controlfile backup was taken.
Right now I am recovering a You can also query v$segment_statistics for the object(s) with highest
"buffer busy waits "
Joseph Amalraj
2006/4/24 Stephen Anderson
>
> Hello
> I have a 10 minute statspack report from aWhen I started at my present company about 5 years ago we were lumped
in with the UNIX/NT admins and the network guys. As of about 3 years
ago we are now in the same unit as the developers and archi8.1.7.4 was a very stable release. Ahh the good old days.
Laura
>I have been researching how to keep users from accessing
>tables without going through an application.
Why not providing privileges through roles which are protected by a password or proceduGabriel
1) You need to FETCH as well as OPEN
2) You need to end the quotes in the dbms_output( 'Print ') / ( 'No Print ')
Here 's a working version using DUAL and DUMMY instead
declare
TYPE lista According to the docs Linux LVM is not supported as it 's not a cluster
aware VM. Though it generally works but probably won 't be supported.
I was able to setup 10gR1 and R2 RAC on LVM devices includinI suggest to look first at Oracle Installation Guide for Linux.
2006/4/23 vikram singh <vikramsingh120@(protected) >
> Hello All
> i am new to oracle and linux platform. I have been assigned tWell established company in the Nashville Tennessee area has a position
available for
an Oracle DBA to support their SAP and SAP BASIS environment.
Relocation assistance and excellent benefits ....Greetings
Oralce Version 9.2.0.5
ITs Friday evening. Want to confirm that a my understanding is
Cold (Any Backup except exp) Backup Taken on HP-UX 64 bit cannot be
restored on a SUN Box to setuget used to it it 's the wave of the future )
reminds me of when I got everybody mad because I wanted to stay with
a bunch of 2GB drives instead of a few 18GB drives they wanted to
give me - thatHi
(and thanks to all the other answers I so far has got I will take time this weekend and test the sugguestions)
You are right I hadn 't test the script I included I thought I copied the correct |
|
|
