Skip to content
  • Home
  • News
  • Sample Code
  • How To
  • Tutorial
  • Assignment Help!

Student Assignment Help

Assignment Solution @ Assignment Help on Fiverr.com

  • Home
  • News
  • Sample Code
    • C/C++ Sample Code
      • C in Linux
        • Linux Kernel Module
      • C in Windows
    • Java Sample Code
    • Python Sample Code
    • New Jersey Standard ML (SML/NJ)
    • Oracle Sample Code
    • Database Analysis and Design Sample
  • How To
    • HTML-XML-CSS
    • Java
    • MySQL
    • Oracle
    • Linux RedHat
  • Tutorial
    • System Analysis and Design
    • Data Flow Diagram DFD
    • Database Analysis and Design
    • C/C++ Language
    • WordPress
      • WordPress Basic
      • WordPress Security
  • Assignment Help!

Category: How To

Oracle Kill Inactive Session

Posted on 2017-03-162017-03-16 By Presto Bear No Comments on Oracle Kill Inactive Session

1.Command to Kill Inactive Session SELECT * FROM v$session WHERE status =’INACTIVE’;   select ‘alter system kill session ”’ ||sid|| ‘,’ ||serial#|| ”’ immediate;’ as insess from v$session where status=’INACTIVE’; commit;   select ‘alter system kill session ”’ ||sid|| ‘,’ ||serial#|| ”’ immediate;’ from v$session where status=’INACTIVE’ and program is null and module is null;…

Read More “Oracle Kill Inactive Session” »

Oracle

Oracle Unlock for an Account

Posted on 2017-03-16 By Presto Bear No Comments on Oracle Unlock for an Account

1. Unlock for an Account alter user fel account unlock; grant connect, resource to fel;

Oracle

Oracle Export and Import Command

Posted on 2017-03-162017-03-17 By Presto Bear No Comments on Oracle Export and Import Command

Please use the Account that have Oracle permission   1. Export exp fel/fel@FEL FULL=Y FILE= FullExport.dmp OR expdp fel/fel directory=data_pump_dir dumpfile=export.dmp nologfile=y tables=fel.mytable OR expdp fel/fel@FEL directory=data_pump_dir dumpfile=export.dmp nologfile=y schemas=fel   2. Inport imp fel/fel@FEL FULL=Y FILE=FullExport.dmp OR impdp fel/fel@fel directory=data_pump_dir dumpfile=FullExport.dmp logfile=imp.log table_exists_action=replace OR impdp fel/fel@FEL dumpfile=FullExport.dmp nologfile=y schemas=fel remap_schema= fel:fel32

Oracle

Oracle Database Max Allowed Connection Active Connection

Posted on 2017-03-16 By Presto Bear No Comments on Oracle Database Max Allowed Connection Active Connection

1.The number of sessions the database was configured to allow SELECT name, value FROM v$parameter WHERE name = ‘sessions’; 2. The number of sessions currently active SELECT COUNT(*) FROM v$session

Oracle

Oracle Listener Configuration

Posted on 2017-03-162017-03-17 By Presto Bear No Comments on Oracle Listener Configuration

I. Oracle Listener Configuration File Location in Linux 1. $OracleHome/network/admin OR 2. /opt/oracle/network/admin   II. Files to Configure 1. listener.ora LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = myora.prestobear.com)(PORT = 1521)) ) ) +HOST = myora.prestobear.com We can put the host…

Read More “Oracle Listener Configuration” »

Oracle

Oracle Create a User

Posted on 2017-03-162021-06-27 By Presto Bear No Comments on Oracle Create a User

set verify off; drop user “FEL” cascade;   — Create tablespace FEL if not exist CREATE USER FEL IDENTIFIED BY FEL default tablespace FEL temporary tablespace TEMP QUOTA UNLIMITED ON FEL;   — Grant the whole DB to user FEL GRANT DBA TO “FEL”;   — Remember to commit; commit;

Oracle

Oracle Create a Role and Grant to User

Posted on 2017-03-16 By Presto Bear No Comments on Oracle Create a Role and Grant to User

— Create a role name CREATE ROLE role111;   — Assign permissions to a role GRANT CREATE session, CREATE table, CREATE view, CREATE procedure, CREATE synonym, ALTER table, ALTER view, ALTER procedure,ALTER synonym, DROP table, DROP view, DROP procedure, DROP synonym, TO role111;   — Grant role to a user called XXX GRANT role111 TO…

Read More “Oracle Create a Role and Grant to User” »

Oracle

Oracle Startup and Shutdown Database Command

Posted on 2017-03-162017-03-17 By Presto Bear No Comments on Oracle Startup and Shutdown Database Command

1.Shutdown Oracle DB Instance shutdown abort OR shutdown immediate

Oracle

Oracle User Command

Posted on 2017-03-162017-03-16 By Presto Bear No Comments on Oracle User Command

1.Show the current user sho user   2.To see all the privilege that we can grant to a role/user select * from system_privilege_map   3.Delete a User drop user FEL cascade; exit;

Oracle

Posts navigation

Previous 1 … 5 6
Assignment Help!!!

Key Posts

  • Chapter 5 – Crow’s Foot Notation
  • [SOLVED] Could not find this item. This is no longer located
  • Linux command to get Tomcat PID
  • Case Study: Entity Relationship Diagram (ERD) for Student Registration System
  • Sample Java Program for Triangle
Assignment Help!!!

Recent Posts

  • Windows 10: How to start Command Prompt as Admin and Terminate a process
  • Java How to Trust all Email Server
  • [Solved]: Windows 10 100% Disk Usage
  • Weddings, Parties, Everything Catering Services System
  • CSC/CPE 3350 Lab 4 Part 1 – Recursive File Search
  • Zayed University
  • Kitchen Gadgets
  • Food Ordering System
  • Investment bank XYZ Ltd
  • CSC/CPE 3350 Lab 3 – The Falcon Shell
  • CSC/CPE 3350 Lab 2
  • Analyzing Cost and Benefit: Campus Bikes
  • Emirates Top Auto Parts
  • Sports News
  • Workington Council
Assignment Help!!!

Copyright © 2022 Student Assignment Help.