Mainly that extents are managed locally within the tablespace using bitmaps rather than on the dictionary. This improves perfomance since there is no overhead looking up extents for dmls.
User needs to be granted select any dictionary to show parameters. I would not grant this privilege to an ordinary user unless they really need it and you are aware of the implications of the privilege
In the ORACLE_HOME/rdbms/demo/rdbms folder there are four scripts case1.rcv, case2.rcv, case3.rcv and case4.rcv. If you go through those scripts they will help you set up your backup procedures with rman.
Obviously you will need to read up on backup and recovery as well as RMAN in the oracle...
Have you started a listener. If not then you need one. lsnrctl status will tell you if you have a default listener started and lsnrctl start will start a default listener.
I'm assuming that you have set instance name and service names parameters in your parameter file so that dynamic service...
set remote_login_passwordfile to exclusive and set up the password file. Grant sysdba to the user you want to connect as sysdba. Make sure the no unnecessary users are member of the dba group.
This files stores variuos messages about your oracle database as well errors(internal). You should regurarly parse this file to check for warnings and errors especially ora 600 errors.
You can delete the file and oracle will create a new one.
Not really as undo_retention is only a target. However, the value for UR will be useful in calculating the size of your undo using the formula (UR*Block_size* undo blocks per second) + block size. Basically you want to size your undo so that the before image is found in the undo if it is...
basically you are trying to create a view that already exists. You need to either give it a new name or replace it.
Try Create o replace view instead of create view.
archive logs are a copy of your redo log. I know you can use log-miner to look at the content of online redo logs, but I haven't tried it on the archive logs. They are basically used to recover your db to a point in time.
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.