When completing all transactions, the database instance disconnects all the currently connected users from the database and shuts down. The database instance also does not accept any new transaction after a SHUTDOWN TRANSACTIONAL. This saves the work for all users without requesting them to log off. The SHUTDOWN TRANSACTIONAL waits for all uncommitted transactions to complete before shutting down the database instance. The SHUTDOWN or SHUTDOWN NORMAL is not really practical because you practically cannot wait for all users to come back to their desks and disconnect from the database. Therefore SHUTDOWN and SHUTDOWN NORMAL commands have the same effect. The NORMAL is the default option if you don’t explicitly specify any option. The SHUTDOWN NORMAL does not require an instance recovery on the next database startup. The database instance will not accept any further database connection. The SHUTDOWN NORMAL option waits for the current users to disconnect from the database before shutting down the database. Let’s examine each option of the SHUTDOWN command. Total of 1 processors activated (4020.89 BogoMIPS).SHUTDOWN ]Ĭode language: SQL (Structured Query Language) ( sql ) NMI watchdog: enabled on all CPUs, permanently consumes one hw-PMU counter. CPU0: AMD Athlon(tm) 64 Processor 3000+ stepping 00 ftrace: allocating 17956 entries in 71 pages Inode-cache hash table entries: 131072 (order: 8, 1048576 bytes) Dentry cache hash table entries: 262144 (order: 9, 2097152 bytes) AppArmor: AppArmor disabled by boot time parameter Calibrating delay loop (skipped), value calculated using timer frequency. Marking TSC unstable due to TSCs unsynchronized please try 'cgroup_disable=memory' option if you don't want memory cgroups Dump stacks of tasks blocking RCU-preempt GP. RCU dyntick-idle grace-period acceleration is enabled. Preemptible hierarchical RCU implementation. SLUB: Genslabs=15, HWalign=64, Order=0-3, MinObjects=0, CPUs=2, Nodes=1 PID hash table entries: 4096 (order: 3, 32768 bytes) Kernel command line: BOOT_IMAGE=/boot/vmlinuz-linux root=UUID=55614e59-14b9-47c5-a609-fd76662e6403 ro systemd.log_level=debug systemd.log_target=kmsg log_buf_len=1M enforcing=0 quiet Built 1 zonelists in Node order, mobility grouping on. setup_percpu: NR_CPUS:64 nr_cpumask_bits:64 nr_cpu_ids:2 nr_node_ids:1 Booting paravirtualized kernel on bare hardware Using ACPI (MADT) for SMP configuration information ACPI: INT_SRC_OVR (bus 0 bus_irq 15 global_irq 15 high edge) ACPI: INT_SRC_OVR (bus 0 bus_irq 14 global_irq 14 high edge) ACPI: INT_SRC_OVR (bus 0 bus_irq 9 global_irq 9 high level) ACPI: INT_SRC_OVR (bus 0 bus_irq 0 global_irq 2 dfl dfl) IOAPIC: apic_id 2, version 17, address 0xfec00000, GSI 0-23 ACPI: LAPIC_NMI (acpi_id high edge lint) If you got timer trouble try acpi_use_timer_override kernel direct mapping tables up to 0x5ffeffff Base memory trampoline at 96000 size 24576 Aperture from AGP e0000000 size 32 MB (APSIZE 0) Aperture size 4096 MB (APSIZE 0) is not right, using settings from NB Aperture from AGP e0000000 old size 32 MB Command line: BOOT_IMAGE=/boot/vmlinuz-linux root=UUID=55614e59-14b9-47c5-a609-fd76662e6403 ro systemd.log_level=debug systemd.log_target=kmsg log_buf_len=1M enforcing=0 quiet
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |