oracle dba daily tasks

What Oracle DBA should do on a daily, weekly, and monthly basis (I) Check alert on a daily basis. log ② check the environment ● check whether the database instance is working properly ▼ ps-ef | grep ora _ explain select status from v $ instance ● whether the listener is working properly ▼ lsnrctl status ● whether the t

, memory, and external storage is quite Complex, these factors must be considered. In addition, pl/sql packages, stored procedures, temporary table empty , the table structure itself, all of these will become increasingly complex as they are used to ensure that the database Structural optimization, no garbage, is definitely more complicated than regular vacuum running from cron. Oracle DBA (DB adminstrator

better!6. Lack of space, load balancing in hotspot areasYou have an important tablespace that is being used all the time, he is big and big, and the LUN that corresponds to your storage cannot accommodate him, then how do you deal with it! Of course, for log files we can remove it to implement. But what about data files? ASM I thought you'd think that he would automatically balance file load and I/O distribution. Support for adding new disks online to ASM Disk Group!7. Wrong Operation

solution　　(3). Seek opportunities for database performance Adjustment　　Compare daily monitoring reports on database performance to determine whether it is necessary to adjust database performance　　(4). database performance Adjustment　　Adjust the performance if necessary　　(5) propose the next space management plan　　Based on weekly monitoring, this paper proposes an improvement method for space management.　　Routine

instance and database are started in three steps: 1. Start and instance (NOMOUNT ); 2. Mount the database (MOUNT); 3. Open the database (OPEN) 1. Start and instance in NOMOUNT state, ORACLE starts an instance, it reads the defined initial parameter values in the specified parameter file of SPFILE or PFILE. Allocate the SGA shared memory area and create background processes. You can use the RESTRICT and FORCE options to enable instances. In RESTRICT m

backup method and policy? What is the network file configuration? 19. Check the recent alert logs to obtain useful information. 20. run several performance analysis reports to see how the system is running recently. 21. Run an RDA report to collect the complete system status report. Well, with this basic information (incomplete), you have a general understanding of the system you are new to. Next, you can analyze it in depth, then we will formulate a set of O M specifications that meet the act

ORACLE DBA face Test setOne: SQL tuning class1 Enumerate several table connection wayssuch as connection, non-equal connection, self connection, outer connection (left, right, full)2 How to view SQL execution plan without the help of a third-party tool(I) Use explain plan to query plan_table;EXPLAIN PlanSET statement_id= ' QUERY1 'ForSELECT *From aWHERE aa=1;SELECT operation, Options, object_name, object_ty

: Describe the relationship between Tablespace and datafile4: The local management of the table space and the characteristics of the Dictionary management table space, what is the characteristics of ASSM5: What is the function of the rollback segment6: What is the function of the log7:sga mainly have those parts, what is the main roleWhat are the main functions of 8Oracle system process? Three: Backup Recovery class 1: How to Categorize backups2: What does archiving mean3: If a table is 10:30:00

(I) daily work ① Check alert. Log ② Confirm the environment ● Whether the database instance works properly ▼ PS-Ef | grep ora _ Explain select status from V $ instance ● Whether the listener works properly ▼ LSNRCTL status ● Whether the tablespace is faulty Explain select tablespace_name, status from dba_tablespace; ● Control whether files and log files are normal ▼ V $ controlfile Invalid v $ log, V $ logfile ③ Performance monitoring ● Pe

• Use schedulers to simplify administrative tasks • Create jobs, programs, and schedules • Monitor Job execution • Use a time based or event-based schedule to perform a scheduler job • Describe the purpose of Windows, window groups, job classes, and consumer groups • Use email notification • Use the job chain to perform a series of related tasks • Describes scheduler jobs on remote systems • Use advanced Sc

',attribute=> ' repeat_interval ',value=> ' freq=daily; byday=tue;byhour=3;byminute=0; Bysecond=0 ');Dbms_scheduler.set_attribute (name=> ' Wednesday_window ',attribute=> ' repeat_interval ',value=> ' freq=daily ; byday=wed;byhour=3;byminute=0; Bysecond=0 ');Dbms_scheduler.set_attribute (name=> ' Thursday_window ',attribute=> ' repeat_interval ',value=> ' freq=daily