Recent content by pissallio

log in to the system using C shell, .cshrc file resides in the user's home directory and the following entries was included in the file : set prompt=`hostname`% As we know the above command is to set the command prompt. What can i do in order to include the current directory name in the command...

Hi,Santa Excellent solutions to my problems. Thanks!

Hi,santa I have observe the v$log of an nonarchived-log database in order to find something. Two status were found about the v$log; the 1st status: GROUP# ARCHIVED STATUS 1 NO INACTIVE 2 NO ACTIVE 3 NO CURRENT Because the database was in...

Thank you for your reminding

Thanks for your reply

The data dictionary can be devided into two catagories: 1. Data dictionary tables 2. dynamic performance tables Are all tables started with "V$" dynamic performance tables? such as V$BACKUP ?V$DATAFILE ?V$TEMPFILE ?V$TABLESPACE Any other tables that belong to dynamic performance views ?

SQL>select group,sequence,archived,status from v$log GROUP# SEQUENCE# ARCHIVED STATUS 1 193938 YES ACTIVE 2 193939 NO CURRENT 3 193937 YES INACTIVE 9 193936 YES INACTIVE My Oracle database was in archived mode. And if an online redo log file was in "active"...

What's the benefit of using OMF ? Here is additional two puzzles i have met with: If I want to use OMF, Do i have to define the "DB_CREATE_ONLINE_LOG_DEST_N" and "DB_DATA_FILE" parameter in the initSID.ora file first ? When create a database using "create database" command, I intend not to...

Hi,santa Thanks for your reply. We can use "show sga" to list fixed size and variable size. I think that "fixed size+variable size" should be equal to "java_pool_size + large_pool_size+shared_pool_size" which is configured in the init.ora file. Am i right ?

Hi,santa It really helps. Thanks for your continuous help

In "ORACLE 9i DBA Fundermentals-1",page 1-33,the following description about checkpoint can be found : "An event called a checkpoint occurs when the Oracle background process DBWn writes all the modified database buffers in the SGA,including both committed and uncommitted data,to the data...

Hi,santa Thanks for your reply. We can use "show sga" to list fixed size and variable size. I think that "fixed size+variable size" should be equal to "java_pool_size + large_pool_size+shared_pool_size" which is configured in the init.ora file. Am i right ?

Hi,daFanze It's a newly created fs

As we know the shared pool enviroment contains both fixed and variable structures,what's the benefit of that ? If the shared pool enviroment contains only fixed or variable structures, what will be the result ?

# df -k Filesystem kbytes used avail capacity Mounted on /dev/dsk/c0t1d0s0 962571 10 866304 1% /chh partition> print Current partition table (quar): Total disk cylinders available: 7506 + 2 (reserved cylinders) Part Tag Flag Cylinders Size Blocks 0 unassigned wm 0 - 434 1000.84MB...