Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How would you force a log switch?

Answer Posted / amsu

ALTER SYSTEM CHECKPOINT GLOBAL; AND
ALTER SYSTEM ARCHIVELOG CURRENT;

Is This Answer Correct ?    0 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

1761


what is the use of recording information about current session?

1054


how to restore files with rman?

2304


What purpose does the model database server? : sql server DBA

1193


What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

1008


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2464


What the different types of replication and why are they used? : sql server DBA

1178


Where would you look for errors from the database engine?

2853


internal architecture

2197


how can you initialize log miner?

1146


In what script is "snap$" created? In what script is the "scott/tiger" schema created?

2440


. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

2443


Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2636


what functionality does oracle provide to secure sensitive information?

995


Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

2299