Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 2319

All versions of Oracle database. Add a version-specific tag like oracle-11g-r2 if that context is important in the question. Do not use for Oracle products such as applications or middleware or other database products owned by Oracle, like MySQL or BerkeleyDB.

3
votes
1answer
Does 'LGWR' writes to online redo log files strictly in circular fashion? I saw this sentence from Oracle documentation. If archiving is disabled (the database is in NOARCHIVELOG mode), then …
asked Sep 19 '11 by Ogrish Man
1
vote
2answers
This is the explanation of this parameter from Oracle. This is the description of the description in the explanation. From the documentation we know that this parameter is not modifiable (Modifiable … : No). But in fact I can modify it: sys@ORCL>alter system set control_files = '/u01/app/oracle/oradata/orcl/control01.ctl,/u01/app/oracle/flash_recovery_area/orcl/control02.ctl'; alter system set …
asked Nov 14 '11 by Ogrish Man
1
vote
2answers
The following 2 sentences are excerpt from Oracle documentation. You can easily fine them by google them directly. My question is, 4G and 4M are the unite of digital information storage. What's the …
asked Sep 13 '11 by Ogrish Man
4
votes
2answers
I want to know how to use the object number that extract from rowid column? It's seems that this oracle number is not the same as object_id in dba_objects view. Anyone can help me with it please …
asked Dec 28 '11 by Ogrish Man
5
votes
1answer
You can set the database in quiesced mode by the following command. alter system quiesce restricted; After running this command all sessions except the ones that have DBA privileges will hang th …
asked Oct 25 '11 by Ogrish Man
1
vote
It depends on what specific problem you are asking. The two queries you provided can give others some general information of your database, which should be provided in almost all your questions. BTW, …
answered Dec 21 '11 by Ogrish Man
4
votes
I found the answer of my own question. The so called object number from DBMS_ROWID.Rowid_object corresponds to dba_objects.data_object_id, not object_id. sys@ORCL>select owner, object_name, object_id …
answered Dec 29 '11 by Ogrish Man
1
vote
1answer
The description of deferred and scope keyword is listed below (extracted from Oracle documentation). The meaning of them gives me an indication that deferred can just use the memory scope. Is my … next shut down and started up again. You must specify SPFILE when changing the value of a static parameter that is described as not modifiable in Oracle Database Reference. BOTH indicates …
asked Dec 24 '11 by Ogrish Man
1
vote
2answers
From the Oracle documentation: To find the children of a parent row, Oracle evaluates the PRIOR expression of the CONNECT BY condition for the parent row and the other expression for each … . When Oracle select child node for a parent node, it selects from all rows except the current row right? Can a row appear multi times in the result set (I mean a row is both the child node of row A and row B)? …
asked Oct 28 '11 by Ogrish Man
3
votes
1answer
: This is the version information: sys@ORCL>select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition …
asked Oct 25 '11 by Ogrish Man
7
votes
3answers
The following text is extract from oracle documentation. Start the instance, and mount and open the database. This can be done in unrestricted mode, allowing access to all users, or in …
asked Jul 5 '11 by Ogrish Man
1
vote
3answers
When installing Oracle, there is a step which is to install all necessary packages. I use the following command to test whether a package is installed and install them if they are missing: rpm -qa …
asked Aug 6 '11 by Ogrish Man
3
votes
3answers
The following excerpt is from Oracle concepts. Maybe this is a stupid question, but I really need your help to understand it. My question is: What's does the thread mean in the context thread … difficult to fully understand this. When Oracle Database Initiates Checkpoints The checkpoint process (CKPT) is responsible for writing checkpoints to the data file headers and control file …
asked Dec 19 '11 by Ogrish Man
2
votes
1answer
I found the following sentence from Oracle documentation. If archiving is disabled (the database is in NOARCHIVELOG mode), then when the last redo log file is full, LGWR continues by overwriting … the first available active file. My question is, active log file must be used when Oracle doing instance recovery, so if active log files are overwritten, this will cause some problem if you …
asked Sep 19 '11 by Ogrish Man
6
votes
3answers
The Oracle documentation describe incarnation as: incarnation A separate version of a database. The incarnation of the database changes when you open it with the RESETLOGS option, but you …
asked Dec 7 '11 by Ogrish Man

15 30 50 per page