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...
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 ?
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...
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 ?
$cat /etc/vfstab
FS fsck#device device mouk mount mount
type pass#to mount to fsck pois at boot options
swapfs -/dev/dsk/c0t0d0s1 - - no -
ufs 1 /dev/dsk/c0t0d0s0 /dev/rdsk/c0t0d0s0 / no -
ufs 1 /dev/dsk/c0t0d0s6 /dev/rdsk/c0t0d0s6 /usr no -
ufs 1 /dev/dsk/c0t0d0s3 /dev/rdsk/c0t0d0s3 /var...
We can use "newfs -m %free" to specify the amount of space on the slice that is reserved or held back from regular users.
What's the use of these reserved space on the slice ?
I have make all the files in the directory into a .tar file using
#tar -cvf bak.tar *
a 12.jpg 578 blocks.
a 123.jpg 193 blocks.
a 1234.jpg 220 blocks.
a 41324.jpg 230 blocks.
a bgfag.jpg 92 blocks.
a fadf_005.jpg 747 blocks.
a fadsf.jpg 293 blocks.
Then i tried to use "compress bak.tar" to...
I am used to removing the last letter i have inputted with "BackSpace" key on the keyboard. But in solaris 7, I had to use "Del" key instead and it made me feel very unaccustomed.
Any way to set back to "BackSpace" ?
I had the following static route added to the route table :
(config)#ip route 198.10.1.0 255.255.255.0 161.44.192.2
2513#show ip route
Gateway of last resort is not set
161.44.0.0/24 is subnetted, 1 subnets
C 161.44.192.0 is directly connected, Ethernet0
131.108.0.0/24 is...
In the partition prompt, I want to modify the partition:
partition>modify
Then the following options appeared:
Select partitioning base:
0. Current partition table (aftermd)
1. All Free Hog
What does "All Free Hog" mean and under what circumstance should i choose the...
while p630_6c4 was restarting , I connect my pc to "serial port 2" of p630_6c4 and i can see the code output to the screen of my pc. About 2 minutes After "AIX is starting" was showed in the operator panel, "0c31" appeared on the operator panel all the time but nothing prompt on the screen of my...
I have written a Korn Shell script like this:
a=1
while a=1
do
for i in a b c
do
touch $i
rm $i
done
done
during the running of the scripts, i execute "ps -ef|grep rm" repeatedly to observe the "rm" process.
i found :
root 12716 11576 0 00:51:39 pts/2 0:00 [rm]
but suddenly the "[rm]"...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.