Increase sga_max_size on Oracle 10g Windows

 

1:- Check file location of spfile/pfile

SQL> show parameter spfile;
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string

2:- Check the value of SGA

    
SQL> show parameter sga_
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sga_max_size                         big integer 20G
sga_target                           big integer 20G
unified_audit_sga_queue_size         integer     1048576

Increase sga_max_size on Oracle 10g Windows

alter system set sga_max_size=800M scope=spfile;
 
System altered.
 
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
 
Total System Global Area  838860800 bytes
Fixed Size                  2929936 bytes
Variable Size             390073072 bytes
Database Buffers          440401920 bytes
Redo Buffers                5455872 bytes
Database mounted.
Database opened.
SQL>  alter system set sga_target=800M scope=both;

 

done

 

source : https://dbsguru.com/step-by-step-how-to-increase-sga-size-in-oracle/

https://dba.stackexchange.com/questions/121553/increase-sga-max-size-on-oracle-10g-windows

Check the Usage of SGA in Oracle

 Check the Usage of SGA

select round(used.bytes /1024/1024 ,2) used_mb
, round(free.bytes /1024/1024 ,2) free_mb
, round(tot.bytes /1024/1024 ,2) total_mb
from (select sum(bytes) bytes
from v$sgastat
where name != 'free memory') used
, (select sum(bytes) bytes
from v$sgastat
where name = 'free memory') free
, (select sum(bytes) bytes
from v$sgastat) tot ;

   USED_MB    FREE_MB   TOTAL_MB
---------- ---------- ----------
    799.69      736.3       1536

Find the Total Size of SGA

SELECT sum(value)/1024/1024 "TOTAL SGA (MB)" FROM v$sga;
TOTAL SGA (MB)
--------------
1535.99715

Check size of different pool in SGA

Select POOL, Round(bytes/1024/1024,0) Free_Memory_In_MB From V$sgastat Where Name Like '%free memory%';

POOL           FREE_MEMORY_IN_MB
-------------- -----------------
shared pool                  564
large pool                   108
java pool                     32
streams pool                  32

How do I resolve 'The character device /dev/vboxdrv does not exist' error in Ubuntu 18.04 [closed]

 

It clearly states that you need to install the virtualbox-dkms packages. You can follow these steps to solve the problem.

    Install the virtualbox-dkms

sudo apt-get install virtualbox-dkms

    Once you install those packages you also need to do the reconfiguration:

sudo dpkg-reconfigure virtualbox-dkms
sudo dpkg-reconfigure virtualbox

    If your problem is still not fixed try installing the headers:

sudo apt-get install linux-headers-generic

source : https://stackoverflow.com/questions/60350358/how-do-i-resolve-the-character-device-dev-vboxdrv-does-not-exist-error-in-ubu

Why am I getting this laravel url routing error in .htaccess?

 

http://localhost/example-app/

to

http://localhost/example-app/public

 

just simple create .htaccess on root laravel project and type this script

By default the website will be load from public folder. If you want to remove public from your url,copy .htaccess file from public folder to root and replace the code with the following..

<IfModule mod_rewrite.c>
<IfModule mod_negotiation.c>
    Options -MultiViews
</IfModule>

RewriteEngine On


RewriteCond %{REQUEST_FILENAME} -d [OR]
RewriteCond %{REQUEST_FILENAME} -f
RewriteRule ^ ^$1 [N]

RewriteCond %{REQUEST_URI} (\.\w+$) [NC]
RewriteRule ^(.*)$ public/$1

RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule ^ server.php




If you don't want to remove all files and folder from the public folder, then just copy .htaccess to your root directory and rename server.php to index.php and last one step is if all resource files in /public directory couldn't find and request URLs didn't work for using asset() helper. Then, you need to add public to your helpers.php file.
function asset($path, $secure = null)
{
    return app('url')->asset($path, $secure);
}

To

function asset($path, $secure = null)
{
    return app('url')->asset("public/".$path, $secure);
}

You will fine the helpers.php in vendor/laravel/framework/src/Illuminate/Foundation/helpers.php.

source : https://stackoverflow.com/questions/58230970/why-am-i-getting-this-laravel-url-routing-error-in-htaccess

How to fix Error: laravel.log could not be opened?

The stream or file "/media/data1/opt/lampp/htdocs/example-app/storage/logs/laravel.log" could not be opened in append mode: failed to open stream: Permission deniecd laravel/

sudo chmod -R 777 storage

How To Install and Use Composer on Ubuntu 20.04

 Introduction

Composer is a popular dependency management tool for PHP, created mainly to facilitate installation and updates for project dependencies. It will check which other packages a specific project depends on and install them for you, using the appropriate versions according to the project requirements. Composer is also commonly used to bootstrap new projects based on popular PHP frameworks, such as Symfony and Laravel.



In addition to dependencies that should be already included within your Ubuntu 20.04 system, such as git and curl, Composer requires php-cli in order to execute PHP scripts in the command line, and unzip to extract zipped archives. We’ll install these dependencies now.

1.

    sudo apt update

2.

    sudo apt install php-cli unzip

3.

Make sure you’re in your home directory, then retrieve the installer using curl:

    cd ~
    curl -sS https://getcomposer.org/installer -o composer-setup.php

4.

    HASH=`curl -sS https://composer.github.io/installer.sig`

5.

    echo $HASH

Output
e0012edf3e80b6978849f5eff0d4b4e4c79ff1609dd1e613307e16318854d24ae64f26d17af3ef0bf7cfb710ca74755a

6.

Now execute the following PHP code, as provided in the Composer download page, to verify that the installation script is safe to run:

    php -r "if (hash_file('SHA384', 'composer-setup.php') === '$HASH') { echo 'Installer verified'; } else { echo 'Installer corrupt'; unlink('composer-setup.php'); } echo PHP_EOL;"

You’ll see the following output:
Output

Installer verified

If the output says Installer corrupt, you’ll need to download the installation script again and double check that you’re using the correct hash. Then, repeat the verification process. When you have a verified installer, you can continue.

To install composer globally, use the following command which will download and install Composer as a system-wide command named composer, under /usr/local/bin:

    sudo php composer-setup.php --install-dir=/usr/local/bin --filename=composer

You’ll see output similar to this:

Output
All settings correct for using Composer
Downloading...

Composer (version 1.10.5) successfully installed to: /usr/local/bin/composer
Use it: php /usr/local/bin/composer

https://www.digitalocean.com/community/tutorials/how-to-install-and-use-composer-on-ubuntu-20-04